<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Worksheets other than the first not being saved for .CSV file"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124859">124859</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Worksheets other than the first not being saved for .CSV file
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.0.4.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>mwe@fastmail.co.uk
</td>
</tr></table>
<p>
<div>
<pre>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</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>