×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Reggie,
First time I tried, I forgot the apostrophes?
Anyway, I usually populate detail sheet(s), then the summary sheet(s).
While in the detail sheet, when it comes time to =sum() a column -- I
construct the formula and stuff it into an rpg variable, then later I use
that variable for the formula on the summary sheet.
hth
John
------------------------------
On v5r4, it's my third time using Scott's HSSFR4 POI36 and I'm stumped. This time the workbook has a second sheet, Summary, and I want to refer to cells in the first sheet, SAB7132. I know in Excel to use formula, ='SAB7132'!D17, for example, in sheet Summary to refer to cell D17 in sheet SAB7132. I know how to use ss_formula() and refer to another cell within the same sheet but I can't figure out how to this other thing.
Thanks,
Reggie Acosta
www.brownjordan.com<
http://www.brownjordan.com>
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
