Is it possible to set the options of the worksheet?

Tags: #<Tag:0x00007f8b23eb34e8> #<Tag:0x00007f8b23eb3290>
#1

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

#2

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
#3

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

#4

Good to know. Thank you for the prompt update.

#5