ASCII filter

Discuss the spreadsheet application

ASCII filter

Postby csommer503 » Wed Jul 17, 2013 8:45 pm

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
csommer503
 
Posts: 2
Joined: Wed Jul 17, 2013 8:38 pm

Re: ASCII filter

Postby Hagar Delest » Wed Jul 17, 2013 9:45 pm

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 (#####)?
AOO 4.1.7 on Xubuntu 20.04 and 4.1.5 on Windows 10 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28952
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: ASCII filter

Postby csommer503 » Wed Jul 17, 2013 10:02 pm

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 124 times
OpenOffice 3.3 on Windows XP
csommer503
 
Posts: 2
Joined: Wed Jul 17, 2013 8:38 pm

Re: ASCII filter

Postby RoryOF » Wed Jul 17, 2013 10:31 pm

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.7 on Xubuntu 20.04.1 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 31429
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: ASCII filter

Postby Hagar Delest » Wed Jul 17, 2013 10:40 pm

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.
AOO 4.1.7 on Xubuntu 20.04 and 4.1.5 on Windows 10 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28952
Joined: Sun Oct 07, 2007 9:07 pm
Location: France


Return to Calc

Who is online

Users browsing this forum: No registered users and 12 guests