Summary: | CSV document create new sheet erases the old sheet | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | David ISAL <david.isal2> |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | RESOLVED NOTABUG | ||
Severity: | normal | CC: | miguelangelrv |
Priority: | medium | ||
Version: | 7.4.1.2 release | ||
Hardware: | x86-64 (AMD64) | ||
OS: | Linux (All) | ||
See Also: | https://bugs.documentfoundation.org/show_bug.cgi?id=160672 | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: |
Description
David ISAL
2022-11-07 10:51:57 UTC
This is not a bug. CSV format is just a comma-separated text format, which cannot store several sheets at all. It is normal that any feature unsupported in the chosen format is lost. LibreOffice warns you by default when you save to any external format (i.e., non-ODF), telling that formatting and data might be lost. Ignoring that warning, or even disabling it (unchecking "Ask when not saving to ODF or default format" checkbox in the warning dialog) and then loosing data is user error. You may check if you had disabled that warning once (e.g., because you incorrectly believed it's useless), at Options->Load/Save->General, "Warn when not saving to ODF or default format" checkbox. hello, Mike and thank you for the rapid answer! I should disagree with you, Yes this is not a dev bug of libreoffice, and I have checked the same behaviour with M$ Office: creating antoher sheet erase the first one with CSV. However I think this is a functional bug as users can destroy data inadvertedly. So, maybe this should be taken into account. I find @Mike answer clear enough, about there is no way to save several sheets in CSV format. But it's easy having the data in an ODS file, and use Menu/File/Save a copy to get the CSV without destroy the file with the data. Hello Mike Kaganski, Miguel Angel RV, I agree with you when you say: " CSV format is just a comma-separated text format, which cannot store several sheets at all" Ok, this is not a bug as it follows the CSV protocol. But, I should disagree from the user point of view, as it permits to easily loose your documents with a normal usage of Open Office. So I suppose this should be an added functionality, handled by OpenOffice, to prevent users from loosing their files. Just my opinion though. :p You can close the bug request anyway, the point is just , I suppose a software like libreOffice should take care of possible users miss-actions and prevent any erasing of their datas (whatever the CSV format). |