ASCII filter

Discuss the spreadsheet application
Post Reply
csommer503
Posts: 2
Joined: Wed Jul 17, 2013 8:38 pm

ASCII filter

Post by csommer503 »

Hi all,

I have a calc/spreadsheet document that seems to have been corrupted. When I try to open it I get an ASCII filter dialogue box. Is there someway to recover it? Thanks in advance for any suggestions.
OpenOffice 3.3 on Windows XP
User avatar
Hagar Delest
Moderator
Posts: 32657
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: ASCII filter

Post by Hagar Delest »

Hi and welcome to the forum!

Can you upload it if there is no sensitive data (see How to attach a document here)?
Do you save in ODF (.ods)?
If you open the file, do you get hashes (#####)?
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
csommer503
Posts: 2
Joined: Wed Jul 17, 2013 8:38 pm

Re: ASCII filter

Post by csommer503 »

The ASCII dialogue box comes up and it converts the file to all hash marks. I don't remember what I could have done to cause it. It had been saved to an external hard drive. Any advice is appreciated.
Attachments
Solar_log_2013.ods
I don't think it's sensitive. Yes, it converts to hash marks.
(20.97 KiB) Downloaded 314 times
OpenOffice 3.3 on Windows XP
User avatar
RoryOF
Moderator
Posts: 34612
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: ASCII filter

Post by RoryOF »

The external hard drive may have been removed too quickly, or without observing the USB removal protocol. The file you uploaded is an incomplete archive, whih would support either of the two above suppositions. I can get nothing out of it, but best to wait for another opinion.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
User avatar
Hagar Delest
Moderator
Posts: 32657
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: ASCII filter

Post by Hagar Delest »

Sadly, quite nothing to do, see: 22 pages term paper replaced with pound signs.
The file seems indeed empty.

Check the temporary folder of the system (see in OOo Tools>Options>OOo>Paths). If there are folders like sgmlf.tmp with a file having the same name inside, make a copy of that file, rename it in .ods and cross your fingers. If you have not rebooted, you might have those files still there.
LibreOffice 7.6.2.1 on Xubuntu 23.10 and 7.6.4.1 portable on Windows 10
Post Reply