https://bugs.freedesktop.org/show_bug.cgi?id=55181
Bug #: 55181
Summary: FILESAVE as .XLS corrupts spreadsheet, losing many
rows of data
Classification: Unclassified
Product: LibreOffice
Version: 3.6.1.2 release
Platform: Other
OS/Version: Windows (All)
Status: UNCONFIRMED
Severity: critical
Priority: medium
Component: Spreadsheet
AssignedTo: libreoffice-bugs@lists.freedesktop.org
ReportedBy: rossni...@gmail.com
I received an XLS (97/2003) s/s that had about 300 rows of data, some header
cells that were merged across and down several cells, some hidden rows at the
top.
There were no macros, no formulas, just simple formatting and a few comments on
a few cells.
After adding extra columns, doing some manipulation like 'text to column',
deleting some columns, simplifying headers etc, all looked good. I was saving
as I went, in the same .XLS (97/2003) format. Closed and reopened the s/s.
About 90% of the rows were now invisible. I assumed they were lost, as
selecting a now empty cell did not reveal content in the data entry line.
Assuming some non-LibreOffice error, I repeated the above the next day, with
some minor variations. The same major loss occurred.
I then opened the corrupt file with MS Office 2010 Starter. It advised there
was corruption. I forced this to continue and successfully recovered all the
raw data.
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
