3 ms·
Saving CSV files. In Excel you have to do a bunch of tricks to get quotes around certain fields in the exported CSV (I end up using a custom field format to for
by ZenoArrow 9y ago
Saving CSV files. In Excel you have to do a bunch of tricks to get quotes around certain fields in the exported CSV (I end up using a custom field format to force quotes, then doing a find and replace in a text editor, as Excel likes to save "Text" as """Text"""), whereas in LibreOffice Calc there's an option to 'Quote all text cells' when exporting the CSV, which is much simpler.
- danmaz74 9y agoAlso importing CSV files works much better. I don't know how many times I had to suggest friends or customers to use openoffice for that, it was just easier than finding the right way to do it in Office.
- fwdpropaganda 9y agoThis made me smile. My usage of LibreOffice is essentially as a CSV editor.