I am trying to export data from a lo calc spreadsheet to an accounting program (Kashflow) via csv files.
Kashflow uses a web app “csv importer” to upload csv files. Their support team tell me that using CSV files generated using MS Excel, the upload runs smoothly (during which you can map columns etc). However, when I try to upload a csv file created using Lo, the columns and rows get a bit messed up, and the upload is inaccurate.
I have played around with various csv options - the Kashflow team tell me that all that is required is that the data is delimited by columns.
I am not entirely sure that this is just a lo problem. It may be a windows versus linux problem.
Has anyone come across this before?
Thanks in advance, Cahir