asked on April 9, 2022
When using pivot table, the UI has 0 and 1 for calculated measures, but when exporting to excel, the values of those calculated measures become false and true in place of the UI's 0 and 1. This occurs whenever "Calculate individual values" is NOT checked. This behavior is reproducible on a persistent basis. This looks like a potential bug.
Flexmonster version: 2.7.14
Scenario: Calculate individual values NOT checked
Formula: sum("XYZ") > sum("ABC")
1/0's in UI
Converted to boolean (true/false) on export
Scenario: Calculate individual values CHECKED
Formula: sum("XYZ") > sum("ABC")
1/0's in UI
1/0's in export
https://jsfiddle.net/wL6so5r3/
When trying to reproduce this in jsfiddle, the resulting excel export shows 1/0's.
⋅ April 11, 2022
Hello, Josh!
Thank you for the detailed explanation.
Our team wants to inform you that the fix for this issue was released in the 2.9.9 version of Flexmonster: https://www.flexmonster.com/release-notes/version-2-9-9.
You are welcome to update the component. Here's our upgrade guide: https://www.flexmonster.com/doc/updating-to-the-latest-version/.
Please let us know if it works for you.
Regards,
Solomiia.
⋅ April 11, 2022
That sounds like a sufficient answer. I don't know if we'll be able to do that in our scenario, but thank you nonetheless.
⋅ April 12, 2022
Hello, Josh!
Thank you for the feedback.
Please note that we are ready to assist you with the upgrading.
Feel free to contact us if any further questions arise.
Regards,
Solomiia.
⋅ August 15, 2023
Hi Solomiia. Im experiencing the same issue but only when exporting a flat pivot table. exporting it in classic layout works fine.
Working with version 2.9.45.
⋅ August 16, 2023
Hello, Wilmar!
Thank you for reaching out to us.
We have reproduced the described exporting issue on our side. Our Dev team will take a closer look at it and return to you with the update on the ETA September 4th.
We will notify you about any updates on the matter.
Feel free to contact us in case of any other questions.
Kind regards,
Solomiia
⋅ September 13, 2023
Hello, Wilmar!
Hope you are doing well.
Our team is glad to inform you that the issue with converting 1 to true and 0 to false when exporting the flat table to Excel was fixed.
The fix is included in the 2.9.59 version of Flexmonster: https://www.flexmonster.com/release-notes/version-2-9-59/.
You are welcome to update the component: https://www.flexmonster.com/doc/updating-to-the-latest-version/.
Please let us know if the fix works well for you.
Kind regards,
Solomiia
⋅ September 21, 2023
Hello, Wilmar!
Hope you are having a great week.
Our team is wondering if you had a chance to test the fix with exporting 0 and 1 to Excel. Could you please let us know if the fix works well for your case?
Looking forward to hearing your feedback.
Kind regards,
Solomiia
⋅ September 28, 2023
Hello, Wilmar!
Hope you are doing well.
Just checking in to ask if the fix with exporting 0 and 1 to Excel works well for you.
Looking forward to hearing from you.
Kind regards,
Solomiia
⋅ August 13, 2024
Hi Solomiia,
After the fix exporting 0 and 1 is showing 0.0 and 1.0.
Regards,
Shaharyar
⋅ August 13, 2024
Hello, Mahmood!
Thank you for reaching out to us.
Please note that it is possible to export numbers as integers to Excel by setting decimalPlaces format property to 0.
Please check out our tutorial for more details: https://www.flexmonster.com/doc/export-report/#display-measures-as-integers.
Hope you will find our answer helpful.
Kind regards,
Solomiia
⋅ August 20, 2024
Hello, Mahmood!
Hope you are doing well.
Our team is wondering if you had some time to check our guide about exporting numbers as integers to Excel. Could you please let us know if it was helpful?
Looking forward to hearing from you.
Kind regards,
Solomiia
⋅ August 27, 2024
Hello, Mahmood!
Hope everything is well.
Just checking in to ask if our guide about exporting numbers as integers to Excel was helpful.
Looking forward to hearing your feedback.
Kind regards,
Solomiia
