Unable to pass a ZIP Code as text

1

Hello,

i am trying to set a zip code in a cell with a leading Zero. I tried to force him to use only strings with methods, but nothing works.

https://snippet.webix.com/u4mtz4xo

2

OK found a solution , but it would be nice to know why the data initially is not recognized

data: [
      [3,3,"04522", "string"]
    ]

$$("sheet").setFormatName(3,3,"string");
$$("sheet").setCellValue(3,3,"01234")
3

Hello @bikerboy ,

To recognize the data type initially its better to set its format in the styles field: Code Snippet

In this article you can read more information about spreadsheet data format.

Please check your working example: Code Snippet

1 Like
4

Thx that was really helpful