Re: issue with Excel formula -- RPG400-L

Well, I wrote my own (new) tool for generating Excel which runs a lot faster, but has only a fraction of the features of POI. I was planning to make this open source once it had improved -- but it's not ready yet.

Then, I changed jobs shortly after that, and so I no longer need to generate Excel, though that will be changing soon.

Then, in January I had a spinal cord injury that has prevented me from working on open source projects. It'll probably be another year before I'm done with the rehab from this injury :-(

But anyway... If you get the latest (which isn't really that recent) version of my HSSFR4/XLPARSER4 tools they work with POI 3.6, which should work nicely enough. There are a few things in newer versions of POI (beyond 3.6) that do not work with my tools, though most functionality does work fine.

On 7/12/2013 3:04 PM, Smith, Mike wrote:

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.