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
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.