Under normal operation, Hollow pools and reuses memory to minimize GC effects while updating data. This pool of memory is kept as arrays on the heap. Each array in the pool has a fixed length. When a long array or a byte array is required in Hollow, it will stitch together pooled arra...
If Excel was unable to establish the size of the spilled array, it will trigger the Spill error. Sometimes, the formula enables a dynamic array to resize between each calculation passes. If the size of the dynamic array keeps changing during calculations passes and doesn’t balance out, it w...