Spreadsheet converted to text

Discuss setup / installation issues - Add a spell checker, Language pack?
Post Reply
mandy1805
Posts: 1
Joined: Tue Sep 22, 2020 11:37 am

Spreadsheet converted to text

Post by mandy1805 »

Hi

Can anyone please help. Opened up open office today and was asked to register with name. Did so and then when I went to load spreadsheet from yesterday system told me it was a read only and when I open copy a ASC filter box appears then the document opens as a text document full of ################. I have know idea where to look on the help section. Surely this is something simple. Have tried copying into a new spreadsheet and trying to change ext etc but nothing working.
open office 4.1.7 on windows
User avatar
RoryOF
Moderator
Posts: 34586
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: spreadsheet converted to text

Post by RoryOF »

Previous experience tells that your file will be utterly corrupt. Try the methods in this post, as soon as possible, in the hope of recovering part or all of it.

The damage is possibly due to over-hasty power-off of computer or closure of laptop lid, before the file housekeeping has been written to disk, or to computer or program crash. Do not let your computer sleep/hibernate with a document open. When you have formally closed down the computer, wait five or ten seconds before pulling the power lead or closing the laptop lid, to allow the internal buffers of the hard drive flush to disk

As soon as possible try the methods in this tutorial
See [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;

d) un-delete the temporary files AOO 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.

There will be nothing usable in your damaged file - waste no time with them. Try the recovery methods above.

If you have backup copies (why not?) you should use them.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Post Reply