When we fill in values in a Spreadsheet and the cell has a dropdown list, the dropdown list is gone. This is annoying as our customer wants to see which options were available as well. We extracted the options from the sheet exactly how they are configured, without any changes.
We use ApiRange.SetValue to insert the value of the customer into the cell, which works but like said above the dropdown list is gone. See images attached:
How the cell looks like before being filled in:
How the cell looks like after it is filled:
How it should look like when filled in with the SetValue:
Also note that before filled in - the cell has a bold formatting and this is also not been taken over…
Are we doing something wrong or is this a bug?
Kind Regards