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
ODS file has a format error
ODS file has a format error
- Attachments
-
- Expenses 2025.ods
- (117.65 KiB) Downloaded 11 times
OpenOffice 4.1.15 64-bit operating system, x64-based processor Windows 10
- MrProgrammer
- Moderator
- Posts: 5318
- Joined: Fri Jun 04, 2010 7:57 pm
- Location: Wisconsin, USA
Re: ODS file has a format error
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.
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).
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).
- LastUnicorn
- Posts: 789
- Joined: Sat Mar 29, 2008 2:41 am
- Location: Scotland
Re: ODS file has a format error
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.
Apache OpenOffice Portable 4.1.15 [Portable Apps]
For Java I use Adoptium Temurin JRE LTS Releases.
Re: ODS file has a format error
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
Re: ODS file has a format error
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