My spreadsheet opens as a Writer document

Discuss setup / installation issues - Add a spell checker, Language pack?
Post Reply
boivin42
Posts: 1
Joined: Sat Jul 21, 2018 1:38 am

My spreadsheet opens as a Writer document

Post by boivin42 »

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.

Thanks
openoffice 4.1.3 on Windows 10
thomasjk
Volunteer
Posts: 4454
Joined: Tue Dec 25, 2007 4:52 pm
Location: North Carolina

Re: my spreadsheet opens as a writer document

Post by thomasjk »

If all you see is ######### then you document is corrupted beyond repair. See viewtopic.php?f=74&t=84056 for help in trying to find a backup copy recover your data.
Tom K.
Windows 11 23H2
LibreOffice
John_Ha
Volunteer
Posts: 9600
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: My spreadsheet opens as a Writer document

Post by John_Ha »

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 6.4.4.2, 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.
Post Reply