How do I turn off the autofill of the Spill Range Operator?

First off, ty for the example and details (not that I have any power to help). But now I see there are what I would consider 2 bugs in addition to the missing option to not auto use the xx# feature:
a) when in cell edit mode, if you move a range box with fixed reference indicators ($) to a spill range that spill range reference should also carry the fixed reference indicators ($) accordingly (e.g. $A$1:$C$3 moved to 3x3 spill range @ D1 should be $D$1#). Rules for mixed reference would be needed (e.g. in the above example if original ref was mixed like $A1:C$3 should it be $D$1# or D1# or something else?). Interestingly if you move a 'fixed' spill range box (e.g. $A$1#) to another area it WILL convert to a normal range reference WITH fixed indicators, but if you move back to original location the original fix indicators get lost.
b) when you copy a formula with a spill range reference and that new location is NOT a spill range it should revert to the corresponding range. So when you click on the formula and you drag the BOX representing the spill range operator to a range not defined by that spill range operator it WILL convert back to a normal range reference (as noted in comment above) but a cell copy operation does not do that equivalent.