difference in parsing csv - Google Sheets and Drive vs LibreOffice Calc

One of our google apps scripts did not work properly when data was copy-pasted into its source Google sheet by opening the data in a csv file from LibreOffice Calc, but worked when data was copy-pasted from Google Drive's csv preview. 

Apparently some fields had been interpreted differently by Calc and Google, and some fields had changed places - probably due to commas within fields, or maybe due to newlines within fields.