Re: issue with Excel formula

Scott, did you decide to use something else to generate Excel, or did you
no longer need to generate Excel.




From: Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>
To: "RPG programming on the IBM i (AS/400 and iSeries)"
<rpg400-l@xxxxxxxxxxxx>
Date: 07/12/2013 04:00 PM
Subject: Re: issue with Excel formula
Sent by: rpg400-l-bounces@xxxxxxxxxxxx



Mike,

The problem I'm referring to was not evident in 2.5.1, it was
specifically in 3.1, though I think it's probably a good idea to get a
new version. Personally, I stopped using POI about a year ago, and at
that time I was running 3.6

I would also urge you to PLEASE don't put your JAR files in
/QIBM/UserData/Java400/ext. It makes it impossible to test/use other
versions of POI on the same machine/partition. Put them in another
directory, and then use the CLASSPATH to locate them.



On 7/12/2013 2:52 PM, Smith, Mike wrote:

If I'm looking in the correct place, I see poi-2.5.1
I'm looking under IBM/UserData/Java400/Ext
I see poi-2.5.1
Poi-contrib-2.5.1
Poi-scratchpad-2.5.1

Maybe I need newer versions???

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx

] On Behalf Of Scott Klement

Sent: Friday, July 12, 2013 3:35 PM
To: RPG programming on the IBM i (AS/400 and iSeries)
Subject: Re: issue with Excel formula

There was a known bug in POI 3.1 that would cause this. Are you
running POI 3.1?


On 7/12/2013 2:17 PM, Smith, Mike wrote:

A co worker of mine has written a program that creates an Excel

Spreadsheet via Scotts POI procedures.

The Spreadsheet uses the VLOOKUP formula.

When the spreadsheet is initially opened you get a message to 'Enable

Editing' but Only the first time the spreadsheet is opened.

Also the Formulas don't execute, they show #Value, However if you press

F2 on the formula it will execute .

I've compare the formulas before and after hitting F2 and they appear

the same(which I expected).

Any idea whats going on here?

We are using Office 2010.

Mike
NOTICE: This message, including any attachment, is intended as a

confidential and privileged communication. If you have received this
message in error, or are not the named recipient(s), please immediately
notify the sender and delete this message.

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

http://archive.midrange.com/rpg400-l.

NOTICE: This message, including any attachment, is intended as a

confidential and privileged communication. If you have received this
message in error, or are not the named recipient(s), please immediately
notify the sender and delete this message.

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