My spreadsheet opens as a Writer document

Discuss setup / installation issues - Add a spell checker, Language pack?

My spreadsheet opens as a Writer document

Postby boivin42 » Sat Jul 21, 2018 1:52 am

went to open my spreadsheet and it opened up as an "Open Office Writer" document and all the characters were # symbols. Somehow my spreadsheet converted to Office document. After I open the spreadsheet a window appears titled "ASCII Filter Options" with drop-down boxes for "Character Set", "Default fonts", "Language" and 3 choices for "Paragraph break". For the Character Set "Western Europe (DOS/OS2-437...) is already hi-lighted. Can anyone help me get my spreadsheet back? I have no idea how this happened. Last time I opened it was normal and looked like it always does.

openoffice 4.1.3 on Windows 10
Posts: 1
Joined: Sat Jul 21, 2018 1:38 am

Re: my spreadsheet opens as a writer document

Postby thomasjk » Sat Jul 21, 2018 4:37 am

If all you see is ######### then you document is corrupted beyond repair. See ... 74&t=84056 for help in trying to find a backup copy recover your data.
Tom K.
Windows 10 Home version 1803 17134.165
Posts: 4431
Joined: Tue Dec 25, 2007 4:52 pm
Location: North Carolina

Re: My spreadsheet opens as a Writer document

Postby John_Ha » Sat Jul 21, 2018 11:28 am

Also see [Tutorial] How to find and un-delete Writer temporary files for

a) detailed instructions on how to recover your file as it was when you last opened or saved it, or as it was when it was last saved with AutoRecovery;

b) how to find previous versions of the file in the folder it is located in, but which have since been deleted;

c) how to un-delete the temporary files Writer wrote while you were editing the file, and then deleted. This will recover your file as it was when you last opened or you last saved it and is probably your best hope.
LO, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
Posts: 7899
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Return to Install, Setup and Troubleshooting

Who is online

Users browsing this forum: No registered users and 9 guests