Re: HSSFR4 ss_cellName() function.

On Tue, Oct 9, 2018 at 6:50 PM <JRusling@xxxxxxxxxxx> wrote:

afaik the ss_ prefixed procedures are supposed to work with xlsx (which is
what i am building, not xls) and the hssf_ are for .xls.
(am i mistaken?)

I don't use any of the POI stuff, so I don't know. But if you can
build small .xlsx files, and they open up with WinZip or other
zip-reading software, then it's overwhelmingly likely that you're
producing genuine .xlsx files (and not merely files which adhere to
.xls format, that simply got named deceptively).

Incidentally, I was wrong about the .xls limitation - it's really 64k
rows, not 32k. The 32k limitation indeed comes from RPG's 5-digit
*signed* integer (with a range -32k to 32k; unsigned would be 0 to
64k).

I don't know how the interface to Java works. I don't know if you can
just change the declarations on the RPG end without screwing up the
parameter passing.

John Y.