https://bugs.freedesktop.org/show_bug.cgi?id=63181
Priority: medium
Bug ID: 63181
Keywords: regression
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: FILESAVE: Calc Saves Bloated & Corrupt .xslx File
Severity: normal
Classification: Unclassified
OS: Linux (All)
Reporter: caj-b...@cjconsult.com
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.0.2.2 release
Component: Spreadsheet
Product: LibreOffice
Problem description: Recently, Calc began corrupting small .xlsx files. I
currently have LO 4.0.2-1 installed on Arch Linux on a new i7 computer with 16
MB of memory and lots of free disk space. I ran pacman -Syu yesterday morning.
Steps to reproduce: I wish I could describe the steps. It just happens.
Current behavior: The only symptom seems to be that Calc takes 10 - 15 seconds
to save a file that it previously saved in <1 second. The most recent instance
is a newly-created spreadsheet with two tabs. Each tab has two columns (one
date and one numeric) and less than 60 rows of data with no formulas. When
correctly saved, the file is less than 20 KB. After The Problem occurs, the
saved file is 3.2 MB. When I reopen this large file, Calc ceases to respond and
I have to kill the process; any other spreadsheets which are currently open are
also rendered non-functional.
This problem cropped up "fairly recently" (though I can't tell whether it
reaches back to prior to the LO 4.0 installation) and has corrupted perhaps
three or four files, some of which are brand new and some that I have used
every day for many months.
I have been able to recover all but one of the files with Excel 2010 on my
wife's Windows 7 computer. When opening the 3.2 MB file that hangs Calc, Excel
opens a dialog that reads:
Excel found unreadable content in 'Weight.xlsx'.
Do you want to recover the content of this workbook?
If you trust the source of this workbook, click 'Yes'.
Excel works several seconds after clicking "Yes" and opens another dialog that
reads:
Excel was able to open the file by repairing or removing the unreadable
content.
Removed records: Cell information from /xl/worksheets/sheet2.xml part
The log file that Excel offers contains:
<?xml version="1.0" encoding="UTF-8" standalone="true"?>
- <recoveryLog
xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main";>
<logFileName>error050480_01.xml</logFileName>
<summary>Errors were detected in file 'E:\Weight.xlsx'</summary>
- <removedRecords summary="Following is a list of removed records:">
<removedRecord>Removed Records: Cell information from
/xl/worksheets/sheet2.xml part</removedRecord>
</removedRecords>
</recoveryLog>
The spreadsheet is now workable in Excel, but Excel still saves it very large
(~2.7 MB). After I delete all the columns to the right of the last populated
cell and all the rows below it, Excel will save the file at a proper size: 11
KB. Calc will now also open it successfully.
In one instance, I had to copy the data from the corrupt file and paste it into
a new spreadsheet to resolve the problem.
Expected behavior: Well, Calc should save files without mangling them. Sorry,
but this seems obvious.
I will later upload an offending 3.2 MB file, but my bug report has been
rejected twice whentrying to include it originally.
Happy to provide any more information I can to help resolve this problem.
Thanks.
Operating System: Linux (Other)
Version: 4.0.2.2 release
Last worked in: 3.6.5.2 release
--
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
