Spotfire automatically determines data type from first 100 rows of data when loading data from text/excel. A new option is expected by users, that is, "load all numeric data (determined as integer or real or others) as real", in order to use real type for all numeric data without manually specify it in data setting dialog ( could be hundreds or thousands of columns).