Bug 160611

Summary: After opening a CSV file, and changing it, the save buttons saves it back to CSV, removing all the changes
Product: LibreOffice Reporter: noxtras
Component: CalcAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED NOTABUG    
Severity: normal    
Priority: medium    
Version: 7.6.2.1 release   
Hardware: x86-64 (AMD64)   
OS: Windows (All)   
Whiteboard:
Crash report or crash signature: Regression By:

Description noxtras 2024-04-10 09:45:12 UTC 
Description:
I open a CSV file, I edit it, change colors, backgrounds, fonts, border, add formulas, then clicking save, it saves the file back to csv, thus removes all the changes.
If there are changes that can't be saved, the program needs to ask "Are you sure you want to save as CSV, all your changes will be lost. To keep your changes please save the document as xls" or any other format.

Steps to Reproduce:
1.open csv file
2.change colors, add background, formulas, etc
3.click save

Actual Results:
saves the file back to csv

Expected Results:
saves the file as xls or some other format that keeps the changes


Reproducible: Always


User Profile Reset: Yes

Additional Info:
Version: 7.6.2.1 (X86_64) / LibreOffice Community
Build ID: 56f7684011345957bbf33a7ee678afaf4d2ba333
CPU threads: 12; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
Comment 1 Mike Kaganski 2024-04-10 10:17:32 UTC 
Yes. And when you open an XLS, it saves to XLS (only having 64K rows and 256 columns). This is expected. And to avoid the problems, by default, LibreOffice shows a warning when saving to external formats (including CSV), telling about possible formatting / data loss. Users can choose to check "don't show again" in the warning, but that means, that they know what they are doing.

This is not a bug.