Hello,
When our Flat report is generated, it is showing leading zeros on a column. When we attempt to Export Excel then Excel doesn't show leading zeros.
Our report has a csv source that we pull down from S3 that has the following format:
[
{
"hiddenHeader": {
"type": "hidden"
},
"Submission Id (Form Attributes)": {
"type": "string"
},
"Routing Number": {
"type": "string"
}
},
{
"Submission Id (Form Attributes)": "12345679",
"Routing Number": "90410311"
},
{
"Submission Id (Form Attributes)": "039960648",
"Routing Number": "0038192134"
}
]
Flexmonster Version: 2.9.43
Workaround: Our customers can obviously export a CSV and important it into excel. Then define each column type, but it seems like Flexmonster should do this since it knows the types and displays them accurately.
Thanks,
Patrick
Hello Patrick,
Thank you for reaching out to us.
We could not reproduce the described issue with leading zeros on our side. You are welcome to check the following JSFiddle for reference: https://jsfiddle.net/flexmonster/w81ve2d9/. In the example, the zeros are displayed as expected when exporting to Excel via the Toolbar.
Please edit the example above to show the issue. It would greatly help us.
Looking forward to hearing from you.
Kind regards,
Nadia
Hello Patrick,
Hope you are doing well.
We were wondering if you still face the issue with leading zeros. Is there still anything we can help you with?
Looking forward to hearing from you.
Kind regards,
Nadia