Locking the columns

Hi Bert,

I know that a long tap on column brings up the option to lock but on a column with calculations, I don’t get that option as seen in the attached image. I can lock that column if I was to do it via “Lock all columns” option but that’s not practical for me. Please help.

Kind regards
MathsBuzz

Hello Mathsbuzz,
Calculations can't be locked since they are calculated/filled in real time. What do you have in mind for that lock, to avoid manually editing by mistake?

That's right. I have typed in the column by mistake in past. Also since they can be locked when all are locked, why not individually?

They shouldn't be locked when you tap on lock all columns, it should be addressed in our next update
If you edit a calculation by mistake it will overwrites the calculation for that particular cell - you will see a red triangle on top - but you can easily restore the original value with a long tap > Original value