I confess that I've never tried the INDIRECT function before. I just read
about it, and that really provides for some interesting abstraction. The
ss_formula can take any kind of text, so couldn't you just stuff it with
whatever you find works in regular Excel? Or is this more of an Excel
formula question, and less of an RPG one? The one point of blowup could be
if you refer to an area with a formula that hasn't been populated yet. I
don't know that this causes issues, but I seem to recall crashes on
referring to sheets or cells that I hadn't created yet.
From: broehmer@xxxxxxxxxxxxxxx
To: "RPG programming on the IBM i (AS/400 and iSeries)"
<rpg400-l@xxxxxxxxxxxx>
Date: 01/09/2015 03:05 PM
Subject: Re: HSSF Indirect
Sent by: "RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx>
Hello Scott;
Yes. Yes. Yes. Yes. No.
Just looking for an example that I can get that works.
Right now I'm building the spreadsheet that has multiple
sheets and each has to summarize to the front sheet.
I just this minute finished converting the HSSF to XSSF so
that I can use your example for start and end. Now
I'm diving into the formula. If I understand from your
example that I need ss_formula(row: 3: 'AVG('+start+' : '+end+')'
Numeric);
will average a start and stop for columns but what I don't know is
what it takes to make =AVERAGE(INDIRECT("'"&A6&"'!F6:$F$18")) work.
Bill Roehmer
Senior Pgmr/Analyst
The C.D. Hartnett Company
"CONFIDENTIALITY NOTICE: This e-mail transmission (and/or the attachments
accompanying it) contain confidential information belonging to the sender.
The information is intended only for the use of the intended recipient. If
you are not the intended recipient, you are hereby notified that any
disclosure, copying, distribution or the taking of any action in reliance
on the contents of the information is strictly prohibited. Any
unauthorized interception of this transmission is illegal under the law.
If you have received this transmission in error, please promptly notify the
sender by reply e-mail, and then destroy all copies of the transmission."
--
This is the RPG programming on the IBM i (AS/400 and iSeries) (RPG400-L)
mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/rpg400-l.
midrange.com
