So as of this evening I am seeing Spill taking over my formulas, as in no matter what I do if I have a column of consecutive formulas Spill will fill the next cell below as soon as I complete a formula in the cell above.
This is an issue as I'm trying to use different formulas as I'm progressing down the column but Spill is not letting me. If I try to delete the auto filled formula, there is actually nothing to delete, it's a phantom formula, formula bar syntax is greyed out and the formula keeps showing up.
If I try to delete a formula above I get an error #spill or something.
Temporary workaround is to move each next formula to one column to the right (imagine staircase going from top left to bottom right) which still fills the cell below but at least I am able to change the formula as I need it in each new row.
I would be much obliged if someone could advise me on how to disable this hijacking behavior. It's ridiculous and coming out of left field.