Re: HSSF workbook protection

[Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>]

Hi Arthur,

Please type the following command (this is one command -- sorry if the 
e-mail software splits it into two lines):

STRQSH CMD('javap -s org.apache.poi.hssf.usermodel.HSSFSheet > 
/tmp/sheetmeth.txt') 


This will create an IFS file named /tmp/sheetmeth.txt that lists all of 
the Java methods in the HSSFSheet class.  Then, type the following to 
see the contents of this file:

DSPF STMF('/tmp/sheetmeth.txt')

in the 'control' field at the top, type 'f protectSheet' (without the 
quotes) and it'll search for that string -- just like SEU, if you've 
used that.

In my case, it does NOT show a method by that name... therefore your RPG 
program wouldn't be able to use it. FWIW agree with the bug report -- 
the bug report says that the online Javadocs are from TRUNK.. (which is 
the copy of the code that the developers are currently working with) 
Protection was not implemented in 3.0.1 FINAL therefore, it won't 
exist... and it didn't on my system.  However, the team did recently 
release a 3.0.2 BETA which should have these new functions in it (I 
haven't tested it, though.)

If you're already trying the new version of the JAR files that do have a 
'protectSheet' method, then you need to look at the signature.  There's 
should be a line that says "Signature:" below each method.  The 
signature is a code that identifies the types of the parameters that are 
to be passed to the method.  Since Java supports overloading (i.e. 
having two separate methods with the same names, but different 
parameters) both the method name AND the signature have to match in 
order for RPG to find the method.



Arthur.Marino@xxxxxxxxxxxxxxxx wrote:
> I've had no luck trying to use the "protectSheet" method in the HSSFSheet 
> class. It fails with:
> RPG procedure HSSF_PROTE in program SOUTHERN/HSSFSRVPGM received Java 
> exception "java.lang.NoSuchMethodError: protectSheet" when  calling method 
> "protectSheet" with signature "(Ljava.lang.String;)V" in class 
> "org.apache.poi.hssf.usermodel.HSSFSheet". 
>
> A web search pointed me to a discussion thread where the guy complained 
> that the method didn't exist inside the poi release 3.0.1 FINAL file but, 
> after much playing with JBuilder, I finally got to see the class source 
> and found that the "protectSheet" method does indeed exist.
>
> So now I figure I've mis-coded the RPG. I assumed I had to code prototypes 
> for both "HSSFSheet_protectSheet()" and my own little 'wrapper', called 
> "hssf_protectSheet" (all credit to Scott Klement) and have the second 
> invoke the first.
>
> Have I coded this wrong? Or am I invoking protection at the wrong time 
> (i.e., right after the sheet is added to the workbook)?
>
> If anyone can help, I'd really appreciate it.
>
> Arthur Marino
> Southern Container Corp.
>
> The s/sheet builder program:
> // create the sheet object 
>     sheet = HSSF_newSheet(book: sht_name);  
> // set protection for the sheet 
>     hssf_protectSheet(sheet: password); 
>
> The service program:
> P hssf_protectSheet... 
> P                 B                   export 
> D hssf_protectSheet... 
> D                 PI 
> D    sheet                            like(HSSFSheet) const 
> D    string                     64A   const varying options(*varsize)
> D tempStr         s                   like(jString) 
>  /free 
>      tempStr = new_String(string); 
>      HSSFSheet_protectSheet(sheet: tempStr);
>      hssf_freelocalref(tempStr); 
>  /end-free 
> P                 E 
>
> The prototypes:
> *+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> *  HSSFSheet_protectSheet(): 
> *     set protection of a sheet in the workbook
> *       sheet          = ordinal number that specifies the sheet to 
> protect 
> *       password = res ipso loquitor 
> *+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> D HSSFSheet_protectSheet... 
> D                 PR                  EXTPROC(*JAVA 
> D :'org.apache.poi.hssf.usermodel-
> D                                                .HSSFSheet'  
> D                                             :'protectSheet')  
> D  password                           like(jString) 
>
> *+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 
> *  hssf_protectSheet(): 
> *        Shortcut to protecting an HSSFSheet object
> *        (Wrapper around HSSFSheet_protectSheet() method)
> *            sheet          = sheet object to protect  
> *            password = res ipso loquitor
>  *+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 
> D hssf_protectSheet... 
> D                 PR 
> D    sheet                            like(HSSFSheet) const 
> D    string                     64A   const varying options(*varsize)