https://bugs.freedesktop.org/show_bug.cgi?id=86097
Bug ID: 86097
Summary: [Filter] Excel xls Formulas doesn´t work - since LibO
3.x - still not solved
Product: LibreOffice
Version: 4.3.2.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
Assignee: [email protected]
Reporter: [email protected]
Created attachment 109198
--> https://bugs.freedesktop.org/attachment.cgi?id=109198&action=edit
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.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
