Range Assembly inefficient

[owinebar]

Range Assembly inefficient

[vinci1it2000]

Can you specify the version of the formula that you are using?

[owinebar]

1.2.2, the latest at the time of raising the issue

[vinci1it2000]

Can you share/send the file? Just to understand where is the problem

[cetedus]

Hi,

I have encountered the same issue .

All it takes is for an excel file to have formula with range encompassing entire column
e.g.
=SUM(B:B)

this will cause, as far as I can tell
in formulas/tokens/operand.py
these values to be used:

maxcol = 16384
maxrow = 1048576

(in this case maxrow) which will produce an unnecessarily large object in memory (for one column around 500MB , for 2 columns around 1GB etc. ..)

For now I am using a workaround by checking max cols/rows in all sheets of the file and overwriting maxcol/maxrows with those values, but maybe you have a better idea how to properly fix it in your library ?