It looks like the latest version of the wrapper on Scotts site is for
version 3.6. The conditional formatting wrappers were added in 3.8 so he
won't have it. There have been several discussions over the years on how
to map the java calls into the wrapper. You could try and map them
yourself. Looking at the sample java program there appear to be quite a
few new mappings that would be needed.
Kevin Bucknum
Senior Programmer Analyst
MEDDATA/MEDTRON
Tel: 985-893-2550
-----Original Message-----
From: RPG400-L [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of
Roche, Bob
Sent: Thursday, July 07, 2016 3:33 PM
To: RPG programming on the IBM i (AS/400 and iSeries)
Subject: RE: hssf poi conditional formatting.
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=JT4bFCEs2xdeQQAa525oWReuJMXFbG4JGctnC9w
efAg&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=JT4bFCEs2xdeQQAa525oWReuJMXFb
G4JGctnC9wefAg&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_m
ailman_listinfo_rpg400-2Dl&d=CwICAg&c=S6jE3hMA0s16gx2_CUBBn4vjc1odLunI6M
Svd_AfdV8&r=Ub_YbVSedaHB7-0yGANN94iTrfkU2nCKT1D5-5Jv01Y&m=JT4bFCEs2xdeQQ
Aa525oWReuJMXFbG4JGctnC9wefAg&s=PwCDMtZX3rEqjKkakkpHgbrjEMxzhcPueegHunQU
12g&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=JT4bFCEs2xdeQQAa525oWReuJMXFb
G4JGctnC9wefAg&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:
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.
Please contact support@xxxxxxxxxxxx for any subscription related
questions.
midrange.com
