Bug 92984 - FILESAVE: Modifying and saving existing CSV should warn about only saving active sheet, GUI and headless
Summary: FILESAVE: Modifying and saving existing CSV should warn about only saving act...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
: 100815 124859 130259 (view as bug list)
Depends on:
Blocks: CSV-Export
  Show dependency treegraph
 
Reported: 2015-07-28 15:25 UTC by tmacalp
Modified: 2020-02-19 17:08 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description tmacalp 2015-07-28 15:25:16 UTC
Description:
If you open an existing csv file, create a new sheet, and then do a simple save, you will be encouraged to save as a ods, but will not receive the warning about it only saving the active sheet.  You should always be warned on file-save when you are only saving the active sheet.  The appropriate warning is seen if you use a "Save as..." instead.

Steps to reproduce:
* Open an existing csv
* Create a new sheet
* Key some data on the new sheet
* Ctrl-s (prompts to save as ods or keep it as csv)
* Choose "Use Text CSV Format" and click OK

Expected:
When saving a csv, you should always get a prompt saying that you are only saving the active sheet.

Actual:
LibreOffice simply saves the active sheet, discarding the rest of the spreadsheet with no complaints.  Also, any further attempts to save no longer give any prompts to save as ods or warnings that you are only saving the current sheet.

Notes:
If you repeat the steps above and use "Save as..." instead of a normal save, the appropriate prompt IS displayed:

"Warning saving the document test:
Only the active sheet was saved."

Again, this prompt should ALWAYS be displayed when saving a multi-sheet spreadsheet as a csv.

I guess one could argue that the user was forced to choose csv over ods at least once, but I know people who have lost work because of this bug.  As I mentioned above, after that initial decision, any subsequent saves go through without any warnings.

I've tested this behavior on versions going back to OpenOffice 3.2.1, so I'll set it as "Inherited from OOo."  These tests were performed using 64bit Fedora 21.  I also tested and can confirm this bug in LO 4.4.4.3 and LO 5.0.0.4.
Comment 1 raal 2015-07-28 19:28:09 UTC
reproducible with Version: 5.1.0.0.alpha1+
Build ID: 74d4168f8830f7bbec6b784c3fb774296d9adafa
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:master, Time: 2015-07-22_06:14:00
Comment 2 QA Administrators 2016-09-20 10:22:00 UTC Comment hidden (obsolete)
Comment 3 tmacalp 2017-03-10 18:32:50 UTC
Still reproducible in:
Version: 5.3.0.3
Build ID: 7074905676c47b82bbcfbea1aeefc84afe1c50e1
CPU Threads: 4; OS Version: Linux 4.8; UI Render: default; VCL: x11; Layout Engine: new; 
Locale: en-US (en_US.UTF-8); Calc: group
Comment 4 flo.hennig 2017-05-03 18:03:34 UTC
Also still reproducible in the latest version (5.1.6.2)
Comment 5 QA Administrators 2018-07-21 02:39:08 UTC Comment hidden (obsolete)
Comment 6 V Stuart Foote 2019-04-20 18:57:14 UTC
*** Bug 124859 has been marked as a duplicate of this bug. ***
Comment 7 Timur 2020-01-30 09:24:40 UTC
*** Bug 130259 has been marked as a duplicate of this bug. ***
Comment 8 Timur 2020-01-30 09:36:51 UTC
*** Bug 100815 has been marked as a duplicate of this bug. ***
Comment 9 Juan Jesús Cervera 2020-01-30 09:55:52 UTC
Still reproducible in:
Version: 6.3.4.2 (x64)
Build ID: 60da17e045e08f1793c57c00ba83cdfce946d0aa
CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; VCL: win;
Locale: es-ES (es_ES); Calc: threaded
Comment 10 Xisco Faulí 2020-02-19 17:08:06 UTC
Changing priority back to 'medium' since the number of duplicates is lower than 5