[Solved] Spreadsheet data lost

Discuss setup / installation issues - Add a spell checker, Language pack?
Post Reply
redstone
Posts: 5
Joined: Wed Jul 17, 2019 4:41 am

[Solved] Spreadsheet data lost

Post by redstone »

All my spreadsheets format changed and data was lost while documents were closed. Any ideas on recovery? Thanks
Last edited by Hagar Delest on Wed Jul 17, 2019 10:24 pm, edited 1 time in total.
Reason: tagged solved
Open Office 4.0.0 on MacOS Mojave version 10.14.5
User avatar
RusselB
Moderator
Posts: 6646
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: spreadsheet data lost

Post by RusselB »

Welcome to the Forums.
If you have lost all of the data from your spreadsheets while they were closed, then that indicates a failure of the storage medium...probably hard drive, though USB stick is also an option.
If it was a failure of the storage medium, then it would not just affect your spreadsheets...unless you had nothing but spreadsheets on it.

You state "All my spreadsheet format changed"... what do you mean by format? Do you mean that they try to open with another program? If so, then that's a file association problem, which has been discussed several times before.
As to a recovery option, a quick Google search came up with this list

Before you go about using the recovery, please explain what it is that leads you to believe the files have been lost.
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
Zizi64
Volunteer
Posts: 11352
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: spreadsheet data lost

Post by Zizi64 »

Tips for the future:

Always create more then one backup copy of your important documents.
https://extensions.libreoffice.org/exte ... amp-backup

Never work on a removable media directly.

Always store your documents into the native, international standard ODF file formats. (You can create a copy at end of editing into a foregn format - if it is necessary.)
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
redstone
Posts: 5
Joined: Wed Jul 17, 2019 4:41 am

Re: Spreadsheet data lost

Post by redstone »

Thank you.
And apologies. The issue is resolved. Data recovered . . . from the mysteriously reset margins that disappeared the data out of sight.
Open Office 4.0.0 on MacOS Mojave version 10.14.5
Post Reply