search

opf / OpenProjectExcel

MIT License
58 stars 23 forks source link

Multi select list field with comma in value can't be loaded #49

Open JanFrankeDB opened 2 years ago

JanFrankeDB commented 2 years ago

I have a multi select list field with a comma in the list value. As soon as I upload the list, the values are created with exception of this list value with a comma in it. The Excel-Sheet also deletes a space during the upload: Before: image

After: image

bpetraus commented 2 years ago

Hi @JanFrankeDB ,

you have to use ";" instead of ",". (no blank after ";")

Best

Bernd

JanFrankeDB commented 2 years ago

Hi @bpetraus , thanks for your reply. In my case the ", " is wanted because it is part of one list value. (It shouldn't be a multi select value). Thank you and best regards Jan