Ask Your Question

Calc deletes sheets on its own [closed]

asked 2018-08-14 09:00:42 +0100

updated 2020-08-05 23:25:11 +0100

Alex Kemp gravatar image

Hi guys I have the following issue:

I work on several sheets in a calc document. Then I save and close the doc. When reopen it the next day all sheets but the last one on which I worked have disappeared. The last sheet has then taken on the name of the file, although it had a different name before. I was also trying to recover a previous version, but according to the computer there are no previous versions available. The format is csv (which I have not chosen on my own) and there were no warnings popping up. Who could help?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-08-05 23:25:23.746203


What is the format of "the doc"?

Mike Kaganski gravatar imageMike Kaganski ( 2018-08-14 09:02:28 +0100 )edit
ebot gravatar imageebot ( 2018-08-14 09:08:19 +0100 )edit

1 Answer

Sort by » oldest newest most voted

answered 2018-08-14 09:10:58 +0100

What you describe looks most likely to the normal behaviour of Calc in case of using CSV format. The format is only capable of storing one set of information (one "sheet"), without formatting (including "sheet name"); saving to it produces several warnings (saving to a non-native format which may result in formatting loss; saving only active sheet to CSV), and also a CSV format export dialog. If you are actually using this format, then ignoring all the warnings to discover later that they are there for purpose is a user error. Please use native (ODS) format to store spreadsheets; if you need a CSV, then export individual sheets as needed.

edit flag offensive delete link more


Hi Mike many thanks this is really useful. Indeed the format is csv. However unfortunately there were no warnings popping up at all and I have not chosen csv format. Any idea on this, maybe too? gravatar ( 2018-08-14 10:01:53 +0100 )edit

If you have set the default format for spreadsheets to be CSV, then the first warning (about not recommended format and possible formatting loss) would be absent. Also, you would not need to select the CSV manually in that case - it would be pre-selected. But the other dialogs (including the final warning about only current sheet being saved) would be shown in any case, and they have been there in OOo already. I don't know what could ever prevent them.

Mike Kaganski gravatar imageMike Kaganski ( 2018-08-14 10:11:18 +0100 )edit

Hi great, this did the trick. I have checked on Options and indeed it was put to csv. I changed it now and nicely the document would save as ods. I will now very carefully check the doc endings! gravatar ( 2018-08-14 10:16:15 +0100 )edit

Question Tools

1 follower


Asked: 2018-08-14 09:00:42 +0100

Seen: 163 times

Last updated: Aug 14 '18