[Libreoffice-bugs] [Bug 141940] New: ODS File Corrupted. Error found in content.xml.

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: matchstickman25 at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210427/5f760a3f/attachment.htm>