Formulas still calculate in a locked row and change the results

You misunderstand the purpose of row locking.

Please see here: https://forum2.seatable.io/t/effect-of-row-locking-on-formula-columns/1344/2?u=rdb