Re: issue with Excel formula

Scott. I'm curious as to what's possible. Did you do this with RPG, or
some other language?




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:11 PM
Subject: Re: issue with Excel formula
Sent by: rpg400-l-bounces@xxxxxxxxxxxx



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.

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