Re: V7R3 - HSSFR4 Open-source POI software from Apache

And likely me as well. We’ve been running on POI 4.0.0 since last October. The conversion (for what I use it for) is about 95% complete. The only issue I haven’t yet finished is fine-tuning the image-handling API’s. It all works, but I am having trouble with precise image-resizing and positioning within a cell. Some of our spreadsheets include image thumbnails for every line and they are finicky in POI 4.0 in regards to having them fit neatly into one cell. It still works as is, but I want it polished. I have updated Scott’s sample codes to reflect the updated code.

I’m also considering stripping out all the .xls HSSF code and have it strictly XSSF only. The .xlsx file sizes is usually between 20%-50% smaller and since many of our spreadsheets get emailed, that size difference is substantial. I question the need for a file format from 1997. I’m not a fan of keeping legacy code for the sake of keeping it.

The biggest change was the migration to enums. I changed all the relevant code to be as consistent with Scott’s nomenclature so it’s very minimal, but it has changed enough that it requires a few extra lines of codes with some API calls - if you want to use only the stock Java classes defined in HSSF_H, or I’m considering creating an SS_xxx API similar to how Scott has created them to encapsulate all the new API changes and essentially hide it from the user. I go back and forth with it. A part of me likes not having to add to the HSSF4 code and strictly define the classes only in HSSF_h and the other part of me likes an all-encompassing API to handle the business.

Working with images isn’t pretty regardless of which release one is on. It’s a temperamental beast.

Would like to keep in touch with others that are going the POI 4.0.0 route and get our ducks in a row. POI 4.0.0 is really slick and easier (for me) to go through with Apache’s documentation.

On Jan 9, 2019, at 3:58 AM, Mark Murphy <jmarkmurphy@xxxxxxxxx> wrote:

That would likely be me, but I don't have anything yet. My job has, for the
moment, moved away from generating spreadsheets, so I haven't been
participating in the POI project as much as I was. However, as of POI 4.0,
the project has moved to semantic versioning so when I get back into it I
will be starting with POI 4.0. From POI 3.15 - 4.0 there are breaking
changes at each release, but starting with POI 4.0 we are committing to no
breaking changes except on major version changes. This will make the
interface easier to manage. One thing about POI 4.0, the minimum Java
version is Java 8.

On Tue, Jan 8, 2019 at 4:10 PM Don Brown <DBrown@xxxxxxxxxx> wrote:

We are using POI Version 3.14 on V7R3.

Later versions of POI will require modification to the service program as
some of the parameters have been change to enum.

Someone on this list was working on an updated service program to support
the later version POI classes.

Cheers


Don Brown

MSD Information Technology

Suite 5/29 McDougall Street Milton Q 4064
( 07 3368 7888
+ PO Box 1629 MILTON Q 4064
Ê 07 3368 7877
* Don.Brown@xxxxxxxxxx
È 0408 751 644
þ www.msd.net.au www.architect4web.com.au





I am a proud supporter of THE REFERRAL NETWORK and recommend the services
of the other member businesses. For more information please checkout the
website brisbanerefnet.com/





From: "Mitchell Reid" <mreid@xxxxxxxxxxxxx>
To: "rpg400-l@xxxxxxxxxxxx" <rpg400-l@xxxxxxxxxxxx>
Date: 09/01/2019 03:24 AM
Subject: V7R3 - HSSFR4 Open-source POI software from Apache
Sent by: "RPG400-L" <rpg400-l-bounces@xxxxxxxxxxxx>



Hi,

We are in the process of planning an upgrade from V7r1 (I know!) to V7r3.
A few years back we started using Scott Klement's open-source process to
write to Excel files from RPG. Is anybody using the process in V7r3?
... trying to eliminate any surprises.

Any information would be greatly appreciated.
Regards,
Mitchell

--
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

______________________________________________________________________
This email has been scanned by the Symantec Email Security.cloud service.
For more information please visit http://www.symanteccloud.com
______________________________________________________________________


______________________________________________________________________
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: https://amazon.midrange.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@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
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