Agreed, the auto-complete is great 95% of the time but please let us disable it until these remaining 5% is fixed. Sometimes it also puts seeming random variables whenever I click somewhere.
I like the automatic column formatting, but yeah I guess if you’ve set it explicitly it doesn’t make sense for it to keep looking to change type