Re: issue with Excel formula

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.