[Solved] Spreadsheet data lost

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

[Solved] Spreadsheet data lost

Postby redstone » Wed Jul 17, 2019 4:47 am

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
redstone
 
Posts: 5
Joined: Wed Jul 17, 2019 4:41 am

Re: spreadsheet data lost

Postby RusselB » Wed Jul 17, 2019 5:01 am

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 and LibreOffice 6.3.3.2 on Windows 7 Pro & Ultimate
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: 6123
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: spreadsheet data lost

Postby Zizi64 » Wed Jul 17, 2019 6:46 am

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; LO6.1.6, 6.2.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-6.4.5;AOO4.1.7
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.
User avatar
Zizi64
Volunteer
 
Posts: 9555
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Spreadsheet data lost

Postby redstone » Wed Jul 17, 2019 2:03 pm

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
redstone
 
Posts: 5
Joined: Wed Jul 17, 2019 4:41 am


Return to Install, Setup and Troubleshooting

Who is online

Users browsing this forum: Hagar Delest and 9 guests