ODS file asks for text import then opens blank

Discuss the spreadsheet application

ODS file asks for text import then opens blank

Postby Freyaness » Mon Dec 10, 2012 4:38 pm

If anyone can help me I'd greatly appreciate it. I have a master .ods file for tracking my hours for clients. It was working fine, until this morning. Now all of the sudden it asks for "Text Import" and opens blank. I'm not exactly sure why or how this happened - nothing abnormal has happened overnight.

I tried a few .ods recovery programs but to no avail. If there's any way that you guys know to recover this file, it would be greatly appreciated.

Thanks in advance for any advice.
OpenOffice 3.4.1, Windows 7
Freyaness
 
Posts: 4
Joined: Mon Dec 10, 2012 4:34 pm

Re: ODS file asks for text import then opens blank

Postby acknak » Mon Dec 10, 2012 5:03 pm

This situation usually means that the file is damaged and OOo doesn't know how to deal with the data in that file. The only real solution is to go to a backup copy.

On rare occasions, some of the data can be recovered from a damaged file. If you want to attach your file here, I expect someone can take a look at it.
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: ODS file asks for text import then opens blank

Postby Freyaness » Mon Dec 10, 2012 5:23 pm

Is there someone I can send it to for a review from OOO via email. I'd rather not make this particular file available to everyone.
OpenOffice 3.4.1, Windows 7
Freyaness
 
Posts: 4
Joined: Mon Dec 10, 2012 4:34 pm

Re: ODS file asks for text import then opens blank

Postby acknak » Mon Dec 10, 2012 7:02 pm

Sure; I can take a look. Click the email icon to the right of this post. I'll reply with an address that accepts attachments.
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: ODS file asks for text import then opens blank

Postby Freyaness » Tue Dec 11, 2012 4:31 pm

For others looking for an answer to this issue - it was discovered that the file was corrupted beyond repair.

Unfortunately in the digital world, having automatic backups of important files is the only thing you can do to make sure that you won't lose them for good!
OpenOffice 3.4.1, Windows 7
Freyaness
 
Posts: 4
Joined: Mon Dec 10, 2012 4:34 pm

Re: ODS file asks for text import then opens blank

Postby acknak » Tue Dec 11, 2012 5:14 pm

Did you look for the temporary file? Some people have been able to recover the document from that, although I'm not entirely sure where to look or what to look for.

See [Tutorial] The OOo user profile for details, or one of the other file recovery threads here.

For anyone keeping score, the file was all zeros again.
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: ODS file asks for text import then opens blank

Postby kingfisher » Wed Dec 12, 2012 12:04 am

The locations of the temporary and backup files are shown in Tools > Options > OO > Paths unless Apache has changed that.
Apache OpenOffice 4.1.6 on PCLinuxOS
User avatar
kingfisher
Volunteer
 
Posts: 2120
Joined: Tue Nov 20, 2007 10:53 am

Re: ODS file asks for text import then opens blank

Postby garto » Thu Jan 31, 2013 12:28 pm

I have the exact same problem with a file that is quite crucial to me. I will attach it to this post, if someone could take a look to see if it is salvageable I would greatly appreciate it.
Thanks
Attachments
Cobranzas 2013.ods
(26.65 KiB) Downloaded 153 times
OOffice 3.4.1
Windows 7 Home Basic
garto
 
Posts: 1
Joined: Thu Jan 31, 2013 12:19 pm

Re: ODS file asks for text import then opens blank

Postby RoryOF » Thu Jan 31, 2013 2:49 pm

I'm getting nothing from it, but there are better recovery people on the Forum than me, so don't give up all hope yet.

 Edit: My result was a file of null characters. 
Apache OpenOffice 4.1.6 on Xubuntu 18.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 28781
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: ODS file asks for text import then opens blank

Postby acknak » Thu Jan 31, 2013 4:56 pm

Yep. Nothing there but zeroes--no data to recover.
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: ODS file asks for text import then opens blank

