Forum Discussion
TheAntony
Jul 18, 2020Iron Contributor
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:
tbsouza: Please remove the import for the BrowserModule from any other module because it is already imported in the AppModule when you create the Angular application. You should only import the CommonModule in all other modules.
Hope it helps!!
3 Replies
Sort By
- Detlef_LewinSilver Contributor
- TheAntonyIron Contributor
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.