Checkbox #badvalue when pasted with empty data

Tags: #<Tag:0x00007efc6b50cf58>
#1

Hi again :slight_smile:

Iā€™m having issues with checkboxes in handsontable when data is pasted from excel

My users have a large excel template that uses boolean values, but most of the time these are empty on the spreadsheet.
Is there a way to have these ignored, and the value left as null when pasting?

To reproduce, use this stackblitz

Paste an empty cell from Excel onto the checkbox cell. Note that it will change to #bad-value# rather than ignoring the empty value

Thanks
Matt

#bad-value# checkbox cell value when pasted empty value
#2

Hi Matt,

you can try the skipColumnOnPaste option. I can see that you already use columns so it should not be a problem.

Updated example https://stackblitz.com/edit/angular-j9vyu8?file=src/app/app.component.ts

#3