https://bugs.freedesktop.org/show_bug.cgi?id=79998

--- Comment #8 from Victor V. Terber <[email protected]> ---
- I created a smaller test case. Please see the new attachments with name
"Bug79998ReducedTestCase.ods" and "Bug79998ReducedTestCase.xlsx"

- I only now noted that Excel 2010 (when trying to open the LO-exported
document) reports that it had to repair parts of "/xl/workbook.xml"

- I therefore unzipped the Excel format file and had a look into the content.
As the problem is (as originally described) related to the name of a sheet, I
looked for the affected sheet name.

In "workbook.xml" I found this:

<sheet r:id="rId3" state="visible" sheetId="2" name="Utilities (FX Kurse,
Kreditkarten etc)"/>

In "sheet1.xml" I found the following:

<f aca="false">'Utilities (FX Kurse, Kreditkarten etc)'!A1</f>

Notice the apostrophes at the start and the end of the name in the second
instance, which are missing in the first instance. Experimentally I removed
these apostrophes from file "sheet1.xml". Result: Excel opened the file, and
now showed the value in cell A1 correctly! The modified (working) Excel file is
attached with name
"Bug79998ReducedTestCase_ManuallyRemovedApostrophesFromSheet1XML_SoThatItWorksNow.xlsx"

Could please a LO developer have a look into this?

-- 
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

Reply via email to