I need to save my LO calc file as a comma delimited CSV to import into another system.
It requires a return at the end of each row but the character is incorrect.
Is there an option to change the row end character?
What is the default character? It appears to be a normal return but if I delete it and replace with a normal return the import works fine.
Thanks for your help.
Kevin
This is not an answer; it’s a workaround.
CSV is a simple text format, but there are variations in delimiters across programs. I had no problem moving data (saved from Libre Calc as .csv) into other programs. So I’ll venture a guess that your receiving software may be looking for a particular form of delimiter that’s a bit out of the ordinary.
Instead of CSV, try using Data Interchange Format. DIF is perhaps the oldest widely used spreadsheet-compatible format, and is precisely formated. It is supported by nearly all programs that process spreadsheet-styled data. From Libre Calc, “Save As” .dif and try to pull it into your system.