[Libreoffice-bugs] [Bug 124053] New: UX: csv handing confusing.

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 124053
           Summary: UX: csv handing confusing.
           Product: LibreOffice
           Version: 6.1.0.3 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: simski at dds.nl

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:

-- 
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/20190313/ede08ef6/attachment.html>