https://bugs.freedesktop.org/show_bug.cgi?id=68176
Priority: medium
Bug ID: 68176
Assignee: [email protected]
Summary: FILEOPEN: Incorrect import of formula when .ods
created with MSO Excel 2007
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.1.0.4 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 84130
--> https://bugs.freedesktop.org/attachment.cgi?id=84130&action=edit
Test file created in Excel 2007 based on Kohei's test file, but only 87 rows
Problem description:
When you open a .ods created with Excel, LibreOffice appends "msoxl:" before
the formula. A "=A1*1.1" thus becomes "msoxl:=A1*1.1", which can only be
evaluated as text.
Steps to reproduce:
1. Excel 2007: Create a new worksheet
2. Excel 2007: Enter formulas as per Kohei's shared-formula-memory-test.ods
(see "http://kohei.us/2013/08/15/shared-formula-to-reduce-memory-usage/";)
3. Excel 2007: File > Save As > Open Document Spreadsheet"
4. LibreOffice 4.1: Open the above document
Current behavior:
Cells contain text that can not be evaluated as formula. Example for row "B",
in column order:
"msoxl:=A1+1", "msoxl:=A2*1.1", "msoxl:=B2/100*PI()", "msoxl:=SUM(A2:C2)"
Expected behavior:
Cells should contain formulas. Example for row "B", in column order:
"=A1+1", "=A2*1.1", "=B2/100*PI()", "=SUM(A2:C2)"
System:
Windows 7 SP1 64-bit [en], MSO Excel 2007 SP3 [sl], LibreOffice 4.1.0.4 Release
[en]
Operating System: Windows 7
Version: 4.1.0.4 release
--
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
