search

andmarti1424 / sc-im

sc-im - Spreadsheet Calculator Improvised -- An ncurses spreadsheet program for terminal
Other
4.8k stars 203 forks source link

A 9.9MB file takes forever to load #792

Closed simonante closed 1 year ago

simonante commented 1 year ago

This 9.9MB file that takes forever to load. The spreadsheet consists of 16 sheets, each with 421 columns, 240 rows, and some basic macros (mostly basic summation and cell references). A spreadsheet such as this with one sheet takes less than a minute to load, but with 16 sheets it takes more than 12 hours, possibly more. What makes the loading time so long? Is it that the sheet contains many cells that reference to cells that are also a reference?

simonante commented 1 year ago

Any idea?

andmarti1424 commented 1 year ago

@simonante will get back to you when I can take a look at it.

simonante commented 1 year ago

I can't believe the calculation of basic macros or a very large spreadsheet would take that long. Still can't figure it out.

NicolasHatcher commented 1 year ago

Hi @simonante does sc-im support macros? Also your 9.9MB file is not a public file, not sure if you intended that.

andmarti1424 commented 1 year ago

@simonante Please share your file and reopen this. thanks