RE: RNX0301 using hssf_formula() in HSSF/POI witn SUMIF()

["Dennis Lovelady" <iseries@xxxxxxxxxxxx>]

> I would try using a named range instead, but HSSFName object class is
> not
> implemented in Scott's service program, and the syntax for doing it
> myself
> is not readily apparent.
>
> Has anyone implemented range / cell names?  I don't know if it will let
> me
> circumvent my SUMIF() problem or not, but it is about the only syntax
> variation left to try.

If you need these posted in order for formatting to be correct, say the
word.  Enjoy.

D HSSFWorkbook_createName...                                          
D                 PR                  like(HSSFNameRecord)            
D                                     ExtProc(*JAVA                   
D                                     :'org.apache.poi.hssf.usermodel-
D                                     .HSSFWorkbook'                  
D                                     :'createName')                  
D HSSFWorkbook_removeName...                                          
D                 PR                  like(HSSFNameRecord)            
D                                     ExtProc(*JAVA                   
D                                     :'org.apache.poi.hssf.usermodel-
D                                     .HSSFWorkbook'                  
D                                     :'removeName')                  
D old_name                            like(jstring)                   
                                                                      
D HSSFName_setNameName...                                             
D                 PR                                                  
D                                     EXTPROC(*JAVA                   
D                                     :'org.apache.poi.hssf.usermodel-
D                                     .HSSFName'                      
D                                     :'setNameName')                 
D name_name                           like(jstring)                   
                                                                      
D HSSFName_setReference...                                            
D                 PR                                                  
D                                     EXTPROC(*JAVA                   
D                                     :'org.apache.poi.hssf.usermodel-
D                                     .HSSFName'                      
D                                     :'setReference')                
D reference                           like(jString)                   

Dennis Lovelady
http://www.linkedin.com/in/dennislovelady
--
CONGRESS.SYS corrupted.  Reboot Washington DC <Y/N>?