We are facing an issue where we are not able to set a Column’s data type as Text in the Exported Excel sheet. Because of this Excel is treating the data as numeric and removed leading zeros
Hey @bhushanbcg, unfortunately I wasn’t able to reproduce the issue you are having. If at all possible, could you please provide a snippet where the issue is visible?
From my limited testing, if a column is provided an exportType
with a value of string
during export, Excel will then treat it as a text cell: https://snippet.webix.com/4fiqrvqx. As you can see, the leading zeroes are present in the exported file.