Lost the recent version of my csv file

Discuss the spreadsheet application

Lost the recent version of my csv file

Postby shaunbaird » Sun Jan 19, 2020 3:09 pm

Over the last week or so I had created a spreadsheet with multiple sheets and colour coded sections and a fair bit of data.
I have come to it today to find there is just a single sheet with a really old version of the content.

Ive searched the laptop multiple times but cant find anything, nor in the trash bin

Any ideas to get it back.. its a nearly new laptop
Openoffice version 4.1.7
windows 10 pro
shaunbaird
 
Posts: 2
Joined: Sun Jan 19, 2020 3:04 pm

Re: Lost the recent version of my csv file

Postby RusselB » Sun Jan 19, 2020 5:02 pm

Welcome to the Forums.
First off, is it a .csv file or a .ods spreadsheet? The difference, as far as your actual question is irrelevant, however a .csv file will not save multiple sheets and formatting, in which case you've lost a lot of unrecoverable work.
If it's a .ods spreadsheet, try the suggestions in this tutorial
Actually, trying those suggestions even if the file is a .csv might help a bit.
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: 6113
Joined: Fri Jan 03, 2014 7:31 am
Location: Sarnia, ON

Re: Lost the recent version of my csv file

Postby shaunbaird » Sun Jan 19, 2020 6:10 pm

Hi it was a csv. I wasn't aware the sheets would get deleted , there really should have been a warning pop up telling me else Id have happily kept it in original openoffice format.

Ive gone through all this, and the checks in that thread, and now tried recuva..
Thanks, but its not proved fruitful.
Openoffice version 4.1.7
windows 10 pro
shaunbaird
 
Posts: 2
Joined: Sun Jan 19, 2020 3:04 pm

Re: Lost the recent version of my csv file

Postby John_Ha » Sun Jan 19, 2020 6:22 pm

shaunbaird wrote:Over the last week or so I had created a spreadsheet with multiple sheets ...
I have come to it today to find there is just a single sheet with a really old version of the content.

Saving as .csv saves only the values in the cells on Sheet 1. Why did you not read the warning? Or have you cancelled the warning - it is switched on when you install AOO?

Clipboard01.png

Did you ignore the next warning, which cannot be cancelled, saying only the current active sheet has been saved?

Clipboard03.png
Clipboard03.png (6.16 KiB) Viewed 239 times

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

See [Tutorial] How to find and un-delete AOO temporary files for detailed instructions on how to

a) use Previous Versions (W7 and later) to recover previous versions of the file (is there something similar on MacOS and Linux?);

b) recover your file as it was when you last opened or saved it, or as it was when it was last saved with AutoRecovery;

c) find previous versions of the file in the folder it is located in, but which have since been deleted;

d) find any temporary files AOO wrote while you were editing the file but which have not yet been deleted;

e) un-delete the temporary files AOO wrote while you were editing the file, and then deleted. d) and e) will recover your file as it was when you last opened or you last saved it.

If you have never saved the file with multiple sheets as a .ods or .xsl AOO will never have written temporary files.

If you cannot follow the instructions ask someone with more PC skills to help you. Act quickly - the longer you wait the more likely any temporary files are to be deleted.

Showing that a problem has been solved helps others searching so, if your problem is now solved, please view your first post in this thread and click the Edit button (top right in the post) and add [Solved] in front of the subject.
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: 7794
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK


Return to Calc

Who is online

Users browsing this forum: No registered users and 21 guests