Summary: | FILEOPEN Excel 2003 XML: Certain cells are not recalculated on open | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Thomas Krumbein <tk> |
Component: | Spreadsheet | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | QA Contact: | |
Severity: | normal | ||
Priority: | medium | CC: | cno, gerard.fargeot |
Version: | 4.3.2.2 release | ||
Hardware: | All | ||
OS: | Windows (All) | ||
Whiteboard: | |||
i915 platform: | i915 features: | ||
Bug Depends on: | |||
Bug Blocks: | 86100 | ||
Attachments: |
orginal execel sheet view (Picture)
file opened in calc (picture) correct formula in calc - wrong result (picture) original excel file |
Created attachment 109199 [details]
file opened in calc (picture)
Created attachment 109200 [details]
correct formula in calc - wrong result (picture)
Created attachment 109201 [details]
original excel file
Still in 4.4. Does hard refresh work (Ctrl+Shft+F9) ? Did this work properly before? thanks - Cor |
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 109198 [details] orginal execel sheet view (Picture) I do have a very angry issue - and I am not sure, where the reasons are. Background: Amazon delivers to there sellers a monthly report in Format *.xls. This report is the base of the invoice. Well, it is a simple Excel-sheet with some formulas but without any spezilists. If you open the file in Excel (all versions) or in an excel-Viewer (im am using the Panmaker Viewer) - everything ist ok (see Pic Org_Excel_20141110.png). If I open the file with LibreOffice Calc, most things looks like in Excel - but there are two exeptions: - Date-Values where not imported or interpretation failed. - Bigger issue: Instead of the corret Sum -Formulas the value 4,500 is displayed and all further formulas use this value as base. See picture Calc_Import_20141110.png). Looking detailed to the Issue: The formua of the sum-cells is imported correct (see picture Calc_Formula_20141110.png). The formula uses rangenames which where also imported correct. I do not know, where the value "4.500" is coming from?? Interesting: If I copy the formula of the cell, delete then the formula in the cell and paste the formula again - the correct value will be displayed and provided. So - the formula works correct even in LibO. Nevertheless it is a lot of work to correct manual all formulas. For futher tests I will provide one original xls-file. Be aware, that if you open the file in calc and change something and save the file (xls or ods) you may have new issues ang changes! so please work with copies.