I user spreadsheet to let user import data from excel
everything work fine, except only when the cell have “/” inside.
how can I get actual cell value instead of the calculated data?
the date and name contain / are all error.
Hello @savirusing ,
When you fetch a date field from an excel file, it shows some integer/floating point number. So you need to convert Excel date values to JavaScript date objects. Please check the next example:
https://snippet.webix.com/e3bd9mf8
so there is no way to set the cell format using base_template?
for example in this snippet, some cell is not date but is a product code like.
https://snippet.webix.com/t2sx3za9