Recognize type when exporting to excel
Currently when you have a dataset and you export it to excel, it works great except for field types. Excel likes to assume what data type is in each cell, and in cases where there are string values with padded zeros (e.g. 0012345) excel thinks it's a number and drops the padding.
Is there any way you can apply column formatting (even the most primitive like Double=>Number, String=>Text, Decimal=>Money, etc.)? This would preserve data during the transition to excel making the export a true 1:1.
14
votes
Brad Christie
shared this idea