Ok, I think I need a little more help on this.
I used qshell Find
find / -name 'poi*'
Found a few poi jar files.
In /QIBM/PRODDATA
/QIBM/USERData
/excel
I renamed them by placing an XX at the beginning of the file names.
I reran one of my programs to create a spreadsheet, expecting it to fail but it created the spreadsheet.
I also checked WRKENVVAR looking to see if we had set up a classpath, but did not see any listed.
So if I've renamed these why do my programs still create the spreadsheets?
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Smith, Mike
Sent: Friday, July 12, 2013 4:04 PM
To: 'RPG programming on the IBM i (AS/400 and iSeries)'
Subject: RE: issue with Excel formula
Thanks Scott,
I will see about moving them.
Did you quit using POI because your using another approach or because you changed jobs and no longer need it?
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of Scott Klement
Sent: Friday, July 12, 2013 4:01 PM
To: RPG programming on the IBM i (AS/400 and iSeries)
Subject: 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.
--
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.
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.
midrange.com
