Description: When importing from CSV, the "Format quoted fields as text" provides a way to distinguish text from numeric fields. However the corresponding export-to-CSV feature is missing: There is no way to generate a CSV with Text fields quoted. So the format gets lost in a round-trip from spreadsheet to CSV and back to spreadsheet (often needed to use text-oriented tools to manipulate the data). IMO exporting to CSV should, by default quote fields which have Text (not numeric) format even if they don't contain special characters (for example numers). Steps to Reproduce: 1. Load attached demo.ods spreadsheet; verify that the format of A2 is Text and B2 is Number(General) 2. File->Save As... change file Name and set output drop-down to Text CSV(.csv) 3. File->Open... navigate to the saved .csv file Check "Format quoted field as text" 4. Check format of A1 (rightclick->Format Cells...->Numbers:Category) Actual Results: A2 has numeric format in the imported document, rather than Text Expected Results: Export should have quoted A2 because it was Text, so it could be imported as Text Reproducible: Always User Profile Reset: No Additional Info: .
Correction to Step 4 above: Check format of A2 (not A1)
Created attachment 169289 [details] test.ods (see steps to reproduce)
Created attachment 169291 [details] screenshot I tested with Version: 7.2.0.0.alpha0+ / LibreOffice Community Build ID: f2389a70da606768a39ee599de6a5b24058734aa CPU threads: 4; OS: Linux 5.8; UI render: default; VCL: gtk3 Locale: ro-RO (ro_RO.UTF-8); UI: en-US Calc: threaded And everything is ok. Don't forget at step "Save as" to check "Quote all text cells". See the screenshot.
Right you are. I mis-read that option as "quote all cells". Thanks for the correction. Closing