[Libreoffice-bugs] [Bug 124859] New: Worksheets other than the first not being saved for .CSV file

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=124859

            Bug ID: 124859
           Summary: Worksheets other than the first not being saved for
                    .CSV file
           Product: LibreOffice
           Version: 6.0.4.2 release
          Hardware: All
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: mwe at fastmail.co.uk

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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190420/8abbef2d/attachment.html>