Re: Newsletter / Marketing: xssf cellstype setAlignment

[Mark Murphy <jmarkmurphy@xxxxxxxxx>]

Enums are just classes, so define the enum like this:

dcl-c HorizontalAlignment_ENUM
org.apache.poi.ss.usermodel.HorizontalAllignment;
dcl-s HorizontalAlignment                  Object(*JAVA:
HorizontalAlignment_ENUM);

Then you probably want to be able to retrieve an enum by the name, so you
also need to define a valueOf method like this:

dcl-pr HorizontalAllignment_valueOf
                     Like(HorizontalAlignment)
                     ExtProc(*JAVA: HorizontalAlignment_ENUM: 'valueOf')
                     Static;
  value           Like(jString) const;
end-pr;

And finally you can define the setAlignment method like this:

dcl-pr HSSFCellStyle_setAlignment
                    ExtProc(*JAVA: HSSFCellStyle_CLASS: 'setAlignment');
  horizAlign  Like(HorizontalAlignment) const;
end-pr;

On Mon, Nov 6, 2017 at 6:07 PM, Don Brown <DBrown@xxxxxxxxxx> wrote:

> I suggest you go to version 3.14 of POI.
>
> We recently updated t this version which added a number of functions we
> required, particularly the streaming option for very large excel files and
> does not have the new enum options.
>
> Alternatively if you sort out all the java method calls using enum's I am
> sure quite a few people on this list would look to use it.
>
> Cheers
>
>
> Don Brown
>
>
>
>
>
> From:   RWillis@xxxxxxxxxxxxxxxxxxxxxxxx
> To:     rpg400-l@xxxxxxxxxxxx
> Date:   07/11/2017 07:35 AM
> Subject:        Newsletter / Marketing:  xssf cellstype setAlignment
> Sent by:        "RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx>
>
>
>
> Can anyone suggest how I can change the prototype and call to
> ssCellStyle_setAlignment in Scott's HSSFR4 service program to work with
> POI HSSF version 3.17? Seems the parm has changed from a short data type
> to an enum. I can't figure out how to define the prototype to get the call
>
> to work.
>
> I've been successfully using POI HSSF version 3.6, but now trying to
> convert to release 3.17.
>
> In version 3.6 the setAlignment definition was;
> void setAlignment(short align)
>
> In version 3.17;
> void setAlignment(HorizontalAlignment align)
>
> This is in class org.apache.poi.ss.usermodel.CellStyle.
> The prototype as defined in HSSF_H for version 3.6 is;
> D HSSFCellStyle_setAlignment...
> D                 PR                  EXTPROC(*JAVA
> D                                     : HSSF_CELLSTYLE_CLASS
> D                                     : 'setAlignment')
> D   align                             like(jshort) value
>
> I've tried various data types and keep getting a compile error;
>
> The type of parameter 2 specified for the call does not match the
> prototype.
>
> ______________________________________________________________________
> This e-mail and any files transmitted with it may be privileged and
> confidential and intended solely for the use of the individual or
> entity to which it is addressed.  If the reader of this message is
> not the intended recipient, or an employee or agent responsible for
> delivering this message to the intended recipient, you are hereby
> notified that any dissemination, distribution or copying of this
> communication is strictly prohibited.  If you have received this
> e-mail in error, please notify the sender immediately by replying
> to this e-mail and deleting it from your computer.
> ______________________________________________________________________
> --
> 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: http://amzn.to/2dEadiD
>
> ______________________________________________________________________
> This email has been scanned by the Symantec Email Security.cloud service.
> For more information please visit http://www.symanteccloud.com
> ______________________________________________________________________
>
>
> --
> 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: http://amzn.to/2dEadiD