column protection using keikai 5.x

asked 2020-09-08 04:02:57 +0800

bztom35 gravatar image bztom35
53 4

Is it possible to dynamically lock and unlock a column in a spreadhseet from being change?

Please see the demo at zkoss fiddle.


delete flag offensive retag edit

1 Answer

Sort by » oldest newest most voted

answered 2020-09-08 14:58:08 +0800

MDuchemin gravatar image MDuchemin
1758 1 5
ZK Team

Hi bztom35,

You can use the range API to add or remove a protection on a specific range: see here.

link publish delete flag offensive edit


Yes. It worked as described and thanks for your help.

bztom35 ( 2020-09-11 12:12:15 +0800 )edit
Your answer
Please start posting your answer anonymously - your answer will be saved within the current session and published after you log in or create a new account. Please try to give a substantial answer, for discussions, please use comments and please do remember to vote (after you log in)!

[hide preview]

Question tools

1 follower



Asked: 2020-09-08 04:02:57 +0800

Seen: 6 times

Last updated: Sep 08

Support Options
  • Email Support
  • Training
  • Consulting
  • Outsourcing
Learn More