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.
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.