L
L
Lo-st2019-08-05 07:49:16
libreoffice
Lo-st, 2019-08-05 07:49:16

Setting libre calc when reading a csv file so that it does not split values ​​into columns with a delimiter in double quotes?

In the CSV file I write
foo;"bar;bar"
text1;text2
Libre opens in the import window, everything is fine 5d47b4fe5dac8542163709.png:
But when it opens completely, it spreads "bar" into columns:
5d47b5275dfc6527714413.png
Maybe there is some hidden setting that I did not specify. Everywhere they write that everything should open correctly.

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question