XLS file says Text Import and comes up blank!

Discuss the spreadsheet application

XLS file says Text Import and comes up blank!

Postby benmmm » Wed Jul 23, 2014 4:22 pm

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:
Open Office 3.1, now 4.1 after issues with Windows 8
benmmm
 
Posts: 5
Joined: Wed Jul 23, 2014 4:16 pm

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

Postby jrkrideau » Wed Jul 23, 2014 4:26 pm

What format are you saving in? XLS?
LibreOffice 6.4.3.2; Ubuntu 20.04
jrkrideau
Volunteer
 
Posts: 3788
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada

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

Postby benmmm » Wed Jul 23, 2014 4:28 pm

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
Open Office 3.1, now 4.1 after issues with Windows 8
benmmm
 
Posts: 5
Joined: Wed Jul 23, 2014 4:16 pm

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

Postby esperantisto » Wed Jul 23, 2014 4:53 pm

Perhaps, your file is just broken, and there’s no remedy. However, attach the file, maybe…
AOO 4.2.0 / LibO 6.x/7.x / Win 7 / openSUSE Linux Leap 15.1 (64-bit)
esperantisto
Volunteer
 
Posts: 524
Joined: Mon Oct 08, 2007 1:31 am

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

Postby benmmm » Wed Jul 23, 2014 5:21 pm

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
Open Office 3.1, now 4.1 after issues with Windows 8
benmmm
 
Posts: 5
Joined: Wed Jul 23, 2014 4:16 pm

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

Postby jrkrideau » Wed Jul 23, 2014 5:58 pm

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.
LibreOffice 6.4.3.2; Ubuntu 20.04
jrkrideau
Volunteer
 
Posts: 3788
Joined: Sun Dec 30, 2007 10:00 pm
Location: Kingston Ontario Canada

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

Postby benmmm » Wed Jul 23, 2014 6:10 pm

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
Open Office 3.1, now 4.1 after issues with Windows 8
benmmm
 
Posts: 5
Joined: Wed Jul 23, 2014 4:16 pm

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

Postby RoryOF » Wed Jul 23, 2014 6:16 pm

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.
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: 31400
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

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

Postby benmmm » Wed Jul 23, 2014 6:29 pm

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.....
Open Office 3.1, now 4.1 after issues with Windows 8
benmmm
 
Posts: 5
Joined: Wed Jul 23, 2014 4:16 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 9 guests