Files open in Writer instead of Calc

Discuss the spreadsheet application

Files open in Writer instead of Calc

Postby twstone » Mon Mar 23, 2015 5:54 pm

I am having the same problem. When I attempt to open the attached file, I get a popup window "Ascii Filter Options" and when I click that I get 9 pages of garbage. The file worked as of last week.
I have attempted to open the file both from the OO first page 'open file' and by starting a new spreadsheet and then opening it from there.
Please help! I am my group's treasurer and tis spreadsheet is our financial record for several years.
Attachments
WOGBudgetSheet.ods
(41.97 KiB) Downloaded 41 times
Open Office version is 4.1.1. OS is Windows 8.1 and is up to date. Signature???
twstone
 
Posts: 1
Joined: Mon Mar 23, 2015 5:24 pm

Re: .xls/.ods-files open in Writer instead of Calc

Postby thomasjk » Mon Mar 23, 2015 7:29 pm

twstone:
Your file is filled with ############ which means its corrupted beyond recovery. Hopefully you have backups to recover from. Look in the user profile https://forum.openoffice.org/en/forum/v ... 74&t=12426 for a Wgobudgetsheet.bak.
Tom K.
Windows 10 Home version 1803 17134.165
LibreOffice 5.4.7.2
thomasjk
Volunteer
 
Posts: 4416
Joined: Tue Dec 25, 2007 4:52 pm
Location: North Carolina

Re: Files open in Writer instead of Calc

Postby Hagar Delest » Thu Mar 26, 2015 4:32 am

Hi and welcome to the forum!

Sadly, quite nothing to do I fear, see: 22 pages term paper replaced with pound signs.

Check the temporary folder of the system (see in OO Tools>Options>OO>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.

It often happens when there is a power cut or a crash when saving.
If you want to help fix this problem, you can also do this survey created for this very problem: Document Recovery Survey.
AOO 4.1.7 on Xubuntu 19.10 and 4.1.5 on Windows 10 (with winPenPack port).
User avatar
Hagar Delest
Moderator
 
Posts: 28719
Joined: Sun Oct 07, 2007 9:07 pm
Location: France


Return to Calc

Who is online

Users browsing this forum: Lupp, MSN [Bot], robleyd and 31 guests