Hi, Even i'm trying for the same feature.To allow some cells to be locked (uneditable) I followed datavalidation approach infact it is not right way but done my job.
If you need further information let me know I'll send the sample code for datavalidation. Regards, Naga. Daggubati wrote: > > I am using Jakarta HSSF POI to create an excel file in Java. I am able to > set password protection for the whole sheet. > > But I need to set it only for a few columns and the others should be > editable. > > I checked in Excel and there is an option "Allow Users to Edit Ranges". I > would otherwise like to lock specific cells. I tried the cellstyle locked > but it did not work. > > Is this feature available in Jakarta or are there any other APIs that have > this feature. > > Please Help. > > Thanks > M > ----- Regards, Naga. -- View this message in context: http://www.nabble.com/Setting-Range-Protection-in-Excel-File-using-Jakarta-POI-tp24399154p24403458.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
