Spreadsheet auto-detection of column type uses integer when it should use double for some dynamic types #1999
Open
Description
Since parsing, for example, "[2018-07-21T00:00:00, 0.123]; [2018-07-21T00:30:00, -0.345]; [2018-07-21T03:00:00, 0.333]" is valid as a dynamic integer (losing the decimal part), it is auto-selected instead of double, and if the user chooses that then loses the decimal part.
Fix it by either preferring decimals or making the dynamic parser not accept decimal numbers for integer types.