| Summary: | FILESAVE: after particular XLSX saving document structure is lost and it could not be opened in MSO | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Timon <kaktebyavirubit> |
| Component: | Spreadsheet | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | NEW --- | QA Contact: | |
| Severity: | normal | ||
| Priority: | medium | CC: | bfo.bugmail, quest-88, uldis+libreoffice |
| Version: | 4.0.3.3 release | ||
| Hardware: | All | ||
| OS: | All | ||
| Whiteboard: | |||
| i915 platform: | i915 features: | ||
| Attachments: |
Example_32_1.xlsx - original file, Example_32_2.xlsx - resaved in LibO, error055480_01.xml - error log from MSO
Broken export to xlsx Additional files for testing |
||
Confirmed with: LO 4.2.0.0.alfa0 Build ID: 2013-06-24 own debug build Windows 7 Professional SP1 64 bit Document structure has been completely lost. Error when changed D22 from 0 to 1, saved as xlsx and opened in Excel 2010: /xl/worksheets/sheet1.xml with XML error. Illegal qualified name character. Row 2, Column 96787. Created attachment 88362 [details]
Broken export to xlsx
Hey
I still can confirm existing bug. I attached "broken export to xlsx". If you resave document to XLSX, MS Excel won't open document. Tested under 4.1 and 4.2 DEV
LibreOffice Version: 4.3.0.4 Build ID: 62ad5818884a2fc2e5780dd45466868d41009ec0 on Russian Windows XP Professional SP3 (32bit) Much better, but not perfect. Document structure is lost, but visually file became more similar to the orginal after reopening (font and backround colors lost in some places, but some are as it was in original (for example, D259:D260 is as in original file); bold text is lost. Problem places - A30:AMJ30 or A47:AMJ47 or D41:D46 and so on. Problem with columns default width is fixed (they are similar to original file). File COULD be opened in MSOffice suite now (tested in 2007), but continues to report an error. First we see the following message - In Example_32_2.xlsx found content that could not be read. Try to restore content of the file? If you trust the source of this file, click "Yes." After that MSOffice says that "There are errors in file... But after that we can see file content. It's not perfect, but we can see it! Bug still present in LO 4.3.4.1 . Saved *.xlsx fails to open in Microsoft office 2007 and 2010. Added more files for testing - original *.ods, resulting *.xlsx and *.xls - just in case. Created attachment 109719 [details]
Additional files for testing
More files for testing - original *.ods, resulting *.xlsx and *.xls - just in case.
|
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.
Created attachment 80264 [details] Example_32_1.xlsx - original file, Example_32_2.xlsx - resaved in LibO, error055480_01.xml - error log from MSO LibreOffice Version: 4.0.3.3 Build ID: 0eaa50a932c8f2199a615e1eb30f7ac74279539 on Russian Windows XP Professional SP3 (32bit) If we try to open Example_32_1.xlsx file in LibreOffice and make any changes (for example, in cell D22 we change 0 -> 1), save file in existent format (Microsoft Excel 2007/2010 XML (.xlsx)) and close LibreOffice after that, then the next time we try to open that file (see Example_32_2.xlsx) we see that document structure has been completely lost (font and backround colors lost, bold text is lost, all columns have default width, ...) and the worst thing that file could not not be opened in MSOffice suite anymore (tested in 2003 and 2007). MSOffice says that "There are errors in file. List of removed components is below: Replaced component: part /xl/worksheets/sheet1.xml with XML error. Download failed. Row 2, Column 135408"