https://bugs.documentfoundation.org/show_bug.cgi?id=154709
Bug ID: 154709
Summary: After saving as CSV (proceeding past the warning),
there is no warning on close that unpreservable
formatting or additional worskheets will be lost.
Product: LibreOffice
Version: unspecified
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
If I open a CSV file, the first time I try to save it I will get a warning that
some formatting might not be preserved when saving as a CSV instead of ODS.
There is a checkbox on this warning that says "Ask when not saving in ODF or
default format", but even after keeping this checkbox checked, I do not receive
a warning on subsequent saves. It is possible to close the file and permanently
lose formatting without any further warnings.
It is my opinion that at least one of two things should happen:
1. it should warn again on closing, to reduce the likelihood that work is lost
2. it should reload the file from disk after saving, and so not display the
formatting which is already lost from the file saved on disk (which will then
be permanently lost on closing anyway) -- you should immediately lose what you
are going to lose, and have the ability to do ctrl-z to revert and save in a
different format.
The current flow has led to a lot of lost work, which is witnessed by many
confused and dismayed forum threads:
https://forum.openoffice.org/en/forum/viewtopic.php?f=9&t=58649
https://ask.libreoffice.org/t/recover-overwritten-csv-files-with-multiple-worksheets/52263
https://ask.libreoffice.org/t/saving-as-csv-no-warning-solved/45883
Steps to Reproduce:
1.open a CSV file
2.make some change
3.save (ctrl+s)
4.in warning dialogue leave "Ask when not saving in ODF or default format"
checked
5. make some other change, e.g. highlight a row or add a worksheet
6. a) save (ctrl+s) again, then close -- no warning that you are about to lose
work
b) OR just close, now you get a warning that "Your changes will be lost if
you don't save them." But actually they will be lost anyway, because it is
still saving to csv
Actual Results:
expect to receive a warning before an action that can permanently lose my work
-- expect when reopening a file, that it will look the same as it did
immediately after I saved it
Expected Results:
receive no warning
Reproducible: Always
User Profile Reset: Yes
Additional Info:
This is a confusing UI issue especially for inexperienced computer users, has a
high impact in terms of lost work, and can turn people off of libreoffice.
--
You are receiving this mail because:
You are the assignee for the bug.
