Yeah I was asking about the ability to control those widgets such as Menu and/or menu items.
See what happens is the following for my case. I need to completely disable "cut/copy-n-paste" a selection of rows/columns AND protect the sheet. Well: 1) HSSF allows protection the sheet thru password setting etc. But does not allow disabling the "cut-n-paste" 2) XSSF allows protection at cell level with the disabling of cut-n-paste. But no API to set password setting to protect the sheet. POI developers user list did confirm that was a bug and they should have had that set up like HSSF does....basically build on HSSF interfaces. SO I am trying to use option 2 while disabling "Review....unprotect sheet" menu item :) Thanks for your quick reply Mark Walid t. -----Original Message----- From: MSB [mailto:[email protected]] Sent: Wednesday, March 24, 2010 1:06 PM To: [email protected] Subject: Re: HSSF hide menu item? Are you asking if it is possible to disable - just as an example - the Save As menu option? If so, then the answer is no. POI is not able to control Excel in the way that VBA macros can; you can use POI to create and edit files that are compatible with Excel. Yours Mark B TARAF, WALID (ATTSI) wrote: > > Hi everyone, > > I am tryin to disable a menu item in the Excel file I generate...for > example "Review....unprotect sheet" > Has anyone been able to do either of the following using HSSF? > > I am able to lock the sheet, and set up a password etc...but I do not > see any functionality to disable particular menu item (almost like a VB > macro would do). > > Thanks for your consideration > wt > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > > -- View this message in context: http://old.nabble.com/HSSF-hide-menu-item--tp28018065p28018163.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]
