https://bugs.freedesktop.org/show_bug.cgi?id=70455
Priority: medium
Bug ID: 70455
Assignee: [email protected]
Summary: VIEWING: xlsx files saved in excel on windows viewed
on libre calc in ubuntu using the INDIRECT function
inside the SUM function
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.1.1.2 release
Component: Spreadsheet
Product: LibreOffice
Problem description: When I open an xlsx file with libre calc in Ubuntu that
when I saved it with excel in windows had the value
=SUM(N2:INDIRECT(ADDRESS(ROW()-1,COLUMN()))),
in libre in Ubuntu it has the value
=SUM(N2:N2(ADDRESS(ROW()-1,COLUMN())))
triggering error 509.
This has happened on two separate files (not both in cell N2).
Operating System: Ubuntu
Version: 4.1.1.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