Bulti-in Export to HTML odd results 8.1

If you think that something doesn't work in Aware IM post your message here
Post Reply
Jaymer
Posts: 2430
Joined: Tue Jan 13, 2015 10:58 am
Location: Tampa, FL
Contact:

Bulti-in Export to HTML odd results 8.1

Post by Jaymer »

2 issues. Almost latest 8.1 bld.
Using a simple grid, with the "Export to CSV" Panel Operation

1) A simple numeric field in the millions ($12,123,456) exports in scientific notation. (not the worst thing in the world - imported to excel and it stayed in that format. I had to explicitly change it to numeric/currency to make it appear correct.) If its under 100Trillion, or in the Billions, you'd think its safe to just export "as is".

2) A shortcut field in a grid exports the column name NOT as the displayed name (ie. Company) in the Grid, but as the internal field name (ie. sc_compname)

jaymer...
Click Here to see a collection of my tips & hacks on this forum. Or search for "JaymerTip" in the search bar at the top.

Jaymer
Aware Programming & Consulting - Tampa FL
Post Reply