Thank you so much for your reply.
But I looks it's impossible although in OOXML based workbook(excel2007), They
still inform me "You are trying delete a row that contains a locked cell.
Looked cells cannot be deleted while the worksheet is protected".
I want some cells of one row are ready only, so I must set these cells are
locked. Although I enable the option ("allow delete rows") when setting protect
sheet. It also says I cannot delete the row because that contains some locked
cell.
Could you please tell me some other way?
-----Original Message-----
From: Mark Beardsley [mailto:[email protected]]
Sent: 2011年3月20日 4:10
To: [email protected]
Subject: Re: Regarding allow delete the rows on protect sheet
Sorry, mistake there, I just checked with Excel. You would be able to do this
using XSSF and creating an OOXML based workbook - an .xlsx. HSSF does not
offer the level of control over protection you require.
If you know in advance of building the workbook which row you wish to
protect in this manner then create a template file using Excel. Set the
protection exactly as you want it and then save the file. Open it with HSSF
and populate with data.
Yours
Mark B
--
View this message in context:
http://apache-poi.1045710.n5.nabble.com/Regarding-BigGridDemo-Special-characters-issue-tp3965446p4082423.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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
