Copy from Excel into AutocompleteField in Table doesn't match data type

Which tool versions are you using?

SDK: v14.16.2
Platform: v24.12.8
Python: v3.10
Isolation mode: venv

Current Behavior

In our parametrization we have a table that contains an AutocompleteField. The options= for that field is a list of int.

When table contents is copied from Excel into Viktor, it is saved as str in the params. The UI shows the values in red as an invalid value. Even though the value is in the list of options.

Changing the cell type in Excel doesn’t resolve the issue.

Expected Behavior

When copying from Excel the data type should be respected.

Hi @rkg,

This topic may be relevant for you: Using a number as an option value within a table.

I just had a look in the code and noticed that we add a warning regarding this behavior for the OptionField only. I expect this should be extended to the AutocompleteField as well.

The latest SDK version 14.18.0 includes a warning for the AutocompleteField as well.

Too bad to see that the proposed solution is apparently not possible.

In addition to showing the warning, could the (SDK) documentation maybe also be updated?
Right now there’s no way to know the limitations imposed by Table/DynamicArray (like the min/max not working for NumberField). That makes developing the parametrization a bit of a trail-and-error which is a waste of time.