Postby sureshkumarpm » Tue Jun 03, 2014 6:14 am

When I open .ods file, its asking text import option and its goes blank. Kindly
help to address this issue
Open Office 4.0.1
Windows 7
sureshkumarpm
 
Posts: 2
Joined: Tue Jun 03, 2014 6:12 am

Re: ODS file asks for text import then opens blank

Postby RoryOF » Tue Jun 03, 2014 11:42 am

Damaged file - use a backup.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 28781
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: ODS file asks for text import then opens blank

Postby sureshkumarpm » Tue Jun 03, 2014 1:03 pm

Sorry.. I dont have the backup in the users/openoffice/backup folders. Please advice
Open Office 4.0.1
Windows 7
sureshkumarpm
 
Posts: 2
Joined: Tue Jun 03, 2014 6:12 am

Re: ODS file asks for text import then opens blank

Postby RoryOF » Tue Jun 03, 2014 1:22 pm

You could try running either PhotoRec or Recuva in the hope that they will find a deleted older file or a delete temporary file. These will not be fast applications.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 28781
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: ODS file asks for text import then opens blank

Postby jimmylam » Thu Sep 10, 2015 5:13 am

I'm having the same problem, 1 of my ods file turned overnight, problem seem to happened after i upgraded to Windows 10, not sure if its related.
i had a one month old backup and retype everything in twice, the 1st time it lasted a week before turning into "text import" and the second time only lasted a night.
OpenOffice 3.2.1 on Win 7
jimmylam
 
Posts: 3
Joined: Fri Jan 07, 2011 10:16 am

Re: ODS file asks for text import then opens blank

Postby Mtesigwa Mtebe » Thu Mar 09, 2017 5:11 pm

i have the same problem, could someone help me with my file
open office3.2 on ubuntu
Mtesigwa Mtebe
 
Posts: 1
Joined: Thu Mar 09, 2017 4:52 pm

Re: ODS file asks for text import then opens blank

Postby John_Ha » Fri Mar 10, 2017 11:11 am

See [Tutorial] How to find and un-delete Writer temporary files for instructions on how to identify and un-delete the temporary files Writer wrote while you were editing the file, and then deleted. You should be able to recover the file as it was when you opened it, or at a recent AutoSave if you are using AutoSave.

I guess you don't have Tools > Options > Load/Save > Save a backup copy ticked ...
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: 6592
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: ODS file asks for text import then opens blank

Postby omnivorist » Wed Jul 25, 2018 1:33 am

I have backups going back a long way but the recovered files all show the same text import problem. Very strange.
My feeling is that this is NOT to do with a corrupt file but originates with a bug in an Open Office release. (Just a hunch)
Open Office 4.0.1 on Windows 10
omnivorist
 
Posts: 1
Joined: Wed Jul 25, 2018 1:19 am

Re: ODS file asks for text import then opens blank

Postby petronilo » Mon Oct 01, 2018 11:53 am

Hi all: the same thing happened to me and I am kicking myself. I am usually religious about backups and this is one of the very few times that I go several weeks without one, and this Calc file, essential to me, appears to have been corrupted (Text import prompt, then opens a blank sheet). It is possible that it was due to a hasty shutdown, but the file still appears to be its normal size, implying that there is still information there, and I can't imagine that saving improperly would have damaged *all* of the info?

I have scoured the forums and tried all of the things I found (converting to ZIP file, looking for older temp files, etc). Currently running a Recuva "deep scan" since the initial scan found nothing relevant. If somebody more computer-savvy than I could have a look at the file (here attached) I would be infinitely grateful. NOTE: the file size is 142kb, too big to upload here, so I compressed to a ZIP. Thanks a million-- Pete
Attachments
l_master october 1 attempt.zip
(315 Bytes) Downloaded 24 times
OpenOffice 4.1.5 on Windows 10
petronilo
 
