Re: hssf poi conditional formatting. -- RPG400-L

Hi Scott

Yeh, conditional formatting is a feature that lets you specify, for a range of cells, different conditions that if met result in some kind of formatting, like a read background.

It means you don't need to determine in the RPG program whether something should look different - so Excel can do it easily, and we don't have to write code for it.

Our CGIDEV2 method works well with this - just need to define the range for each condition.

Vern

On 7/7/2016 3:42 PM, Scott Klement wrote:

Bob,

I'm not sure that I understand what you're referring to by "conditional formatting". There's a condition capability built into numeric formats, but I suspect that's not what you're talking about. You could also mean applying a different cell style based on some RPG "if" statement -- but I suspect that's not what you mean, since this would be pretty simple logic.

You may be talking about some specific feature of HSSF/Excel that I am not familiar with, or have never needed. Can you give us more information?

-SK

On 7/7/2016 3:32 PM, Roche, Bob wrote:

Thanks, I know how to color a cell if I know it needs colored. Scott's samples are always helpful.

In this case I have a calculation that may or may not need the cell changed. The latest version of HSSFR4 on ScottKlement.com does not have these wrapped. Understandably, Scott is and was a busy programmer. He provided us with a nice port of a tool, but only the parts he needed. Which makes perfect sense. He had a job and could not be expected to spend time converting things the company did not need.

Yes, I am using Scott's POI project. It has helped me build several spreadsheets so far. If I need to output a file, we have something for that. This gets used when I need program to get the data in the correct format for the user.

-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Magne Kofoed
Sent: Thursday, July 07, 2016 3:19 PM
To: RPG programming on the IBM i (AS/400 and iSeries) <rpg400-l@xxxxxxxxxxxx>
Subject: Re: hssf poi conditional formatting.

There is a sample program colordemo in Scott Klement's open src POI project.

https://urldefense.proofpoint.com/v2/url?u=http-3A__scottklement.com_poi_&d=CwICAg&c=S6jE3hMA0s16gx2_CUBBn4vjc1odLunI6MSvd_AfdV8&r=Ub_YbVSedaHB7-0yGANN94iTrfkU2nCKT1D5-5Jv01Y&m=JT4bFCEs2xdeQQAa525oWReuJMXFbG4JGctnC9wefAg&s=nW57A35PQGnwyqE-HtgZ05525BwRHBm9eEU4lfEr0VM&e=

2016-07-07 21:46 GMT+02:00 Roche, Bob <broche@xxxxxxxxxxxxxxxxx>:

Does anyone have sample of using conditional formatting in RPG when
building a spreadsheet using HSSF POI? I am trying to work thru a java
sample and converting it to RPGLE using RDI java method call prototype
creator, but it is a slow painful process so far. I thought I would
check to see if any already created this particular wheel.

I have a sheet with calculations. If the value is negative make it red
and bold. Sounds easy I thought.
Thanks for any help.
--
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:
https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.midrange.com
_mailman_listinfo_rpg400-2Dl&d=CwICAg&c=S6jE3hMA0s16gx2_CUBBn4vjc1odLu
nI6MSvd_AfdV8&r=Ub_YbVSedaHB7-0yGANN94iTrfkU2nCKT1D5-5Jv01Y&m=JT4bFCEs
2xdeQQAa525oWReuJMXFbG4JGctnC9wefAg&s=PwCDMtZX3rEqjKkakkpHgbrjEMxzhcPu
eegHunQU12g&e= or email: RPG400-L-request@xxxxxxxxxxxx Before posting,
please take a moment to review the archives at
https://urldefense.proofpoint.com/v2/url?u=http-3A__archive.midrange.com_rpg400-2Dl&d=CwICAg&c=S6jE3hMA0s16gx2_CUBBn4vjc1odLunI6MSvd_AfdV8&r=Ub_YbVSedaHB7-0yGANN94iTrfkU2nCKT1D5-5Jv01Y&m=JT4bFCEs2xdeQQAa525oWReuJMXFbG4JGctnC9wefAg&s=1xV8x6bMt1q-TIPDKZurWJgv7mztrky0xfqmAaVWGOM&e= .

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

--
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: https://urldefense.proofpoint.com/v2/url?u=http-3A__lists.midrange.com_mailman_listinfo_rpg400-2Dl&d=CwICAg&c=S6jE3hMA0s16gx2_CUBBn4vjc1odLunI6MSvd_AfdV8&r=Ub_YbVSedaHB7-0yGANN94iTrfkU2nCKT1D5-5Jv01Y&m=JT4bFCEs2xdeQQAa525oWReuJMXFbG4JGctnC9wefAg&s=PwCDMtZX3rEqjKkakkpHgbrjEMxzhcPueegHunQU12g&e=
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://urldefense.proofpoint.com/v2/url?u=http-3A__archive.midrange.com_rpg400-2Dl&d=CwICAg&c=S6jE3hMA0s16gx2_CUBBn4vjc1odLunI6MSvd_AfdV8&r=Ub_YbVSedaHB7-0yGANN94iTrfkU2nCKT1D5-5Jv01Y&m=JT4bFCEs2xdeQQAa525oWReuJMXFbG4JGctnC9wefAg&s=1xV8x6bMt1q-TIPDKZurWJgv7mztrky0xfqmAaVWGOM&e= .

Please contact support@xxxxxxxxxxxx for any subscription related questions.