Application Freezes When Uploading an Unopenable Excel File #3244

New Issue

urhome-wz · 2024-11-05T06:44:26Z

urhome-wz commented

2024-11-05 06:44:26 +00:00

When attempting to upload an Excel file that cannot be opened (for example, due to file corruption, incorrect format, or other issues), the current application page freezes. This is a significant usability issue as it leaves the user with no option but to either wait indefinitely or force close the application.
sheetjs demo

When attempting to upload an Excel file that cannot be opened (for example, due to file corruption, incorrect format, or other issues), the current application page freezes. This is a significant usability issue as it leaves the user with no option but to either wait indefinitely or force close the application. [sheetjs demo]([url](https://oss.sheetjs.com/))

sheetjs commented

2024-11-05 12:51:21 +00:00

Which demo are you referencing? We can clean it up

richjeffery commented

2024-11-06 13:21:07 +00:00

Hi @sheetjs - I'm also having this issue. I have tried to load this sheet into sheetjs ( https://uksa.statisticsauthority.gov.uk/wp-content/uploads/2021/04/2022_Self-Assessment_sheet_V3.0.xlsx ) , and whilst it works on https://oss.sheetjs.com/, it crashes out on https://sheetjs.com/sql/ and spikes my laptop to 100% CPU load - never loading.

I've tried a few versions, including latest, and they all spike my browser to 100% and freeze up the tab, on latest Chrome, and Edge, and Firefox, and Opera.

Hi @sheetjs - I'm also having this issue. I have tried to load this sheet into sheetjs ( https://uksa.statisticsauthority.gov.uk/wp-content/uploads/2021/04/2022_Self-Assessment_sheet_V3.0.xlsx ) , and whilst it works on https://oss.sheetjs.com/, it crashes out on https://sheetjs.com/sql/ and spikes my laptop to 100% CPU load - never loading. I've tried a few versions, including latest, and they all spike my browser to 100% and freeze up the tab, on latest Chrome, and Edge, and Firefox, and Opera.

sheetjs commented

2024-11-06 18:45:42 +00:00

In a shocking move that "broke the web", Chrome and Safari both removed Web SQL support. https://docs.sheetjs.com/docs/demos/local/websql includes a historical note.

We will revisit that demo and replace it with an alternative approach (e.g. https://docs.sheetjs.com/docs/demos/data/sqlite#browser with sql.js)

Are there any other demos eliciting the same issue?

In a shocking move that "broke the web", Chrome and Safari both removed Web SQL support. https://docs.sheetjs.com/docs/demos/local/websql includes a historical note. We will revisit that demo and replace it with an alternative approach (e.g. https://docs.sheetjs.com/docs/demos/data/sqlite#browser with `sql.js`) Are there any other demos eliciting the same issue?

richjeffery commented

2024-11-06 19:07:45 +00:00

Apologies, I wasn't being very clear @sheetjs, I can see that if I load up any other file I get a lovely red warning message, but with the excel file above the entire tab freezes.

I also get this same behaviour on the x-spreadsheet demo: https://docs.sheetjs.com/xspreadsheet/

And this conversion demo: https://oss.sheetjs.com/sheetjs

Apologies, I wasn't being very clear @sheetjs, I can see that if I load up any other file I get a lovely red warning message, but with the excel file above the entire tab freezes. I also get this same behaviour on the x-spreadsheet demo: https://docs.sheetjs.com/xspreadsheet/ And this conversion demo: https://oss.sheetjs.com/sheetjs

richjeffery commented

2024-11-18 16:45:11 +00:00

Hi @sheetjs - thought I'd attach the file with the issue, in case you can offer any workarounds for how to load this on my installation?

I note that weirdly, it crashes https://docs.sheetjs.com/xspreadsheet/ and https://oss.sheetjs.com/sheetjs, but not this one: https://oss.sheetjs.com/ - which notes that it handles it without storing the data - and I'm wondering whether it's something to do with the issue. On my own installation, it seems like SheetJS/the browser doesn't read the end of the file, leaving it stuck in a little bit of a 'loading limbo'.

Hi @sheetjs - thought I'd attach the file with the issue, in case you can offer any workarounds for how to load this on my installation? I note that weirdly, it crashes https://docs.sheetjs.com/xspreadsheet/ and https://oss.sheetjs.com/sheetjs, but not this one: https://oss.sheetjs.com/ - which notes that it handles it without storing the data - and I'm wondering whether it's something to do with the issue. On my own installation, it seems like SheetJS/the browser doesn't read the end of the file, leaving it stuck in a little bit of a 'loading limbo'.

2022_Self-Assessment_sheet_V3.0.xlsx

55 KiB

Sign in to join this conversation.