[Closed] Spreadsheet opens with text import, then is blank

Discuss setup / installation issues - Add a spell checker, Language pack?

[Closed] Spreadsheet opens with text import, then is blank

Postby longheart » Sun Aug 05, 2018 8:31 pm

My monitor showed a black screen when I got home, and nothing I did allowed me to see that windows 10 was running. I eventually reset my computer with openoffice spreadsheet still running, and now the spreadsheet asks for a text import, and turns up blank.
This spreadsheet does not contain a lot of work, and I have an older copy on google spreadsheets luckily - I can recreate the work, but it'll take a couple days since I'm not sure where all the numbers have been changed.
I have attached the spreadsheet I have with this problem, and I don't know what to do with it.
I did not have automatically create a backup (since I didn't know to turn that on), and checking the temporary folder shows no signs of it. I am currently running undelete on my hard drive which was the other suggestion I saw on this forum at https://forum.openoffice.org/en/forum/v ... 74&t=84056 .
Can someone see the most up to date data I have in this spreadsheet?
Attachments
Scalpel build costs spreadsheet.ods
build costs spreadsheet.
(17.98 KiB) Downloaded 67 times
Last edited by Hagar Delest on Mon Aug 06, 2018 12:15 pm, edited 1 time in total.
Reason: tagged closed
OpenOffice 4.1.5 on Windows 10
longheart
 
Posts: 4
Joined: Sun Aug 05, 2018 8:11 pm

Re: OpenOffice spreadsheet opens with text import, then is b

Postby thomasjk » Sun Aug 05, 2018 9:31 pm

Definitely empty. No data to be found.
Tom K.
Windows 10 Home version 1803 17134.165
LibreOffice 5.4.7.2
thomasjk
Volunteer
 
Posts: 4406
Joined: Tue Dec 25, 2007 4:52 pm
Location: North Carolina

Re: OpenOffice spreadsheet opens with text import, then is b

Postby longheart » Sun Aug 05, 2018 9:34 pm

I'm surprised since it's 18k in size. 18k is the size of my other spreadsheets that contain a similar amount of data, and I do have a smaller spreadsheet with 13k size.
Last edited by longheart on Sun Aug 05, 2018 9:42 pm, edited 1 time in total.
OpenOffice 4.1.5 on Windows 10
longheart
 
Posts: 4
Joined: Sun Aug 05, 2018 8:11 pm

Re: OpenOffice spreadsheet opens with text import, then is b

Postby RoryOF » Sun Aug 05, 2018 9:42 pm

Nothing usable in it. To prove this, rename at your operating system level to type .zip, then try to open it with your system' s archiver.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.3 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 29289
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: OpenOffice spreadsheet opens with text import, then is b

Postby longheart » Sun Aug 05, 2018 9:50 pm

Thank you for your excellent suggestion. I changed the name to .bin, and opened it with a binary viewer. This file is a file containing nothing but nulls. I consider this question solved now.
OpenOffice 4.1.5 on Windows 10
longheart
 
Posts: 4
Joined: Sun Aug 05, 2018 8:11 pm

Re: OpenOffice spreadsheet opens with text import, then is b

Postby John_Ha » Mon Aug 06, 2018 12:20 am

Your only hope is to see [Tutorial] How to find and un-delete Writer temporary files for

a) detailed instructions on how to recover your file as it was when you last opened or saved it, or as it was when it was last saved with AutoRecovery;

b) how to find previous versions of the file in the folder it is located in, but which have since been deleted;

c) how to un-delete the temporary files Writer 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 and is probably your best hope.

It works for all AOO files.
AOO 4.1.6, Windows 7 Home 64 bit

See the Writer Manual, the Writer FAQ, the Writer Tutorials and the Writer guide.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
John_Ha
Volunteer
 
Posts: 6740
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: OpenOffice spreadsheet opens with text import, then is b

Postby longheart » Mon Aug 06, 2018 12:24 am

Thank you, but I decided to not pursue undeleting the file. I will instead reconstruct the missing data on the google spreadsheet as best I can, and redo the past couple days of modifications.
OpenOffice 4.1.5 on Windows 10
longheart
 
Posts: 4
Joined: Sun Aug 05, 2018 8:11 pm


Return to Install, Setup and Troubleshooting

Who is online

Users browsing this forum: No registered users and 4 guests