asked on August 16, 2023
0 and 1 values displayed in the UI are being replaced by 0.0 and 1.0 values when exporting to excel. This happens with all layout forms
Our users are expecting to see a 1:1 output.
We are on version 2.9.45
⋅ August 17, 2023
Hello Wilmar,
Thank you for reaching out to us.
We recommend setting the decimal places explicitly to "0" to show 0 and 1 values when exporting to Excel:
formats: [{
"name": "decimalFormat",
"decimalPlaces": 0
}],
You are welcome to check the following JSFiddle for reference: https://jsfiddle.net/flexmonster/9zwen2q7/
Please let us know if it works for you. Looking forward to hearing from you.
Kind regards,
Nadia
⋅ August 29, 2023
Hello, Wilmar!
Hope you are doing well.
Our team is wondering if you had some time to try the suggested approach and configure decimalPlaces before exporting to Excel. Could you please let us know if it works well now?
Looking forward to hearing from you.
Kind regards,
Solomiia
⋅ September 6, 2023
Hello,
Hope you are doing well.
Just checking in to ask if you had a chance to use the decimalPlaces property. Could you please confirm if it works well for you?
Looking forward to hearing your feedback.
Kind regards,
Nadia