Locking the columns

More
4 years 3 weeks ago #7793 by Mathsbuzz
Locking the columns was created by Mathsbuzz
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
Attachments:

Please Log in or Create an account to join the conversation.

More
4 years 3 weeks ago #7794 by bert
Replied by bert on topic Locking the columns
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?

Please Log in or Create an account to join the conversation.

More
4 years 3 weeks ago #7796 by Mathsbuzz
Replied by Mathsbuzz on topic Locking the columns
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?

Please Log in or Create an account to join the conversation.

More
4 years 3 weeks ago #7799 by bert
Replied by bert on topic Locking the columns
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

Please Log in or Create an account to join the conversation.