Blank spreadsheet (!)

Discuss the spreadsheet application

Blank spreadsheet (!)

Postby mammaanna » Tue May 07, 2019 5:37 am

Hello all,

I have had Open Office for about a year and a half. Today it asked me to register (First, Last name and initial), I did this, then it said something about Text Inport. Once I click OK, it opens up with nothing in the spreadsheet and none of the tabs. I feel like I've lost all my work. Excel won't open the .ods file and the file in my desktop folder is still saying that it's 501kb.

Any help would be greatly appreciated.

OpenOffice 4.1.5
Windows 10
Posts: 1
Joined: Tue May 07, 2019 5:30 am

Re: Blank spreadsheet (!)

Postby FJCC » Tue May 07, 2019 6:10 am

The file is damaged and likely unrecoverable. Here is a tutorial on possible methods of recovering temporary versions:
It was written for Writer but also applies to spreadsheets.
Windows 10 and Linux Mint, since 2017
If your question is answered, please go to your first post, select the Edit button, and add [Solved] to the beginning of the title.
Posts: 7220
Joined: Sat Nov 08, 2008 8:08 pm
Location: Colorado, USA

Re: Blank spreadsheet (!)

Postby RoryOF » Tue May 07, 2019 9:57 am

A file that opens as ### is damaged - possibly because of over-hasty power off of the computer before the internal buffers in the hard drive had written to disk. Experience tells us that there will be no usable content within the file - the size of file you see is due to housekeeping information, not usable data.

Follow the methods FJCC pointed to. Do this as soon as possible.
Apache OpenOffice 4.1.6 on Xubuntu 18.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
Posts: 29254
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Return to Calc

Who is online

Users browsing this forum: No registered users and 9 guests