Spreadsheet file full of #####

Discuss setup / installation issues - Add a spell checker, Language pack?
Post Reply
HatherleyNS
Posts: 1
Joined: Fri Sep 02, 2022 1:34 pm

Spreadsheet file full of #####

Post by HatherleyNS »

I recently installed OO4.1.13, and have since edited and saved my accounts summary spreadsheet (,ods) file.
Now when I try to open it, it displays various prompts then either opens it full of '#' characters, or completely empty.

The back up also will not open successfully.

Other .ods files open OK and open again after saving.
Can anyone help, or is this file terminally corrupted?

 Edit: Changed subject, was Unable to open .ods file 
Make your post understandable by others 
-- MrProgrammer, forum moderator 
Last edited by MrProgrammer on Fri Sep 02, 2022 3:14 pm, edited 1 time in total.
Reason: Changed subject
OpenOffice 4.1.13 Windows 10
User avatar
LastUnicorn
Posts: 812
Joined: Sat Mar 29, 2008 2:41 am
Location: Scotland

Re: Unable to open .ods file

Post by LastUnicorn »

Your file is terminally corrupt: https://forum.openoffice.org/en/forum/v ... 47#p493247

Take a tip: switch to LibreOffice it has significantly less issues on this score than OpenOffice and is more up to date than OpenOffice.
LibreOffice 25.8.4.2 (x64) installed to Windows 11 Pro. 25H2
Apache OpenOffice Portable 4.1.16 [Portable Apps]
For Java I use Adoptium Temurin JRE LTS Releases.
Post Reply