https://bugs.freedesktop.org/show_bug.cgi?id=82135
Priority: medium
Bug ID: 82135
Assignee: [email protected]
Summary: Cell references don't resolve in imported Excel sheet,
but do after edit
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: unspecified
Component: Spreadsheet
Product: LibreOffice
I'm generating xlsx spreadsheets with PHPExcel. These open perfectly in Excel
2011, LibreOffice 4.2.0 and Apple Numbers. In LibreOffice 4.2.5 the cells
display a 0 value for formulae referencing other sheets. If I edit a cell and
retype any character, the calculation then shows the correct value from the
referenced cell. To be clear, all I have to do is edit the cell in a way that
does not change it at all and it starts working.
I notice that LibreOffice changes the cell contents on import. It is originally
created like this:
='sheet name'!B9
and LibreOffice converts it to:
=$'sheet name'.B9
That formula is perfectly valid, but always shows 0. If I do a null edit (for
example, delete the 9 at the end then retype it) and hit return, it shows the
correct value, and I have to do this to all cells before they work.
I've also found that cross-sheet named references don't work at all when
imported from Excel format, for example:
='sheet name'!myrange
is flagged as an error, even though the named range exists in the target sheet
according to the names dialogue (insert -> names -> manage).
--
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
