Hi Andrew,
ca you give a code example how to lock a cell and how to protect a sheet.
For you to understand the background of my question: I export CMS data to Excel for easy translation. Lateron I will reimport the translated data. To identify contentitems I export a unique id for each text cell. Those must not be modified by the user of the exel sheet. Therefore I would like to protect or lock those fields. A password is not neccessarry, as user will not destroy the sheet by purpose.
How would you do this with POI?
Thanks in advance.
Robert Andrew Kharchuk wrote:
As far as I know you can't lock column. You can lock cell.
You can protect sheet using: 1. POI (without password) 2. template with VBA
----- Original Message ----- From: "rsoese" <[EMAIL PROTECTED]> To: <[email protected]> Sent: Thursday, December 30, 2004 5:55 PM Subject: Lock Column and protect sheet
Hello,
I browsed through the Javadocs of the latest POI release and I could not find out if there is a method for:
locking a column protecting a sheet
The only thing that I found was a method to get to know if there is protection.
Any ideas if/how I could accomplish my task?
thanks in advance,
Robert
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
