We've giving our users a list of items to pick from when reviewing previously submitted data. The statuses they can pick from are Pending, Approved and Rejected.
We're seeing very weird behavior when someone activates the pick list in the A column and displays the options but does not choose a value. They then visit another page on the site. Then when they return to the spreadsheet to select a value again, the button to open the pick list appears when the cell is selected, but when clicked, the button does not display the list of options. Actually, nothing happens when you click the dropdown button. The only way to remedy this issue is to logout of the application, log back in and then visit the table again.
We are not setting any login/account related criteria on the button, just providing the 3 options to choose from. I've tried replicating this using a DOJO on your site and wasn't able to get the same results.
Here is the JSON we're using to populate the spreadsheet. Is there something wrong with my configuration or do you think there might be a bug in your code?
spreadsheet.fromJSON({"sheets":[{"frozenRows":1,"name":"Lot Tracking","rows":[{"cells":[{"value":"Status"}]},{"cells":[{"value":"Rejected","color":"#D0021b","bold":true,"validation":{"allowNulls":false,"dataType":"list","comparerType":"list","from":"{ \"Pending\", \"Approve\", \"Reject\" }","showButton":true,"type":"reject"},"enable":true}]},{"cells":[{"value":"Rejected","color":"#D0021b","bold":true,"validation":{"allowNulls":false,"dataType":"list","comparerType":"list","from":"{ \"Pending\", \"Approve\", \"Reject\" }","showButton":true,"type":"reject"},"enable":true}]}]}]});
Thanks in advance for your help.
Greg