Open office Calc help for damaged file

Discuss the spreadsheet application
Post Reply
Thilan
Posts: 2
Joined: Thu Dec 12, 2019 12:28 pm

Open office Calc help for damaged file

Post by Thilan »

Edited title, was: Open office Calc Help
Edited title, was: Open office Calc Help
i am using open office 4.1.5 and calc
most of time when i used it this error comes
but i am not able to find a solution for this
can any one help me please
Last edited by MrProgrammer on Fri Dec 13, 2019 1:56 am, edited 2 times in total.
Reason: Removed Solved icon, floris v, moderator
windows 10 and open office 4.1.5
User avatar
floris v
Volunteer
Posts: 4431
Joined: Wed Nov 28, 2007 1:21 pm
Location: Netherlands

Re: Open office Calc Help

Post by floris v »

Do you select the correct character set or language? Try to open the file in Notepad and make sure that it's actually English.

Also please don't post a question twice.
OpenOffice 4.1.11 on Ubuntu; LibreOffice 6.4 on Linux Mint, LibreOffice 7.6.2.1 on Ubuntu
If your problem has been solved or your question has been answered, please edit the first post in this thread and add [Solved] to the title bar.
Nederlandstalig forum
Jeff
Posts: 25
Joined: Sat Apr 25, 2009 12:02 pm
Location: France

Re: Open office Calc Help

Post by Jeff »

Hi and welcome,

It's possible your file is corrupted.

It's a strange idea to save in xls format, if your file was in ods format, you will can recuperate data, but here...

Regards
AOO 4.1.11 on Windows 10 and Ubuntu 20.04 x64
John_Ha
Volunteer
Posts: 9584
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Open office Calc Help

Post by John_Ha »

Your file is totally corrupted and has no user data.

Follow the instructions for recovering .doc files in [Tutorial] How to find and un-delete AOO temporary files for detailed instructions on how to

a) use Previous Versions (W7 and later) to recover previous versions of the file (is there something similar on MacOS and Linux?);

b) recover your file as it was when you last opened or saved it, or as it was when it was last saved with AutoRecovery;

c) find previous versions of the file in the folder it is located in, but which have since been deleted.

As it is a .xls file there are no temporary files to recover.
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.
Thilan
Posts: 2
Joined: Thu Dec 12, 2019 12:28 pm

Re: Open office Calc help for damaged file

Post by Thilan »

Thank you very much for helping
windows 10 and open office 4.1.5
Post Reply