https://bugs.freedesktop.org/show_bug.cgi?id=74538
Priority: medium
Bug ID: 74538
Assignee: [email protected]
Summary: Gives reference errors on opening Excel files (xls,
xlsx)
Severity: major
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: All
Status: UNCONFIRMED
Version: 4.2.0.4 release
Component: Spreadsheet
Product: LibreOffice
When opening a complicated Excel file
(taken from
http://www.ene.gov.on.ca/environment/en/resources/STDPROD_086520.html )
in V.2.0.4 of calc, there were many cells that came up with a reference error.
This did not occur in opening the same file in LibreOffice V4.1.
I could not determine the exact conditions or algorithms under which the error
occurs, as there seemed to be a bit of a random nature to them.
In checking this one out, you may wish to look at the "Tier 2 Input tab of the
above spreadsheet, in rows 69 on, or in "final tables of standards" tab.
I set this one as a "Major" problem because it will likely occur elsewhere, and
it has the potential to severely limit the ability of people to use LibreOffice
for Excel files.
p.s. LibreOffice 4.1 handles the file perfectly, except for altering the number
format to scientific when there is conditional formatting. (see tab "Tables of
Drivers - Soil)
--
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
