https://bugs.documentfoundation.org/show_bug.cgi?id=141940
Bug ID: 141940
Summary: ODS File Corrupted. Error found in content.xml.
Product: LibreOffice
Version: 7.0.5.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: matchstickma...@gmx.com
Description:
I was mid way through modifying an .ods spreadsheet when Calc slowed to a crawl
and became unresponsive. I believe this may have been due to it auto-saving,
and at the time my system was under a heavy load. I was processing some videos
files in the software VidCoder, version 5.21. This may have been the moment
when this corruption occurred to the file. After a short while Calc became
responsive again. I was able to finish doing what I was doing and saved the
file.
However, whenever I have subsequently tried to open the file, Libre just goes
blank and doesn't respond. I have left it in this state for a number of hours
without any further progression.
Looking online I learnt about changing the ods file to a zip, so as to gain
access to the xml files and such. I have compared the content.xml file to
another which was saved at an earlier date and was eventually able to pinpoint
where the fault seems to lie.
Under the <table:content-validation line there were a number of values which
had been changed for <text:s text:c=
Most of these had been changed to <text:s text:c="67108864"/>
Some had been changed to <text:s text:c="33554432"/>
And some entries which didn't even exist in my older file had been added as
<text:s text:c="16777216"/>
I don't even know what these values are used for, but I thought I should make a
report as the numbers may be an indicator of what has caused the problem. Of
course the obvious thing which pops out is that
16777216 * 2 = 33554432
33554432 * 2 = 67108864
Replacing all of the data within <table:content-validation with that from my
earlier file, I was able to fix the file. Also, it should be noted that all the
cells containing these Data Validation entries are located on one sheet within
this spreadsheet. I don't believe I even viewed that sheet yet alone made any
modifications to it when this issue occurred.
System
Processor Intel(R) Core(TM) i7-6700K CPU @ 4.00GHz 4.00 GHz
Installed RAM 16.0 GB (15.7 GB usable)
System type 64-bit operating system, x64-based processor
Edition Windows 10 Pro
Version 20H2
OS build 19042.928
Experience Windows Feature Experience Pack 120.2212.551.0
Actual Results:
-
Expected Results:
-
Reproducible: Didn't try
User Profile Reset: No
Additional Info:
-
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs