Forum Discussion
Spill Error with Filtering Random Numbers
Hi All
I'm trying to do a simple Filter on a sample data and getting Spill errors. Can't seem to explain why it's happening. So basically I have 12 months on one column and random numbers from 0-100 in the next column. A simple Filter to get values >50 works most of the time. Sometimes it returns a #SPILL error. There is nothing below the cells to cause this. I'm attaching the sample file. To test this try hitting the F9 key a few times to trigger the error. It does not happen if the numbers are non-random. Has anyone seen this error?
Most of the time this works flawlessly:
Sometime it errors out:
3 Replies
Detlef_Lewin , Thank you for that! It is interesting that it works 90%+ times. Good to know it's a known issue and hopefully will get resolved in a future update.
I don't think such behaviour will be changed in nearest future. My guess it requires quite fundamental changes in calc engine.
