Re: [libreoffice-users] Locking a single cell in a Calc sheet using a macro

2012-07-20 Thread Graham Luffrum
Using styles I get it to work. It's a pity though that one can't simply set isLocked. Graham On 19 July 2012 13:35, Johnny Rosenberg gurus.knu...@gmail.com wrote: 2012/7/19 Graham Luffrum grhmlf...@gmail.com: Hi, I am trying to write a macro that will, amongst other things, lock a

[libreoffice-users] Locking a single cell in a Calc sheet using a macro

2012-07-19 Thread Graham Luffrum
Hi, I am trying to write a macro that will, amongst other things, lock a single cell in a Calc sheet. I can easily test to see if the cell is locked, using CellProtection.IsLocked, but I don't see how to change the value. Any ideas? Graham -- For unsubscribe instructions e-mail to:

Re: [libreoffice-users] Locking a single cell in a Calc sheet using a macro

2012-07-19 Thread Mike Scott
On 19/07/12 11:19, Graham Luffrum wrote: Hi, I am trying to write a macro that will, amongst other things, lock a single cell in a Calc sheet. I can easily test to see if the cell is locked, using CellProtection.IsLocked, but I don't see how to change the value. Any ideas? Graham Way

Re: [libreoffice-users] Locking a single cell in a Calc sheet using a macro

2012-07-19 Thread Johnny Rosenberg
2012/7/19 Graham Luffrum grhmlf...@gmail.com: Hi, I am trying to write a macro that will, amongst other things, lock a single cell in a Calc sheet. I can easily test to see if the cell is locked, using CellProtection.IsLocked, but I don't see how to change the value. Any ideas? Graham I