https://bugs.documentfoundation.org/show_bug.cgi?id=51495
Hendy Irawan <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- Status|RESOLVED |REOPENED Resolution|WORKSFORME |--- --- Comment #29 from Hendy Irawan <[email protected]> --- I spoke too soon. Even 4.4.4.3 still exhibits this problem, however it requires a more complex, multi-thousand rows (16000 did it in my case) to trigger the problem. v4.4.4.3's corruption exhibits this behavior: 1. After saving a problematic workbook as XLSX, reopening the file in LO 4.4.4.3 will seem as there's no problem. But several cells in the workbook are *emptied silently* ! No warnings. This is a very destructive and dangerous behavior, because can result in (unknowingly) data-loss. 2. After saving a problematic workbook as XLSX, opening the file in Excel 2013 will trigger a warning: "We found a problem with some content in 'application_2015-07-10.xlsx'. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes." After clicking Yes, Excel will display the file and lots of cells are emptied. The diagnostics messages from Excel 2013 are as follows: Removed Part: /xl/sharedStrings.xml part with XML error. (Strings) Illegal xml character. Line 2, column 113479. Removed Records: Cell information from /xl/worksheets/sheet1.xml part The XML log is: (same info as human-readable messages above) <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main";><logFileName>error011640_01.xml</logFileName><summary>Errors were detected in file 'D:\Downloads\ppdb\applicant_2015-07-10.xlsx'</summary><removedParts summary="Following is a list of removed parts:"><removedPart>Removed Part: /xl/sharedStrings.xml part with XML error. (Strings) Illegal xml character. Line 2, column 113479.</removedPart></removedParts><removedRecords summary="Following is a list of removed records:"><removedRecord>Removed Records: Cell information from /xl/worksheets/sheet1.xml part</removedRecord></removedRecords></recoveryLog> Unfortunately my 16000 row file is private, so will need another test case for v4.4.4.3. -- 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
