Excel: Save Spreadsheet to Table - Inferring Column Types
Thomas_937381
Posts: 196
For Excel: Save spreadsheet to table, can someone confirm how Excel cell / column formatting are taken into account - if at all - when inferring a column's data type? Does Catalytic always default to text?
Knowing this will be important for e.g. Tables: Sort rows, as a text-type column containing numbers may not sort as one would expect.
Tagged:
0
Answers
-
Have upvoted this feature request: https://community.pushbot.com/discussion/654/infer-columns-for-excel-save-to-table-action
If someone could confirm that we currently always infer text-type columns for Excel: Save spreadsheet to table, that would be great.
0