Date & character column to factor after editing about excelr HOT 5 CLOSED

Thank you for reporting the issue. This clearly has been an oversight on my part.
In case of date it is easily identifiable as calendar type in js so can be easily set as date while converting back.
In case of factors and characters both will of text type in the js side so converting it back is a little tricky. Either it will always be converted to character or always converted to factor. So this will have to be managed in a better way. What kind of output do you expect?

from excelr.

Hi, I think character would be preferable
If original data has any factor field there might be warning that it would be converted to character after edits
Or if want to get more complex we could add extra parameter in function stringsAsFactors = TRUE/FALSE

from excelr.

I guess stringAsFactors = TRUE/FALSE would make it more predictable. Another option would be changing the factors into dropdown instead of just plain text with autoColTypes, which would make it more predictable and also be useful I to create dropdowns I guess.

from excelr.

Yes, this could also be solution for type mapping:
factor <-> dropdown
character <-> text
I think it is something similar in rhandsontable

from excelr.

@marciz This has been fixed in the latest development version.

from excelr.