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.
⋅ 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
⋅ 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
⋅ 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
⋅ 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.
