https://bugs.documentfoundation.org/show_bug.cgi?id=106589
Bug ID: 106589
Summary: Invalid saving XLSX documents with hidden rows
Product: LibreOffice
Version: 5.3.0.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
When XLSX document contains many hidden rows, LibreOffice saves them
incorrectly.
Steps to Reproduce:
1. Open MS Excel
2. Create new spreadsheet
3. Hide all columns except A
4. Hide all rows except 1
5. Save it as test_excel.xlsx
6. Check file size and ensure saved file opens in Excel and looks the same
(would be 15 KB)
7. Open LibreOffice
8. Open created document and save it as "test_libreoffice.xlsx"
9. Check resulting file size and open it in Excel
Actual Results:
- File size is 3MB (i.e. 500x BIGGER)
- File opens long time (10+ seconds, i.e. 10x LONGER)
Expected Results:
- File size is about 15 KB (no data increase)
- File opens as fast as test_excel.xlsx file (~1 second)
Reproducible: Always
User Profile Reset: No
Additional Info:
There is a similar problem with openpyxl. Maybe fix should be done together.
https://bitbucket.org/openpyxl/openpyxl/issues/777/invalid-support-for-hidden-rows
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.12; rv:51.0)
Gecko/20100101 Firefox/51.0
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