Posts: 3
Joined: Mon Oct 01, 2018 11:42 am

Re: ODS file asks for text import then opens blank

Postby robleyd » Mon Oct 01, 2018 1:46 pm

Unfortunately the file consists of nothing but null bytes - there is no recoverable data whatsoever. Your only hope at this stage, if you have no earlier backups, is that Recuva may come up with something useful.
Cheers
David
Apache OpenOffice Developer Build 4.2.0 9820 - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 2641
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: ODS file asks for text import then opens blank

Postby petronilo » Tue Oct 02, 2018 10:14 am

Thanks a lot for trying David. What about this file (also attached)? Recuva found it from earlier in September -- it says the state is "Very Poor", which is better than "Unrecoverable" but still not very promising. From the Text Import prompt, it looks like this one actually has characters in it (not just blank spaces) but when I try to open it, OO tries and then closes. Wondering whether any parts of this might be salvageable (there is a lot of info in it on many sheets, so even recovering a bit of it would be valuable).

Thanks again in advance...
Peter
Attachments
last try.zip
(48.71 KiB) Downloaded 19 times
OpenOffice 4.1.5 on Windows 10
petronilo
 
Posts: 3
Joined: Mon Oct 01, 2018 11:42 am

Re: ODS file asks for text import then opens blank

Postby robleyd » Wed Oct 03, 2018 9:10 am

Nothing recoverable from those files either I'm afraid. One - the smaller - was a valid AOO lock file, the other looks like a number of different files were tipped in a food processor and mixed together!
Cheers
David
Apache OpenOffice Developer Build 4.2.0 9820 - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 2641
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: ODS file asks for text import then opens blank

Postby petronilo » Wed Oct 03, 2018 5:53 pm

Thanks David.
Hard to believe that a forced shut down would have caused all 142kb to revert to zeros... but you can believe I won't be doing that again.
Have a great day,
Peter
OpenOffice 4.1.5 on Windows 10
petronilo
 
Posts: 3
Joined: Mon Oct 01, 2018 11:42 am

Re: ODS file asks for text import then opens blank

Postby RoryOF » Wed Oct 03, 2018 5:57 pm

An OO file is a complex format; it is composed of several subfiles containing information about author, styles and content. The space is reserved for the content and filled with zeroes; if the write process is interrupted or not commenced that area is not filled, and all one can get is the zeroes of the prefill.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 28781
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: ODS file asks for text import then opens blank

Postby waynelim1022 » Fri Feb 15, 2019 5:39 am

I also meet this problem
I open the file, it comes out with text import,

after open the file, it become blank.

can someone help me to see it, please
this is very important for me, please help :(
Attachments
DIE CUTTING MOULD MASTERLIST 21122018.ods
(90.8 KiB) Downloaded 7 times
Open Office4.1.0
waynelim1022
 
Posts: 1
Joined: Fri Feb 15, 2019 5:32 am

Re: ODS file asks for text import then opens blank

Postby robleyd » Fri Feb 15, 2019 5:46 am

Your file will have no recoverable data in it. If you have a backup - it is important so you do back it up regularly? - use the backup. If not, see [Tutorial] How to find and un-delete Writer temporary files which is also applicable to Calc files.
Cheers
David
Apache OpenOffice Developer Build 4.2.0 9820 - Slackware 14.2 - 64 bit
LibreOffice 6.0.7.3 - Slackware 14.2 - 64 bit
Apache OpenOffice 4.1.4 - Windows 7 Virtual machine
User avatar
robleyd
Moderator
 
Posts: 2641
Joined: Mon Aug 19, 2013 3:47 am
Location: Murbko, Australia

Re: ODS file asks for text import then opens blank

Postby John_Ha » Fri Feb 15, 2019 12:50 pm

There is (literally) nothing in your file - it is full of NUL characters.
Attachments
Clipboard01.gif
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: 6592
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK


Return to Calc

Who is online

Users browsing this forum: No registered users and 23 guests