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.

Thanks
openoffice 4.1.3 on Windows 10
boivin42
 
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 https://forum.openoffice.org/en/forum/v ... 74&t=84056 for help in trying to find a backup copy recover your data.
Tom K.
Windows 10 Home version 1803 17134.165
LibreOffice 5.4.7.2
thomasjk
Volunteer
 
Posts: 4397
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.
AOO 4.1.6, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the Writer guide.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
 
Posts: 6612
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 5 guests