Is it possible to set the options of the worksheet?

Tags: #<Tag:0x00007fee36819468>

Update an option in a certain setting, for example, I set the options as :

  • allowInvalid: false,
  • source: colors,
  • type: ‘autocomplete’,
  • strict: true,

after i press Enter, set immediately, strict: false for example

Hi @vodoiovcbn9x

It seems to work fine in this example https://jsfiddle.net/akt2oc90/ (table-level settings, latest version). I tested it on Chrome 109 / macOS Ventura. Does it work for you?

1 Like

I wanted to press Enter to reset the cell to strict:false (previously true) but I solved the problem using setCellMeta. Thank you for your reply

Good to know. Thank you for the prompt update.