Re: Updating POI HSSF POI to 4.0.0 -- RPG400-L

No problem. I figured the problem out. A nested class is declared differently than non-nested class.

Instead of:

D ANCHORTYPE_CLASS...
D C 'org.apache.poi.ss.usermodel-
D .ClientAnchor.AnchorType’

I needed substitute a ‘$’ symbol instead of a ‘.’ for the nested class:

D ANCHORTYPE_CLASS...
D C 'org.apache.poi.ss.usermodel-
D .ClientAnchor$AnchorType’

Worked like a charm, and immediately the final roadblock to a full conversion (for my needs) was resolved. I have POI 4.0.0
The only issue I have is the way the new_SSClientAnchor works with setting images. It works differently in the current release than it used to in POI3.6 but it does work. I’m just figuring out the proper inputs which is nitpicking really.

On Nov 15, 2018, at 10:32 AM, JRusling@xxxxxxxxxxx wrote:

Wow . . commendable Eddie, and interesting!

Unfortunately, i have not the knowledge to help :-(

John

John Rusling
Senior Developer/Analyst
Quadion LLC
Minnesota Rubber & Plastics
952.927.1419

“No matter where you go, there you are!”

We build our computer [systems] the way we build our cities: over time,
without a plan, on top of ruins. —Ellen Ullman

From: Eddie Gomez <gmon750@xxxxxxxxx>
To: RPG400-L@xxxxxxxxxxxx
Date: 11/09/2018 05:20 PM
Subject: Updating POI HSSF POI to 4.0.0
Sent by: "RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx>

I decided to undertake the updating of Scott Klement’s fantastic HSSF POI
Excel-generating system to the most recent release of Apache’s POI 4.0.0
which is current as of 9/2018. I have 95% of it running just fine. Most of
our POI 3.6 spreadsheets (with minimal code changes) will run just fine on
POI 4.0.0 and JAVA 8.

The final piece of the migration is the image-processing section. I have
most of the necessary JAVA methods defined and working. I am becoming
“delayed” more than I prefer to be on one particular change that occurred
in POI 3.14.

The “SSClientAnchor_setAnchorType()” method requires a different parameter
that is of type “ClientAnchor.Anchortype”. It is an enumerated type in the
ClientAnchor interface.

As I dd in similar situations with other enums, I used POI’s _valueOf
method calls to pass the enum constant. Those all worked well. This one
for some reason does not.

As it is writing in the POI documentation… the ClientAnchor.Anchortype is
defined in org.apache.poi.ss.usermodel.ClientAnchor.AnchorType

Here’s how I have this set up in the HSSF_H source. Similar to all the
other enum-based classes I had to set up.

D ANCHORTYPE_CLASS...
D C 'org.apache.poi.ss.usermodel-
D .ClientAnchor.AnchorType’

D SSAnchorType S O CLASS(*JAVA: ANCHORTYPE_CLASS)

D SSAnchorType_valueOf...
D PR like(SSAnchorType) static
D EXTPROC(*JAVA
D : ANCHORTYPE_CLASS
D : 'valueOf')
D aType_enum like(jstring) const

D SSClientAnchor_setAnchorType...
D PR ExtProc(*JAVA
D : CLIENTANCHOR_CLASS
D : 'setAnchorType')
D type like(SSAnchorType)

D SS_ANCHOR_MOVESIZE...
D C 'MOVE_AND_RESIZE'
D SS_ANCHOR_SIZE...
D C 'DONT_MOVE_DO_RESIZE'
D SS_ANCHOR_MOVE...
D C 'MOVE_DONT_RESIZE'
D SS_ANCHOR_FIXED...
D C 'DONT_MOVE_AND_RESIZE’

———————————

This is a section of my RPG code that sets up and initiates the call:

D at s like(SSAnchorType)
at = SSAnchorType_valueOf(new_string(SS_ANCHOR_MOVESIZE));
SSClientAnchor_setAnchorType(imgAnchor: at);

—————————————————

The result is the program bombs saying the class could not be found. I’ve
gotten this same error on other classes and have always resolved them.
This particular one is different as it appears to be a class within a
class. Here is the error message in case it helps.

received Java exception "java.lang.NoClassDefFoundError:
org.apache.poi.ss.usermodel.ClientAnchor.AnchorType" when calling method
"valueOf" with signature
"(Ljava.lang.String;)Lorg.apache.poi.ss.usermodel.ClientAnchor.AnchorType;"

in class "org.apache.poi.ss.usermodel.ClientAnchor.AnchorType". Recovery .

———————————————

Any idea would be greatly appreciated. It’s pretty cool running (finally)
on the most recent version of POI. Quite a few issues we’ve had with
POI3.6 and functionality issues with Excel and XSSF have been resolved
now.

Thanks in advance!

Eddie
--
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://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com
<br />
The information in this email is confidential and may be legally privileged.
It is intended solely for the addressee. Access to this email by anyone else is
unauthorized. If you are not the intended recipient, any disclosure, copying,
distribution or any action taken or omitted to be taken in reliance on it, is
prohibited and may be unlawful.
--
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://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxx for any subscription related questions.

Help support midrange.com by shopping at amazon.com with our affiliate link: https://amazon.midrange.com