Bug 113148

Summary:	default file format for new spreadsheets should be ODS, not CSV
Product:	LibreOffice	Reporter:	Robert <rimhoff>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	CLOSED INVALID
Severity:	normal
Priority:	medium
Version:	5.4.0.3 release
Hardware:	All
OS:	macOS (All)
Whiteboard:
Crash report or crash signature:		Regression By:
Attachments:	Save as dialog of new spreadsheet

Description Robert 2017-10-16 12:00:37 UTC

The default file format for new spreadsheets should be ODS, not CSV.
For users not familiar with the details of the file formats, it is very annoying that all formatting and formulas are lost when saving in CSV.
In addition, there should be a warning when saving as CSV to that effect.

(Just as an example, an accountant friend who is not very computer savvy spent two days balancing the accounts between two spreadsheets imported from a bank, highlighting the matching rows with different colors and meticulously saving periodically, only to discover after closing the files and reopening them that all formatting was lost.)

Comment 1 Timur 2017-10-16 13:39:18 UTC

The default file format for new spreadsheets *is* ODS. 
If you worked on already existing CSV, it's saved like that. 
It's upon user to understand file formats. 
LO has "Confirm File Format" warning. 

If you disagree and can add something to show it's LO issue, please explain in detail *with steps* and set back to Unconfirmed.

Comment 2 Robert 2017-10-16 13:46:44 UTC

Created attachment 137013 [details]
Save as dialog of new spreadsheet

Comment 3 Robert 2017-10-16 13:47:57 UTC

Steps to reproduce: (on my installation under MacOS 10.12.6)

1) Create a new Calc document

2) select File menu -> Save as ...

3) the default file type is CSV

Comment 4 Urmas 2017-10-17 02:53:12 UTC

What is the setting of Options - "Load/Save" - "General" - "Default file format and ODF settings" - "Document type: Spreadsheet"?

Comment 5 Robert 2017-10-17 03:58:49 UTC

You are so right! I never noticed that "Load/Save" - "General" - "Default file format and ODF settings" ...

Sorry to have taken up your time ...