Summary: | Regression: Formulas lost when opening XLSX file | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Vlad Lungeanu <drvladl> |
Component: | Spreadsheet | Assignee: | Markus Mohrhard <markus.mohrhard> |
Status: | RESOLVED FIXED | QA Contact: | |
Severity: | major | ||
Priority: | medium | CC: | carlton.hobbs, drvladl |
Version: | 3.4.1 release | ||
Hardware: | x86 (IA32) | ||
OS: | Linux (All) | ||
Whiteboard: | target:3.5 target:3.4.2 | ||
i915 platform: | i915 features: | ||
Attachments: | Simple XLSX file with a few sums |
After a quick look into the document the problem are cells containing: t="shared" ref="H3:H9" Let me have a look if I can fix it for 3.4.2 > Let me have a look if I can fix it for 3.4.2
Great, thank you!
*** Bug 39148 has been marked as a duplicate of this bug. *** first part sent to the mailing list for review we have two problems here: -cell that contains shared formula was not set correctly (fixed with this patch) -all other cells didn't get a formula but only the value thanks to muthu the second part is fixed too, will be in 3.4.2RC2 Tested in LibO 3.4.2rc2 Linux X64 : OK Thanks a lot! :-) |
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.
Created attachment 48841 [details] Simple XLSX file with a few sums When opening an XLSX file in LibreOffice 3.4 or 3.4.1, all formulas are lost, being replaced with their values or with #NAME errors. The same XLS file opens perfectly in LibreOffice 3.3.3 System: Kubuntu 11.04, 32 bit LibreOffice: 3.4.0 and 3.4.1, installed from DEBS from www.libreoffice.org