Mark, I am facing a similar situation. My requirement is to basically make the generated .xlsx file as read only. The enableLocking method almost achieves this functionality, but there are two shortfalls.
1. In cases where the cell content is longer than usual, I am unable to stretch the column width to view the cell content completely. This defeats the purpose of the Report. 2. Clicking the Unprotect Worksheet button under the Review tab, revokes this entire setting. In other words, the sheet is editable. Please let me know if you have any suggestions. Regards, Raghu -- View this message in context: http://old.nabble.com/POI-XSSF-API-how-do-I-lock-specific-Excel-sheet-features--tp27332341p28447752.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]
