Re: Bug in POI HSSF 3.14 possibly breaks groupColumn

Best to report on the Apache POI site. When reporting, create an example with plain Java.

Mark Murphy
STAR BASE Consulting, Inc.
mmurphy@xxxxxxxxxxxxxxx


-----Darren Strong <darren@xxxxxxxxx> wrote: -----
To: java400-l@xxxxxxxxxxxx
From: Darren Strong <darren@xxxxxxxxx>
Date: 03/30/2016 09:54AM
Subject: Bug in POI HSSF 3.14 possibly breaks groupColumn


We were running POI HSSF v3.10.1. I replaced this with 3.14. I have one
program using the groupColumn function to make collapsable columns on Excel
sheets. It started failing to create the group correctly, just selecting
the first few columns, instead of the whole range. I found a workaround to
a bug reported at 3.8 (I think it was) that said you have to set your
column widths after creating the group. That appears to be a valid
workaround again. Here are a couple code snippets of me doing it.

I could report this on the Jakarta POI site, but I'm using RPG to implement
this stuff, so I suspect my report would get discounted because its not
straight Java.

D SS_groupColumn...

D PR

D EXTPROC(*JAVA: SHEET_CLASS

D :'groupColumn')

D fromColumn like(jint) value

D toColumn like(jint) value




SS_groupColumn(Sheet:fromColumn:CurCol);

SS_setColumnGroupCollapsed(Sheet:FromColumn:*on);

// Bug in POI 3.14, maybe, column widths must be set after the
groupColumn statement
for idx1=FromColumn to CurCol;

SSSheet_setColumnWidth(Sheet:idx1: 16 * 256);

endfor;

___________________________________
Darren Strong
Programmer/Analyst
Group Dekko, Inc.