Description: Files saved as CSV files have various limitations and one of them is that they only support *one* sheet per file. LibreOffice allows to create multiple sheets in a CSV file that however, will not be saved. My suggestion is that a warning message is displayed when a new sheet is created inside a CSV file that the new sheet can not be saved in the same file. Steps to Reproduce: 1. Open Calc 2. Save file as CSV file 3. Create new sheet Actual Results: New sheets can be created however the user likes and there is no warning that you can not save multiple sheets in one file. Expected Results: IMHO LibreOffice should show a warning right when a new (second) sheet is created inside a csv file. It shouldn't block you from doing it as a) you can save both sheets in multiple csv files and b) you can save it as any other file type later (you might just based the your file on an existing csv file) Reproducible: Always User Profile Reset: No Additional Info: This feature request is based on https://bugs.documentfoundation.org/show_bug.cgi?id=89781
LO-calc is never **inside a csv-file**! … but it **import** csv. LO triggers already a warning-message if $USER try export to non-native odf-formats (aslong $USER doesn't explicitly switch off thus messages ) ⇒ NAB
(In reply to Werner Tietz from comment #1) > LO-calc is never **inside a csv-file**! … but it **import** csv. > > LO triggers already a warning-message if $USER try export to non-native > odf-formats (aslong $USER doesn't explicitly switch off thus messages ) > > ⇒ NAB Technically speaking it's true that you see the import windows if you open a csv file. However, it's not really clear from the user perspective once the csv file is opened. Once the information is imported, there is real indication that additional sheets are not compatible with the current file type. Yes, you get the warning-message when you try to save in a non odf format. Yet this error message is the exact same as with the MS office file types making it only a general disclaimer that just says that some features _may do not work_ - it's not said that they clearly don't. The difference between _might not work_ and _will definitely not work_ is the line between the general disclaimer for non odf files and a file type that does not even support certain basic functionality.
Created attachment 204957 [details] CALC - feature request - adding sheets to csv file Steps: 1) I open the file 2) It shows the import windows 3) I add two new sheets that you won't be able to save at all as the csv file is not compatible with them Other than the import window in 2 there is no real warning that a csv file is different. My suggestion was about adding a warning at step 3. Something like a short pop-up saying that this won't be supported in CSV files. IMHO the general warning box when you save your file in a non odf format is not specific enough. Furthermore if you open the csv file and add a new sheet and save the file while while you view the second sheet, the information from the second sheet is basically erased from your hard drive without you getting any note other than the default _it potentially could miss a few features_. Additional thought: Maybe adding a new table should be blocked if the file type you work in is a csv file (it may is something else under the hood, but in the window bar the file still is a csv file and if you save it and ignore the window it basically behaves exactly like every other file).
There is no "current file type"! A spreadsheet or delimited data source opened into LibreOffice Calc has been converted as needed for use with all features of an OpenDocument Spreadsheet. CSV or any other delimited data format is external export. An actual objection might be that LibreOffice holds lock on the source data file, and points save/export back to that on save. Rather than immediately releasing the lock and naming the ODF SpreadSheet with the source name (with .ods file type extension if os requires). Require an explicit export action to actually write the external CSV (or other delimiter) data file. Agree => NAB
RFE, so through UX... Something to be said for forcing a filter imported (i.e. *opened*) CSV (or other delimited data file) immediately into OpenDocument Format spreadsheet (.ODS) identification. Renaming as needed and releasing the source data file. No accidental Save data loss. And CSV then *explicitly* an external format and an export action. That would protect against underwarnning of data loss. Otherwise the current warning is sufficient, and users need to be reminded that CSV is not an ODF format. And this => WF
I would split the document model with multiple sheet capability from the file storage. Similarly we do not warn in Draw at every action that saving as raster graphic breaks the vectoring. Regarding bug 89781 I see no blocker to save sheets with data in multiple CSVs like <export>_sheet1.csv, <export>_sheet2.csv, etc.
(In reply to BDF from comment #0) > Additional Info: > This feature request is based on > https://bugs.documentfoundation.org/show_bug.cgi?id=89781 UX input done on bug 89781. Essentially the idea is to solve bug 135762 and have any kind of query before saving the document. I suggest to resolve this ticket as INVALID.
(In reply to Heiko Tietze from comment #7) > (In reply to BDF from comment #0) > > Additional Info: > > This feature request is based on > > https://bugs.documentfoundation.org/show_bug.cgi?id=89781 > > UX input done on bug 89781. Essentially the idea is to solve bug 135762 and > have any kind of query before saving the document. I suggest to resolve this > ticket as INVALID. Fine by me if you think it reaches the same goal.