I’m not sure if I reproduced the situation correctly, but the behavior seems similar.
Try copying the values and pasting them before the two locked rows. The table will start to lengthen.
And one more question. Is it normal library behavior if when pasting values go to the next cell after the locked cells in the edited cell (enabled row)? Or must the values stop being inserted as soon as they hit the first blocked cell? The wall effect.