Setting Column Type as Text in Webix

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

Comments

  • edited September 9

    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.

Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

In this Discussion