spreadsheet cannot export

Webix JS
#1

Hello webix team,
Could you help me to check why the spreadsheet cannot export?
When I click export button, the browser will no response.

The following source of the test data is the excel file I imported and serialize to JSON object.
Thanks.

https://snippet.webix.com/ckbbelf7

#2

Actually export works for me in the above snippet.
In which browser issue occurs for you?

#3

@maksim It’s firefox. By the way, my os is ubuntu.

I’ve tried to use firefox and chrome in ubuntu and windows os.
It seems have the same situation. Sometimes export success, sometimes have no response. Is this problem related to xlsx.core.styles.min.js?

#4

Hello, webix team
I am getting the following error sometimes when I try to export data to excel.
How can I fix this problem?

Source Map Error: request failed with status 404
Source Website: http://cdn.webix.com//extras/xlsx.core.styles.min.js
Source Map Website: dist/xlsx.core.min.map

–
Error: Script terminated by timeout at:
encode_col@http://cdn.webix.com//extras/xlsx.core.styles.min.js:14:26635
encode_cell@http://cdn.webix.com//extras/xlsx.core.styles.min.js:14:27036
encode_range@http://cdn.webix.com//extras/xlsx.core.styles.min.js:14:27415
encode_range@http://cdn.webix.com//extras/xlsx.core.styles.min.js:14:27364
write_ws_xml_merges@http://cdn.webix.com//extras/xlsx.core.styles.min.js:11:4514
write_ws_xml@http://cdn.webix.com//extras/xlsx.core.styles.min.js:11:13241
write_ws@http://cdn.webix.com//extras/xlsx.core.styles.min.js:12:2451
write_zip@http://cdn.webix.com//extras/xlsx.core.styles.min.js:14:23233
write_zip_type@http://cdn.webix.com//extras/xlsx.core.styles.min.js:14:25382
writeSync@http://cdn.webix.com//extras/xlsx.core.styles.min.js:14:25802

–
I’ve checked my data, it looks like the cell contains the error value.
Can I export the all data including the error? Thanks.

#5

Hi,

Error values must not be a problem
The above stack trace looks like a raw performance problem, browser attempts to serialize a huge set of data and just can’t do it in time.

Is problem occurs only for big datasets?
Can you try to copy-paste part of data in problematic spreadsheet to a new one and try to export it?

We are looking in adding optional server-side export script for cases where really big dataset need to be exported, there is no any ready-to-use code yet though.

#6

@maksim Hello,
The problem is not only occurs for big datasets.
I’ve try to copy-paste part of data in problematic spreadsheet to a new one and export it, the problem occurs.
I also try to import all data and export immediately, it export successful sometimes.
I save the same data with json format to my database and via webix.post method to parse the data to my spreadsheet, the website will no response.

#7

Unfortunately I still can’t reconstruct the issue.

The snippet which you have provided works correctly for me in all browsers
I need some way to reconstruct the issue to pinpoint the problematic code.

The stacktrace which you have provided points to the raw performance issue while file generation ( script takes too long and browser kills it ), which never occurs locally. ( it must be a really huge dataset to trigger such issue )