react-spreadsheet-import icon indicating copy to clipboard operation
react-spreadsheet-import copied to clipboard

Empty Boolean values are treated as 'false' instead of undefined

Open jeremylyng opened this issue 2 years ago • 2 comments
trafficstars

Appreciate your work on this project all!

As the title suggests, I'm encountering an issue when uploading a file that contains a boolean column. In the dataset, empty values haven't been defined, where as false & true should set the value accordingly. When I upload the file, the empty values return false instead.

jeremylyng avatar Nov 15 '23 22:11 jeremylyng

Hey @jeremylyng, currently that is not possible with checkbox field. But we could add a flag preserveUndefined to the checkbox field definition and if this flag is enabled then leave undefined instead of converting it to false. PRs are welcome for this.

masiulis avatar Nov 17 '23 13:11 masiulis

Thanks @masiulis a flag would work well. Unfortunately, I have a bit too much on my plate at the moment to help contribute.

jeremylyng avatar Nov 22 '23 03:11 jeremylyng