Thanks for the tip. I didn't realize that it was on the style object. I was searching for it on the cell class. Sent via BlackBerry
-----Original Message----- From: Anthony Andrews <[EMAIL PROTECTED]> Date: Fri, 18 Jul 2008 00:16:41 To: POI Users List<[email protected]> Subject: Re: Unlocking cells in a worksheet As far as I am aware, the only way to lock/unlock a cell is through the HSSFCellStyle object applied to it. Therefore, my guess is that you would need to clone the cell style, call the setLocked(boolean) method on that clone and then apply it to the cell again. The reason you would need to clone the style, in my opinion, is that if you simply change the cell style you recover from the cell then you risk unlocking all of the cells that style is applied to. --- On Thu, 7/17/08, Mahesh Ganapathy <[EMAIL PROTECTED]> wrote: From: Mahesh Ganapathy <[EMAIL PROTECTED]> Subject: Unlocking cells in a worksheet To: [email protected] Date: Thursday, July 17, 2008, 4:46 PM I am creating an excel file using poi. At the time of creation all cells by default are locked. Is there a way to unlock specific cells before I writeProtect the rest of the worksheet? Sent via BlackBerry --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
