Describe the bug
Range Assembly construction appears to go into an infinite loop and consume unbounded memory with some very complicated sheets with complicated array formulas and lookup functions
To Reproduce
I do not have one I can share. I suspect it's happening in the code that attempts to partition the range assembly construction, but I haven't nailed it down.
Steps to reproduce the behavior:
'...'
'....'
'....'
See error
Expected behavior
A clear and concise description of what you expected to happen.
Screenshots
If applicable, add screenshots to help explain your problem.
Desktop (please complete the following information):
OS: [e.g. iOS]
Version [e.g. 22]
Additional context
Add any other context about the problem here.
vinci1it2000
commented
2 years ago
Describe the bug Range Assembly construction appears to go into an infinite loop and consume unbounded memory with some very complicated sheets with complicated array formulas and lookup functions
To Reproduce I do not have one I can share. I suspect it's happening in the code that attempts to partition the range assembly construction, but I haven't nailed it down.
Steps to reproduce the behavior:
Expected behavior A clear and concise description of what you expected to happen.
Screenshots If applicable, add screenshots to help explain your problem.
Desktop (please complete the following information):
Additional context Add any other context about the problem here.