Spreadsheet crash via power cut

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

Spreadsheet crash via power cut

Postby matchbox_man » Fri Jan 29, 2021 4:18 pm

Hi all.

I'm running Windows 7 with open office Vn4.1.7.

A power cut has caused an file opening issue on a spreadsheet.

My file is named: Matchbox-75 car's - March 2019.xls

When trying to open I get the following window, I've tried changing a few settings but none seem to make any difference to pressing OK, I just get a blank sheet, with only 1 tab.

Any help in resolving appreciated.

Mark Wallis.
England
Attachments
Capture image .JPG
Windows 7
Open Office Vn: 4.1.7
matchbox_man
 
Posts: 3
Joined: Fri Jan 29, 2021 3:57 pm

Re: Spreadsheet crash via power cut

Postby Hagar Delest » Fri Jan 29, 2021 6:26 pm

Hi and welcome to the forum!

Few chances to recover anything. See: [Tutorial] The Dreaded Pound Signs: file reduced to ####. Good luck. I hope you had backups.
Note: saving in .xls further reduce the chances since it's a binary format. Better use .ods.
LibreOffice 7.0.5 on Xubuntu 21.04 and 7.0.5 portable on Windows 10
User avatar
Hagar Delest
Moderator
 
Posts: 29753
Joined: Sun Oct 07, 2007 9:07 pm
Location: France

Re: Spreadsheet crash via power cut

Postby matchbox_man » Sat Jan 30, 2021 3:47 pm

I had back-up from star of January but had made a few updates since. I was unaware of the OO back-up option so now have it enabled.

What is the main difference between XLS & ODS format?...as all data on a pc is binary, in my power-loss circumstance I'm curious to any difference that may have made?

Mark. ;-)
Windows 7
Open Office Vn: 4.1.7
matchbox_man
 
Posts: 3
Joined: Fri Jan 29, 2021 3:57 pm

Re: Spreadsheet crash via power cut

Postby John_Ha » Sat Jan 30, 2021 3:54 pm

matchbox_man wrote:What is the main difference between XLS & ODS format?

See [Tutorial] Differences between Writer and MS Word files for a description of differences and for why you should always work in, and save Writer files as .odt, Calc files as .ods, Impress files as .odp etc.

matchbox_man wrote:in my power-loss circumstance I'm curious to any difference that may have made?

AOO handles .doc/.xls/.ppt files differently from .odt/.ods/.odp files.

The MS .doc/.xls/.ppt formats are effectively the contents of the PC memory zipped into a file.

The ODF .odt/.ods/.odp formats are structured XML files zipped into a file.

When AOO opens an MS file it does not create a temp file. When AOO opens an ODF file (or a .docx/.xlsx etc file) AOO creates a temporary file and this temporary file can often be recovered if the original file is corrupted.

See [Tutorial] How to find and un-delete AOO temporary files for more information.
LO 6.4.4.2, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

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

Re: Spreadsheet crash via power cut

Postby Villeroy » Sat Jan 30, 2021 4:05 pm

For the technical difference refer to [Tutorial] Differences between Writer and MS Word files
ods is the native spreadsheet format of your application. You should always store your data in the native format of whatever application you are using. The native format guarantees that every feature you are using can be stored in the document. In this case it might have been the feature which restores crashed documents flawlessly.
odt, ods, odp, odg, odb, odf are your native document formats for text, spreadsheet, presentation, graphic, database and formulas. The generic term is Open Document Format (ODF) which is an international standard for documents. Contrary to Microsoft's "standards", this one is free and supported by dozends of applications without all the trouble and pain that are imposed by Microsoft formats. Microsoft's business model depends on its documents, protocols, interfaces not being compatible with anything or anybody except for tactical reasons or when inevitable. The ODF standard has been invented to break this. Storing for your own work in MS document formats undermines the efforts of hundreds of developers in various projects.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Villeroy
Volunteer
 
Posts: 29726
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Spreadsheet crash via power cut

Postby matchbox_man » Sat Jan 30, 2021 8:24 pm

Thanks for replies peops.

Why is the shown 'Text Import' window appearing, what's that about?

Mark.
Attachments
Capture image .JPG
Windows 7
Open Office Vn: 4.1.7
matchbox_man
 
Posts: 3
Joined: Fri Jan 29, 2021 3:57 pm

Re: Spreadsheet crash via power cut

Postby John_Ha » Sat Jan 30, 2021 8:30 pm

matchbox_man wrote:Why is the shown 'Text Import' window appearing, what's that about?

Upload the file showing the problem so a precise reason can be given.

Press POSTREPLY and click the Upload attachment tab below where you type (128 kB max); or use a file share site, Dropbox or Google Drive for a larger file.
LO 6.4.4.2, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

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

Re: Spreadsheet crash via power cut

Postby RoryOF » Sat Jan 30, 2021 8:50 pm

The text import window normally means OpenOffice can't understand the file, which is often an indication that it is badly damaged. In the case of Calc it may indicate that the file has been Saved in a text format (often .csv)
Apache OpenOffice 4.1.10 on Xubuntu 20.04.2 (mostly 64 bit version) and very infrequently on Win2K/XP
User avatar
RoryOF
Moderator
 
Posts: 32557
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Spreadsheet crash via power cut

Postby Villeroy » Sat Jan 30, 2021 9:29 pm

Recipe for data loss:
MS Windows(7)
No backup strategy
Foreign binary file format
Database data on sheets
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Villeroy
Volunteer
 
Posts: 29726
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Spreadsheet crash via power cut

Postby alangell » Mon Feb 08, 2021 2:54 pm

The same thing has just happened to me ... power cut off .. tried to open an XLS file I was editing in OpenOffice... and
all I got was the TEXT IMPORT window with 12 column headings all saying STANDARD and most of them filled out with random 8-digit series of letters & numbers.
I am really, really upset if I have lost my file. This is historical payment data, monthly, with interest charges, over a 12 year period....
I am hopeful, but it doesn't sound very good from what I am reading above.... Is this maybe a new problem that is just beginning to surface? If so, maybe OpenOffice techs can work some miracles???????
OpenOffice 4.1.9 on Windows 10
alangell
 
Posts: 2
Joined: Mon Feb 08, 2021 2:47 pm

Re: Spreadsheet crash via power cut

Postby RusselB » Mon Feb 08, 2021 3:04 pm

This is not a new problem and there is nothing the developers can do as they have no way of controlling the power to your computer.
Read the tutorials previously posted and try the options given asap. The longer you wait, the better the chances of losing your data.
OpenOffice 4.1.7, LibreOffice 7.0.1.2 on Windows 7 Pro, Ultimate & Windows 10 Home (2004)
If you believe your problem has been resolved, please go to your first post in this topic, click the Edit button and add [Solved] to the beginning of the Subject line.
User avatar
RusselB
Moderator
 
Posts: 6400
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Spreadsheet crash via power cut

Postby Villeroy » Mon Feb 08, 2021 9:51 pm

You must NEVER EVER store your work in any file format other than the native file format of the application you are using. xls is NOT a native file format when working with OpenOffice. xls is not even a standard.
I can not understand why Windows users do not run backups. There are tons of more or less sophisticated backup applications for MS Windows which store all of your work, all of your settings, all of your credentials and identities, not only office documents.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Villeroy
Volunteer
 
Posts: 29726
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany


Return to Install, Setup and Troubleshooting

Who is online

Users browsing this forum: No registered users and 7 guests