https://bugs.freedesktop.org/show_bug.cgi?id=69114
Priority: medium
Bug ID: 69114
Assignee: [email protected]
Summary: Some exported XLS files (using matrix formulas) will
crash in Excel (this is a regression)
Severity: normal
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: UNCONFIRMED
Version: 4.1.1.2 rc
Component: Spreadsheet
Product: LibreOffice
Created attachment 85449
--> https://bugs.freedesktop.org/attachment.cgi?id=85449&action=edit
Folder containing ODS version of test sheet and two XLS exports
Exporting a spreadsheet to XLS (Excel 97 format), where the spreadsheet
contains a matrix formula, will result in a sheet, which will likely crash
Excel (here Excel 2013).
The problem does not appear with OpenOffice 4.0 (and with earlier versions of
LibreOffice).
The problem is 100% reproducible (and a big one for me, since I have to switch
to OpenOffice or earlier Versions of LibreOffice ;-).
To reproduce:
1. Open the attached file LibreOfficeExportXLSBug.ods in OpenOffice and
LibreOffice respectively.
2. Export the sheet via "Save as... XLS" using the respective program.
3. Open the exported sheet in Excel 2013 (Windows).
4. Notice that cell I17 looks different depending on whether the sheet was
exported from LibreOffice or OpenOffice.
5. Select cell I16, click in the formula and press CTRL-SHIFT-ENTER (the
command to calculate the formula).
Result:
a) Excel will crash for the sheet exported with LibreOffice.
b) Excel will work as expected for the sheet exported with OpenOffice.
For your convenience, my attachments also contains the two different versions
of the XLS resulting from export using OpenOffice and LibreOffice respectively.
--
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
