Home / ubuntu / Questions / 1118440
In Process
pkaramol
Asked: 2019-02-16 00:02:04 +0800 CST

Libre Office Calc keeps removing quotes

  • 772

I am opening a .csv file using LibreOffice Calc.

However, no matter the format I choose to save the file with after modifying it (either ODF or CSV) for some columns that contained quoted values, the quotes are gone after the save process.

Any suggestions about how to keep the original column formatting?

libreoffice csv

1 Answers

  1. In the .csv format, one can specify that strings should be quoted. These quotes will not show up after you opened the .csv file in Calc.

    To make sure that strings are quoted in the .csv file on disk, make sure to check "Quote all text cells" in the "Export Text File" dialog.

    If you want to have quotes displayed in your column data (i.e., be part of the actual data), then "escape" the quotes using the same quoting sign. e.g., a string displayed in Calc as "string with spaces" will appear in the .csv file as ...,"""string with spaces""",... if you have chosen the same quote as delimiter in your .csv file.

    • 4