Issue 108727 - Saving as CSV format on closing Calc could lead to data loss
Summary: Saving as CSV format on closing Calc could lead to data loss
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: save-export (show other issues)
Version: OOO310m19
Hardware: PC Windows 7
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-01-27 23:45 UTC by Andrew McDonald
Modified: 2017-05-20 10:44 UTC (History)
3 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 3.4.1
Developer Difficulty: Simple

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Andrew McDonald 2010-01-27 23:45:45 UTC 
When the user closes Calc with unsaved data, the program prompts the user to 
save. If the document hasn't been saved before, you get the "save as" dialogue. 
If the user chooses CSV format here, the final prompt warns that only the 
active sheet has been saved, and the program closes.

This could result in big data loss, if the user has entered values in other 
sheets. The program shouldn't warn with an "OK" prompt, it should use 
an "OK/Cancel" style one - such that cancelling takes you back to the "save as" 
dialogue box. That way the user wouldn't experience data loss unless they chose 
to proceed.
Comment 1 Rob Weir 2013-01-11 22:10:38 UTC 
Confirmed with AOO 3.4.1
Comment 2 samalipraveena 2014-10-08 02:44:43 UTC 
When the user closes Calc with unsaved data/ click save/save as button, the save as dialog box is displayed; here, the user selects File Type = "Text CSV (.csv)", types in file name and selects "OK". 
Then, Calc displays a dialog box with two options- keep Current Format(highlighted) or Save in ODF Format; if the user selects ODF format, then it is saved without any problem.
if he selects Keep Current Format, then "Export Text File" dialog box is displayed, with OK, Cancel, and help buttons; this is the last chance for the user to cancel/confirm if he still wants to save in csv format; if he cancels here, he is taken back to the save as dialog box; if he still says OK, then the .csv file is saved and a warning is displayed. The final window is a warning box which can have only OK button, because at this point the document is already saved and the user cannot go back to Save As dialog.
Since this is a warning/error window, it can have only the OK button.
Comment 3 jsc 2014-10-16 07:43:59 UTC 
Amali Praveena summarized quite well how the workflow is and it shows that it works as designed. It is no issue and the user can decide which format should be used to save.
Comment 4 Marcus 2017-05-20 10:44:59 UTC 
Reset the assignee to the default "issues@openoffice.apache.org".