Description: Using Libreoddice Calc Version: 6.0.4.2 Build ID: 9b0d9b32d5dcda91d2f1a96dc04c645c450872bf CPU threads: 2; OS: Windows 6.1; UI render: default; Locale: en-GB (en_GB); Calc: group (Actually Windows 7): I added extra worksheets to a .CSV file, put data in them. While doing so, I manually "saved" the file several times. Eventually closed the file, but when I reopened it, the additional worksheets had gone. I lost a lot of data / work. I did some work on another .CSV file, also adding multiple sheets, and this time, made 100% sure I had saved the file (after every significant change). But again, after I had closed the file, and reopened it, my extra sheets had gone, with the loss of data / work. Because I suspected it might happen again, before I closed that fille, I took a copy of it. When I looked at it later, it had only one worksheet, which had the original name of the first sheet, but contained the data for one of the additional sheets. Very odd. Does Calc not support multiple sheets for .CSV files? Are you supposed to "save" while working within a sheet, in order to save it? (That would be an odd way of having to work, if so). This is a pretty bad error. Actual Results: Basic data was essentially list of names and addresses (actually an electoral roll). Supplied by local authority as .CSV file. Copied all data in sheet 1 to sheet2 (leaving sheet 1 unchanged). Edited sheet2 in various ways, like deleting un-needed columns. Copied all of sheet2 to sheet 3. Filtered out un-needed records, and copied all needed records to sheet 4. Sorted 4 by postcode and address. Had "saved" file after every major change. Closed file. Only when I re-opened file some time later did I realise all sheets except the first were not there. Expected Results: All sheets created as above should have still been in the file when I re-opened it. Reproducible: Always User Profile Reset: No Additional Info: [Information automatically included from LibreOffice] Locale: en-US Module: SpreadsheetDocument [Information guessed from browser] OS: Windows (All) OS is 64bit: no (Actually running Windows 7, on Dell desktop. Version: 6.0.4.2 Build ID: 9b0d9b32d5dcda91d2f1a96dc04c645c450872bf CPU threads: 2; OS: Windows 6.1; UI render: default; Locale: en-GB (en_GB); Calc: group
with Version: 6.1.6.1 (x64) Build ID: 6008c19e488329dfd81fea1b4444c29eddaac14f CPU threads: 4; OS: Windows 10.0; UI render: default; Locale: de-DE (de_DE); Calc: i get a warning if i save an existing *.csv file: > This document may contain formatting or content that cannot be saved > in the currently selected file format “Text CSV”. > Use the default ODF file format to be sure that the document is saved correctly. creating a new *.csv file with 2 sheets gives an extra warning on save: > Warning saving the document Untitled 1: > Only the active sheet was saved.
.CSV is not a native format, it is not even a viable spreadsheet (as no formulas are encoded, just values). Data held in a .CSV (of any separator) will be filter imported to LibreOffice's Spreadsheet UI--Calc. Save is then to XML as ODF spreadsheet (.ODS). Any other format will use an Export filter. User is warned, and this facet is well documented. Advisory to users--do not work directly in formats that require filter import and filter export. Mind your data keeping it in support ODF formats, and then export the portion you need. Otherwise this is a duplicate. *** This bug has been marked as a duplicate of bug 92984 ***
Thank you very much. I did some research also, and (belatedly) realised that what I was doing was stupid. However, LibreOffice should perhaps try a little harder to inform the user that he's doing something stupid. I remember getting a warning about not using and ODF, but hadn't realised the implications. But thanks for your quick response, and it's good to know why it didn't work, and how to avoid the problem in future.