Re: Scott POI HSSFCell_setCellValueStr size restriction (1024)

On 7/23/2013 2:49 PM, tim.dclinc@xxxxxxxxx wrote:

i am trying to write data to a cell, but its only taking the first 1024
characters.

p9enote is 32000 long...

Row = HSSFSheet_createRow(sh_narrative : row#);
Cell = HSSFRow_createCell(Row: 0);
jstring = new_String(%trim(p9enote));
HSSFCell_setCellValueStr(Cell: jstring);

any way to bypass this apparent limit?

Looking at new_String in QRPGLESRC2/HSSF_H I see that it has the
following definition:

D new_String PR like(jString)
D EXTPROC(*JAVA
D :'java.lang.String'
D :*CONSTRUCTOR)
D create_from 1024A VARYING const

You might try making your own string creator that looks like this:

D new_l_String PR like(jString)
D EXTPROC(*JAVA
D :'java.lang.String'
D :*CONSTRUCTOR)
D create_from 32767A VARYING const

jstring = new_l_String(%trim(p9enote));

I have not looked into the Javadoc for limits on the size of Java's
String class, but it's quite easy for you to just try the new procedure
and see how it works.

--buck