Description:
for large fake-arrays (made of cells that are made of formulas containing absolute and relative references [ A1 , $A$1, $A1, A$1 , $A1:$A100 …]
esp since if redundant origin, e.g. rows/columns of same origin copy-paste or drag-expanded from few cells, 

when expanded into the 10000's+ or into when in both horizontal/vertical direction , getting complex, this happens,

using actual arrays is not convenient since they have restriction on how they may be resized or edited, also the keyboard shortcuts are different than that in excel

Steps to Reproduce:
i'm not sure i can post the spreadsheet, and it is not an isolated exmaple
but general gist is that it includes 
math, 
string operations (mid, &, "", search)
offset
countif's
sums
if-statements

often that spreadsheet contains clusters of cells that
are more-or-less grouped into modules, thus maybe that taken into account for optimization

Actual Results:
when really big and complex, high latency, (click and time for UI to respond, app hangs/freezes 0.5-several seconds occasionally), spreadshreet not redrawing (blank occasionally during freezes and scrolling,

Expected Results:
perhaps internally calc notices that the cells are somewhat redundant or follow a patter and therfore optimize it's execution to be more lightweight without significantly(or at all) affecting its accuracy, 


Reproducible: Always


User Profile Reset: No



Additional Info:
i couldn't find other bug/meta-bug about this, it seems vague but the problem might be brad , about in the way the spreadsheet processes&parses&executes the spreadsheet