<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 - UX: csv handing confusing."
href="https://bugs.documentfoundation.org/show_bug.cgi?id=124053">124053</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>UX: csv handing confusing.
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.1.0.3 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>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>simski@dds.nl
</td>
</tr></table>
<p>
<div>
<pre>Description:
The way Libreoffice Calc handles CSV files is confusing and causes loss of user
work without notification of the loss beforehand during saving.
Scenario:
open a csv file and add a column with a formula. add a chart with the resulting
data.
Save file and close.
reopen file and notice loss of chart and formula.
Libreoffice in its current state allows adding formulas and formatting, not
able by the csv format to handle that, hence, it should throw up a warning that
the added unsupported elements are lost on saving,
OR
It should change its behavior so it should *import* CSV files into a unamed
file. so the user is forced to choose a extension for its file, including a
warning that saving as CSV will result in the los of formatting, formulas and
sheets.
As a example, look at how gimp handles jpeg files. Gimp can edit jpegs and add
layers, but only can EXPORT to jpeg as information will be lost on saving it a
jpeg again.
The latter methode is more consistent with files format handling by other
programs. Of course both solutions together is the most consistent solution.
tldr:
the csv file format cannot handle all the things we can add to a spreadsheet
hence should be handled as an import/export format.
Steps to Reproduce:
1. open csv file
2. add column with formula to alter data
3. make chart of resulting data.
4. save file.
Actual Results:
no warning is thrown up about loss of information, but file is saved.
5. open resulting file and confirm it does not look like the file you saved
Expected Results:
warning about loss of info and formatting
OR
handle it as a import and ask user to give the *new* file a name and extension
and after that (if a incompatible file format like csv is choosen) a warning
about loss of formulas, formatting, charts and sheets.
Reproducible: Always
User Profile Reset: No
OpenGL enabled: Yes
Additional Info:</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>