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: 33416
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 25.2 on Linux Mint Debian Edition (LMDE Faye) and 24.8 portable on Windows 11.
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 337 times
OpenOffice 3.3 on Windows XP
User avatar
RoryOF
Moderator
Posts: 35080
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.5 LTS
User avatar
Hagar Delest
Moderator
Posts: 33416
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 25.2 on Linux Mint Debian Edition (LMDE Faye) and 24.8 portable on Windows 11.
Post Reply