rhandsontable icon indicating copy to clipboard operation
rhandsontable copied to clipboard

Infinity/NA not handled properly

Open fproske opened this issue 6 years ago • 1 comments

Hi, when converting the R dataframe to JSON, you deliberately chose to convert all special values to "null" instead of "string": https://github.com/jrowen/rhandsontable/blob/639b0a511b216391df44c45ea7ef8c934269c28a/R/rhandsontable.R#L117 . Was there a particular reason for this? I tried setting it to "string" instead and handsontable seems to parse this properly!

fproske avatar Nov 28 '19 09:11 fproske

I found the reason in the documentation:

To improve readability, NA values will be displayed as blank cells

Still don't find this very convincing, though. Essentially, when converting dataframe to hot and back causes data loss this way, which should not be the default imo. Feel free to close this if you disagree.

fproske avatar Nov 28 '19 09:11 fproske