Page 1 of 1

XLS file says Text Import and comes up blank!

PostPosted: Wed Jul 23, 2014 4:22 pm
by benmmm
I have recurring work that I have saved using cal on Open Office 3.1. Yesterday they were working and i was editing and able to view and save them. I emailed myself a copy even. Today when I attempt to open my file it pulls up the "Text Import" window, and no matter what slew of options I plug in, there is nothing that appears in the file. I have tried looking in the files for backups or temp files and came up short. I have about a month invested into this file, and the emailed attachment version does the exact same thing when I attempt to download and open that particular file. I tried updating my open office to 4.1 today and still got the same results. I can attach the file if necessary, it still says that the file is 400 kb, so I don't understand how it can be coming up blank. Please help :cry:

Re: HELP! XLS file says Text Import and comes up blank!

PostPosted: Wed Jul 23, 2014 4:26 pm
by jrkrideau
What format are you saving in? XLS?

Re: HELP! XLS file says Text Import and comes up blank!

PostPosted: Wed Jul 23, 2014 4:28 pm
by benmmm
My calc files are all in xls right now when I look at them, and they all will open correctly except for the largest one

Re: HELP! XLS file says Text Import and comes up blank!

PostPosted: Wed Jul 23, 2014 4:53 pm
by esperantisto
Perhaps, your file is just broken, and there’s no remedy. However, attach the file, maybe…

Re: HELP! XLS file says Text Import and comes up blank!

PostPosted: Wed Jul 23, 2014 5:21 pm
by benmmm
File was too large to attach, again making it unclear to me how it can be an empty spreadsheet. I uploaded a mediafire link.

https://www.mediafire.com/?uhewysb2jllroe8

Re: HELP! XLS file says Text Import and comes up blank!

PostPosted: Wed Jul 23, 2014 5:58 pm
by jrkrideau
I'm not an expert but it looks like it's gone. Have a look at 22 pages term paper replaced with pound signs

Both gnumeric and Emacs provide a bit more info than Calc but they both agree with Calc. gnumeric says the file contains 370,780 Null characters.

The safest thing to do is always save in ods format and only export to another format when you need to. And always keep a backup in odt format. Sorry.

Re: HELP! XLS file says Text Import and comes up blank!

PostPosted: Wed Jul 23, 2014 6:10 pm
by benmmm
God, I just dont see how my file was working just last night, saved, and closed out. Opened this morning and all of a sudden everything is lost and never able to be found again

Re: HELP! XLS file says Text Import and comes up blank!

PostPosted: Wed Jul 23, 2014 6:16 pm
by RoryOF
This can sometimes be caused by too speedy a shut down of the computer, before the software or hardware write buffers have flushed.

Look in the temporary and backup directories used by OpenOffice (pointed to be /Tools /Options /OpenOffice : Paths); rename any .bak file to .xls and see if your data is there. On the temp directory rename files with arbitrary names/extensions to .xls and see if they have data. As a last resort, run PhotoRec or Recuva and see if it finds any deleted working files.

Re: HELP! XLS file says Text Import and comes up blank!

PostPosted: Wed Jul 23, 2014 6:29 pm
by benmmm
I tried to use those two programs and nothing seemed to come up. But when looking at REALLY back dated deleted versions of my file, they are all shown in ODS format, and it shows me that everything used to be in ODS. I wasn't sure if I just didn't recognize the xls files, and mostly the icon for the xls files. Now im certain that my files WERE in ods format.....