I agrees with you with the first point. I have faced issues like that. But for the second point you have mentioned, If you specify the coordinate as a num(), I believe it would show it as a number. Worth giving a try!
Hope the excel export functionality improves with the upcoming release.
Thanks Sangram. I tried formatting with the NUM() function as well, regarding the latitude and longitude coordinates, and they still get reformatted/truncated in the excel export. I even tried surrounding the num function with a text function (e.g. TEXT(NUM(34.360666199999997, '0.000000000000000')) and the export comes out as 34.3606662 instead of the full number.
I can only hope this bug gets fixed soon. As our users are going to be migrated off of Qlikview to Sense, I know they will notice this bug immediately <sigh>
Maybe this will help.
I had the same problem with format after exporting a NUM() format to Excel.
But I noticed the the MONEY() format was not having this issue.
So here is what I tried:
NUM(value, '#.##0') or Num(Sum(value),'#.##0')
I tried :
Money(value, '#.##0') or Money(Sum(value),'#.##0')
Maybe a strange work around but it worked for me. Hope it is helpfull.
Thanks Dennis and sorry for the late reply. Was working through some other challenges with Qlik Sense, but I finally got a chance to try your suggestion. Unfortunately no such luck, my values with the preceding zeros don't even show when I attempt to use the Money format as you described .