I think this is super confusing for end users. If you paste in Excel data that is using exponential notation in some way, the whole column will read in as text. Quite possibly this should be identified by regex and then replaced with a value and assumed to be numeric unless otherwise specified by the user.
I think this is super confusing for end users. If you paste in Excel data that is using exponential notation in some way, the whole column will read in as text. Quite possibly this should be identified by regex and then replaced with a value and assumed to be numeric unless otherwise specified by the user.