Get Free Trial

Excel Export of True and False values inconsistency

Re-Open
Kevin Nguyen asked on September 14, 2021

When exporting True or False values created from calculated measures in the pivot table, there is inconsistency from what is displayed in the UI vs the Excel export.
The pivot table displays 1 or 0 for true of false respectively, but excel displays true and -.
There should be consistency when exporting logical values since a lot of our users are expecting a 1:1 output in the excel export.

4 answers

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster September 15, 2021

Hi Kevin,
 
Thank you for posting your inquiry.
 
Our team will look into this issue and provide a fix with our upcoming release on ETA Oct 4th.
 
Please let us know if there is anything else we can help you with in the meantime.
 
Best regards,
Mykhailo

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster October 5, 2021

Hi Kevin,
 
The reported issue with converting 1 and 0 to true and false when exporting to Excel was fixed.
 
This is provided in the 2.9.9 version of Flexmonster: https://www.flexmonster.com/release-notes/.

You are welcome to update the component. Here is our updating to the latest version tutorial for guidance: https://www.flexmonster.com/doc/updating-to-the-latest-version/.
 
Please let us know if everything works fine for you.
 
Best regards,
Mykhailo

Public
Mykhailo Halaida Mykhailo Halaida Flexmonster October 12, 2021

Kevin,
 
Just checking in to ask if you’ve had a chance to test out the fix we’ve introduced in our last release. Is everything working well for you?
 
We’d be happy to hear your feedback!
 
Regards,
Mykhailo

Public
Kevin Nguyen November 11, 2021

Yes, the true/false is now consistent. They are always 1 or 0 in excel export. Thank you for the fix and response.

Please login or Register to Submit Answer