My multiple_select field has a choice_filter [not(select…) type].
It has 10 possible responses.
The choice_filter is correct - namely 1,3,5,9 i.e. the 4 of the 12 options not selected.
When I look at the xlsx download the 1 3 5 9 is correct in the first multi-select column.
But when the columns are split up into 12 columns the order is 10 - 1 - 3 - 2 - 5…
I would expect the order to be 1-2-3-4-etc-12
Why is this?
The order is strange but the answers are correct.
Very confusing - can anyone explain?
I have attached the dowloaded xlsx file - look for column qq11 for the first occurance of my query.
Thanking you in advance.