ODS file has a format error

Issues with installing under all versions of MS Windows
Locked
elijahs
Posts: 2
Joined: Fri Aug 09, 2024 2:54 pm

ODS file has a format error

Post by elijahs »

A ODS file (118kb) when trying to open gives me a error message. "Format error discovered in the file in sub-document content.xml at 2,501726(row,col)". I tried using the fixes in this forum but can't even get into seeing the content step. Guess I'm too old (78) and my memory is full. Lol Lost count on how many different computer office programs and CAD systems I have learned over the years being a Design ME. I think what happened is that I shutdown pc before file was fully closed.
Would very much appreciate if someone could fix this. Thank You
Attachments
Expenses 2025.ods
(117.65 KiB) Downloaded 11 times
OpenOffice 4.1.15 64-bit operating system, x64-based processor Windows 10
User avatar
MrProgrammer
Moderator
Posts: 5318
Joined: Fri Jun 04, 2010 7:57 pm
Location: Wisconsin, USA

Re: ODS file has a format error

Post by MrProgrammer »

elijahs wrote: Wed Jul 09, 2025 2:32 pm I think what happened is that I shutdown pc before file was fully closed.
Hundreds of people have had their files corrupted doing that. Always give the operating system plenty of time to save a file to disk. How long? Depends on your hardware and operating system.

elijahs wrote: Wed Jul 09, 2025 2:32 pm Would very much appreciate if someone could fix this.
The file seems to be badly damaged, and I don't see any way to repair it. Restore from a backup, if you have one.
Read section 6. Saving your data and making backups in Ten concepts that every Calc user should know.

$ mkdir unzip
$ cd unzip
$ $ unzip ../Expenses\ 2025.ods content.xml
Archive:  ../Expenses 2025.ods
  inflating: content.xml             
$ xmllint --noout content.xml
content.xml:2: parser error : Specification mandates value for attribute style
troke-width="0in" draw:fill="none" draw:textarea-horizontal-align="center" style
                                                                               ^
content.xml:2: namespace error : Failed to parse QName 'style:graphic-proper:'
ea-horizontal-align="center" style>tstyle:family="graphic"><style:graphic-proper
                                                                               ^
content.xml:2: parser error : error parsing attribute name
enter" style>tstyle:family="graphic"><style:graphic-proper:use-window-font-color
                                                                               ^
content.xml:2: parser error : attributes construct error
enter" style>tstyle:family="graphic"><style:graphic-proper:use-window-font-color
                                                                               ^
content.xml:2: parser error : Couldn't find end of Start Tag graphic-proper:use-window-font-color line 2
enter" style>tstyle:family="graphic"><style:graphic-proper:use-window-font-color
                                                                               ^
content.xml:2: parser error : Opening and ending tag mismatch: graphic-properties line 2 and style
:text-align="end" fo:margin-left="0in" style:writing-mode="page"/></style:style>

31 errors reported.

For the first error, the tag below is diagnosed as an error.
<style:graphic-properties draw:stroke="none" svg:stroke-width="0in" draw:fill="none" draw:textarea-horizontal-align="center" style>
Tag syntax requires the final word style to be followed by an equal sign and a quoted value.
Mr. Programmer
AOO 4.1.7 Build 9800, MacOS 13.7.6, iMac Intel.   The locale for any menus or Calc formulas in my posts is English (USA).
User avatar
LastUnicorn
Posts: 789
Joined: Sat Mar 29, 2008 2:41 am
Location: Scotland

Re: ODS file has a format error

Post by LastUnicorn »

Switch to LibreOffice and this will be less likely to happen to you in the future. There are several good reasons for making the switch, some of which are mentioned here: [Tutorial] Considering a Switch from OpenOffice to LibreOffice? Some Useful Information
LibreOffice 25.8.0.4 (x64) installed to Windows 11 Pro. 24H2
Apache OpenOffice Portable 4.1.15 [Portable Apps]
For Java I use Adoptium Temurin JRE LTS Releases.
User avatar
RoryOF
Moderator
Posts: 35090
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: ODS file has a format error

Post by RoryOF »

There is an outside (i.e., unlikely) possibility that you may be able to find a deleted work file. Download one of Recuva or Photorec and tell that to make an indepth search of your hard drive for hidden/deleted temporary files.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.5 LTS
elijahs
Posts: 2
Joined: Fri Aug 09, 2024 2:54 pm

Re: ODS file has a format error

Post by elijahs »

Thanks for trying to help me recover the damaged document. I Appreciate your time. This experience has taught me a couple of new things and to be patient when closing documents.
OpenOffice 4.1.15 64-bit operating system, x64-based processor Windows 10
Locked