https://bugs.documentfoundation.org/show_bug.cgi?id=100598
Bug ID: 100598
Summary: FILEOPEN FILESAVE csv
Product: LibreOffice
Version: unspecified
Hardware: x86-64 (AMD64)
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: aa169d62...@gmail.com
Abstract:
LibreOffice saved a spreadsheet as a csv file without warning. Only one sheet
(the least important) was saved. All formulae were, as expected with csv
format, converted to textual representations of the (calculated) result.
This behavor semms different from what I remember. I would have expected
warning messages (pop-ups).
Synopsis:
1) I typed (at the BASH command prompt)
soffice surv-table.csv
2) I made numerous style changes and formulae on multiple sheets over several
hours.
3) I tried to close the file (X in the right side of the title bar), Calc asked
me if I wanted to save my changes, etc.
4) OF COURSE, I said I wanted to save my changes.
5) When I tried to open surv-table.ods, I found it did not exist.
6) Further investigation found that the first sheet (the one with the fewest
formulae) had been saved in surv-table.csv
Details:
OS: Linux Mint 17 Qiana
LO Version: 4.2.8.2
Did not try with any other operating system or version.
1) I found some data on the web. I copied and pasted it to an editor, modified
it, and save it with a csv extension. Note: Normally I would not save it with
that extension, but LibreOffice will otherwise try to use Writer. An annoyance
that I can live with. (Normally I would use no extension.)
2) I opened the file with ``soffice surv-table.csv''. (I usually use the
command line as it is more efficient. If I open calc and then use insert, LO
will use some bizarre directory and not the current directory.)
3) I made many edits, using styles, but more importantly complicated formulae.
Multiple sheets were used. Other programs were used to make sure the
formulae were correct.
4) I actually thought I had saved my work, but when I clicked X in the title
bar, I was asked if I wanted to save my changes, ...
5) OF COURSE, I wanted to save my work!!!!!
6) I said YES, but LO Calc saved only the first sheet.
I am sure that at some point in the past I tried to save a Calc file that I
thought was a spreadsheet and I was warned with something to the effect that
``Some features of LO Calc will be lost if saved in this format.'' Further, I
am pretty sure that whenever trying to save a spreadsheet with multiple sheets
in csv format, there is a warning pop-up to the effect that only the current
sheet will be saved. What is going on?
Please do not save spreadsheets as csv files without warning. (A spreadsheet
has styles, formatting, and/or formulae.)
Suggestion: If one types ``soffice foo.csv'', IMMEDIATELY change the internal,
not the file system name, to ``foo.ods''. After all, it appears as if one is
modifying an ods file.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs