https://bugs.freedesktop.org/show_bug.cgi?id=73210
Priority: medium
Bug ID: 73210
Assignee: [email protected]
Summary: FILEOPEN: Opening .xlsx corrupts some INDIRECT
formulas
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.1.3.2 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 91402
--> https://bugs.freedesktop.org/attachment.cgi?id=91402&action=edit
Sample .xlsx document exhibiting the issue
INDIRECT is removed from some cells Problem description:
Steps to reproduce:
1. Create a spreadsheet and add a formula like this
=AVERAGE(A1:INDIRECT("A"&D1))/12
2. Save spreadsheet as .xlsx
3. Close spreadsheet
4. Reload spreadsheet
Current behavior:
Cell formula after reloading is =AVERAGE(A1:A1("A"&D1))/12
Expected behavior:
Loaded formula should be the same as when saved and created
=AVERAGE(A1:INDIRECT("A"&D1))/12
Additional note:
Saving the document as .ods does not exhibit this issue, but it is not
interoperable with Excel so not a practical workaround.
Operating System: Windows 7
Version: 4.1.3.2 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
