OpenProjectExcel icon indicating copy to clipboard operation
OpenProjectExcel copied to clipboard

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

Open JanFrankeDB opened this issue 3 years ago • 2 comments

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

JanFrankeDB avatar May 24 '22 05:05 JanFrankeDB

Hi @JanFrankeDB ,

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

Best

Bernd

bpetraus avatar Jun 06 '22 12:06 bpetraus

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

JanFrankeDB avatar Jun 21 '22 06:06 JanFrankeDB