Ask Your Question
0

Calc deletes sheets on its own

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

updated 2018-08-14 10:03:03 +0200

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 close merge delete

Comments

What is the format of "the doc"?

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

1 Answer

Sort by » oldest newest most voted
1

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

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

Comments

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?

libreoffice@use.startmail.com gravatar imagelibreoffice@use.startmail.com ( 2018-08-14 10:01:53 +0200 )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 +0200 )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!

libreoffice@use.startmail.com gravatar imagelibreoffice@use.startmail.com ( 2018-08-14 10:16:15 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 103 times

Last updated: Aug 14 '18