Re: POI3.14 Change to AddMergedRegion

Richard, you and I are in "violent agreement" :)

I enjoy the open-source-under-PASE regimen, but as soon as you start
getting fancy, why wrestle with it there? I favor leveraging all this great
technology IBM has put at our fingertips on Power servers and set up a
Linux LPAR. Do the web magic there and slurp the data back and forth from
the i LPAR letting i do what i does best.

Along these lines, my Ublu <https://github.com/jwoehr/ublu> remote control
language for the i runs in a window if desired. Of course designed for me
and my users running from Linux/Mac/OpenBSD/Windows to robot IBM i. I tried
Ublu windowing mode via the X windowing system from IBM i a few weeks ago.
It took > 5 minutes for the window to come up ... Whee!

On Mon, Oct 23, 2017 at 9:58 AM, Richard Schoen <
Richard.Schoen@xxxxxxxxxxxxxxx> wrote:

Or set up a Linux VM which takes a few minutes.

Also a possibility is to hook up the Linux server to the IBM i so you
don't need to necessarily deal with the oddities of things not working on
the i.

ACS runs fine on Linux as does Libreoffice if you need documentation tools
running on Linux.

And the best part for me is that .Net runs on Linux now as well !!

Nice idea to present this at COMMON as a class.

Regards,


Richard Schoen
Director of Document Management
e. richard.schoen@xxxxxxxxxxxxxxx
p. 952.486.6802
w. helpsystems.com

------------------------------

message: 2
date: Mon, 23 Oct 2017 08:13:19 -0600
from: Jack Woehr <jwoehr@xxxxxxxxxxxxxxxxxxxxxxxx>
subject: Re: POI3.14 Change to AddMergedRegion

I think for IBM i folks who have not drunk the Open Source koolaid yet :)
the secret is to set up a PC with Linux at home and fiddle with this stuff.

If we are to use Open Source as IBM increasingly prescribes for IBM i, then
we have to get used to the environment and also the ethos of a community in
which all users are participants and are expected, in extremis, "to be able
to paddle their own canoe across the lagoon", as the Samoans say.

I have proposed a presentation on this subject for the spring COMMON.


On Mon, Oct 23, 2017 at 6:24 AM, Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>
wrote:

Jack

Not all of us use SVN, nor do we know how to get to the source the way

you

do. We can use Google to get to javadocs - I've done that - Google is one
of my best friends!!

Regards
Vern

On 10/22/2017 11:15 AM, Jack Woehr wrote:

And if you want the change history of
org.apache.poi.hssf.usermodel.HSSFSheet just check out the source and

use

the svn commands to view file history.

On Sun, Oct 22, 2017 at 10:13 AM, Jack Woehr <
jwoehr@xxxxxxxxxxxxxxxxxxxxxxxx> wrote:

From the Javadocs:

- addMergedRegion

public int addMergedRegion(CellRangeAddress <
https://poi.apache.org/apidocs/org/apache/poi/ss/util/
CellRangeAddress.html> region)

Adds a merged region of cells on a sheet.
Specified by:addMergedRegion
<https://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/
Sheet.html#addMergedRegion-org.apache.poi.ss.util.CellRangeAddress->

in

interface Sheet
<https://poi.apache.org/apidocs/org/apache/poi/ss/usermodel/
Sheet.html>
Parameters:region - to mergeReturns:index of this regionThrows:
java.lang.IllegalArgumentException - if region contains fewer

than 2

cellsjava.lang.IllegalStateException - if region intersects with a
multi-cell array formulajava.lang.IllegalStateException - if

region

intersects with an existing region on this sheet


On Sun, Oct 22, 2017 at 9:56 AM, Jack Woehr

<jwoehr@absolute-performance.

com> wrote:

Read the source code?

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-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