If you are one of the 8 hundred users of HSSFCGI and you have created from your RPG programs some XLSGEN script to generate EXCEL worksheets, we got news for you.
As you know, with XLSGEN you may generate column subtotals by specifying formula VSUM.
Now, you may also sum up all your column subtotals in a "grand total" using a new formula: XVSUM.
See the example at page http://www.easy400.net/hssfcgip/xvsumtry.pgm .
Giovanni B. Perotti
HSSFCGI author
easy400.net site owner
As you know, with XLSGEN you may generate column subtotals by specifying formula VSUM.
Now, you may also sum up all your column subtotals in a "grand total" using a new formula: XVSUM.
See the example at page http://www.easy400.net/hssfcgip/xvsumtry.pgm .
Giovanni B. Perotti
HSSFCGI author
easy400.net site owner