Jul 17 2020 08:24 PM
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:
Jul 18 2020 12:37 AM
SolutionJul 18 2020 12:48 AM
@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.
Jul 18 2020 02:04 PM
I don't think such behaviour will be changed in nearest future. My guess it requires quite fundamental changes in calc engine.
Jul 18 2020 12:37 AM
Solution