Apache OpenOffice (AOO) Bugzilla – Issue 108727
Saving as CSV format on closing Calc could lead to data loss
Last modified: 2017-05-20 10:44:59 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.
Confirmed with AOO 3.4.1
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.
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.
Reset the assignee to the default "issues@openoffice.apache.org".