Re: HSSF Indirect

[broehmer@xxxxxxxxxxxxxxx]

John, 
What I have been charged with is an auditable
spreadsheet that can be summarized and then proven
with that detailed information.  I can't just throw
up a spreadsheet and say..there ya go.  Nope,
If I put detailed information that can be verified at
the nibble level, then I'm good. 
To have this done with RPG is really great.  Means
we can keep the Power 7 around a little longer without
having to wait for some PC spreadsheet guru to 
point out the inability of a language that still has
a lot of game.  Especially with what Scott has provided
us.  No way would I want to reinvent what he did.  It's
just so cool that we get what he has done for us all.


Bill Roehmer
Senior Pgmr/Analyst
The C.D. Hartnett Company





From:   John Yeung <gallium.arsenide@xxxxxxxxx>
To:     "RPG programming on the IBM i (AS/400 and iSeries)" 
<rpg400-l@xxxxxxxxxxxx>
Date:   01/09/2015 04:41 PM
Subject:        Re: HSSF Indirect
Sent by:        "RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx>



On Fri, Jan 9, 2015 at 5:10 PM,  <broehmer@xxxxxxxxxxxxxxx> wrote:
> What's being demanded now
> is the summary, which we can do but also the supported
> detail shown on individual tabs with formulas on the summary.

I still don't see why INDIRECT is needed for this.

> And understand, I run the report and then enter the formula by hand
> to get the results after its creation right now.  Not an acceptable 
result
> for an ongoing application to need continued programming support.

No, it's not acceptable.  But right now, what formula are you entering
by hand?  Does that formula involve INDIRECT?  I don't ask
rhetorically; I would like to see the actual formula you use.

John Y.