Re: POI3.14 Change to AddMergedRegion

[Richard Schoen <Richard.Schoen@xxxxxxxxxxxxxxx>]

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