Export to Excel missing leading zeros

Answered
Patrick Berens asked on September 27, 2023

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"
}
]
  • They show up correctly in the Flat report.
  • Also, the csv export shows them correctly when opened in a text editor
  • However, the Excel export loads those columns as numbers and therefore it removes leading zeros

 
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

2 answers

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster September 28, 2023

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

Public
Nadia Khodakivska Nadia Khodakivska Flexmonster October 5, 2023

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

Please login or Register to Submit Answer