Bug 89781 - No warning when Saving As CSV if there are multiple sheets
Summary: No warning when Saving As CSV if there are multiple sheets
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: CSV
  Show dependency treegraph
 
Reported: 2015-03-02 16:39 UTC by Taylor Rana Drake
Modified: 2025-10-25 17:18 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Attachments
warning message (6.87 KB, image/png)
2015-03-02 17:02 UTC, raal
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Taylor Rana Drake 2015-03-02 16:39:20 UTC
When saving a sheet that has multiple tabs as a CSV, there is no warning that only one tab will be preserved.  The document appears to save as normal, but when the file is reopened, only the last tab was properly saved, and the tab name is reset to the name of the document.
Comment 1 raal 2015-03-02 17:02:56 UTC
Created attachment 113827 [details]
warning message

I can not confirm with LO  4.4.1.2 and with Version: 4.5.0.0.alpha0+
Build ID: f09efe39da1a2a1cf89b718bc07ed75e0da1b602
TinderBox: Win-x86@42, Branch:master, Time: 2015-02-23_22:57:28

Warning is displayed. Closing as Worksforme. Feel free to set Unconfirmed status again if you have problem in version  4.4.1.2 or higher.
Comment 2 Brandon Mason 2025-10-24 00:27:31 UTC
This is awful.  I just lost 3 days of paid bookkeeping work to this which I will be redoing for free.  While technically it is true - you display a message - it is in NO WAY CLEAR WHAT THE CONSEQUENCES WILL BE.  As a user, I do not expect "save" to be a destructive action.

Your message said something like "This action will only save the present sheet."  As a user I think "that's weird, but no problem, I'll go and save the other sheet, and then save this one again".  None of this makes the situation clear - that it's going to overwrite/delete the other sheets because this is a CSV which doesn't support multiple sheets.  It would have been easy to avoid data loss here if I had clear information about what was happening.  Please change this!
Comment 3 pharmankur 2025-10-24 03:32:32 UTC
Generally its expected that the work you are doing is saved in / as a .ods file and CSV / TSV is the EXPORTED outcome of the data in the file.

So your original work as .ods file with multiple sheets still should get preserved only thing it should mess with is the EXPORTED csv / tsv data.
Comment 4 raal 2025-10-25 17:18:45 UTC
(In reply to Brandon Mason from comment #2)
> This is awful.  I just lost 3 days of paid bookkeeping work to this which I
> will be redoing for free.  While technically it is true - you display a
> message - it is in NO WAY CLEAR WHAT THE CONSEQUENCES WILL BE.  As a user, I
> do not expect "save" to be a destructive action.
> 
> Your message said something like "This action will only save the present
> sheet."  As a user I think "that's weird, but no problem, I'll go and save
> the other sheet, and then save this one again".  None of this makes the
> situation clear - that it's going to overwrite/delete the other sheets
> because this is a CSV which doesn't support multiple sheets.  It would have
> been easy to avoid data loss here if I had clear information about what was
> happening.  Please change this!

Hello, what do you recommend? The warning message is clear, I think.