Have you looked at the latest trunk?
Did you submit your patch with a unit test to bugzilla? If not please
do so, we'll gladly consider it.
Regards,
Dave
On Apr 30, 2009, at 6:07 AM, Bittard, Julien wrote:
The class RowRecordsAggregate is the class called by
org.apache.poi.hssf.usermodel.HSSFSheet in POI 3.2.
So I modify POI source and rebuild POI.
This correction was never included in the deliveries of POIs.
-----Message d'origine-----
De : David Lucas [mailto:[email protected]]
Envoyé : jeudi 30 avril 2009 14:48
À : POI Users List
Objet : Re: Java POI HSSF issue with Excel Outline and Expand/Collapse
Thanks for the reply. I am using POI 3.5 Beta so maybe this is a
known issue with 3.2 and 3.5? I haven't been able to find anyone
else having this problem but the code sample I posted below is
pretty generic and it reproduces this issue. To use
RowRecordsAggregate and its collapseRow method, would I have to
implement this differently? Right now I'm just using the
org.apache.poi.ss.usermodel.Row and Cell objects and using the Sheet
methods to group and collapse the Outline. Also, the generated
Excel file is being opened in MS Office Excel since that's what the
end user will be using to open the file. Thanks again for your help.
On Thu, Apr 30, 2009 at 2:45 AM, Bittard, Julien
<[email protected]>wrote:
Hello,
This is with POI 3.2 ?
I have the same issue.
In the class RowRecordsAggregate, method collapseRow, if you add this
line
:
'rowRecord.setColapsed(true);' , it works better.
Do you open the document with MS Office Excel or Open Office ?
-----Message d'origine-----
De : David Lucas [mailto:[email protected]] Envoyé : jeudi 30
avril
2009 04:34 À : [email protected] Objet : Java POI HSSF issue with
Excel Outline and Expand/Collapse
Hi All,
I'm running into an issue with Excel Outlining using POI HSSF. I
create three groups with "Test1" being the root node. I collapse each
group as well using setRowGroupCollapsed. However, when I expand the
first node on the Excel File generated, all the other nodes are also
expanded. Is there a setting to prevent this? I would like to have
all
levels collapsed and if I expand the first level, the lower levels
should remain collapsed until I expand them. Below is my test code
and any help is greatly appreciated.
Thanks in advance
sheet.setAlternativeExpression(false);
sheet.setRowSumsBelow(false);
Row excelRow = null;
Cell excelCell = null;
excelRow = sheet.createRow( 0 );
excelCell = excelRow.createCell( 0 );
excelCell.setCellValue( "Test 1" );
excelRow = sheet.createRow( 1 );
excelCell = excelRow.createCell( 1 );
excelCell.setCellValue( "Test 2" );
excelRow = sheet.createRow( 2 );
excelCell = excelRow.createCell( 2 );
excelCell.setCellValue( "Test 3" );
excelRow = sheet.createRow( 3 );
excelCell = excelRow.createCell( 3 );
excelCell.setCellValue( "Test 4" );
sheet.groupRow( 1, 3 );
sheet.groupRow( 2, 3 );
sheet.groupRow( 3, 3 );
sheet.setRowGroupCollapsed( 1, true ); sheet.setRowGroupCollapsed( 2,
true ); sheet.setRowGroupCollapsed( 3, true );
Please help Logica to respect the environment by not printing this
email / Pour contribuer comme Logica au respect de l'environnement,
merci de ne pas imprimer ce mail / Bitte drucken Sie diese Nachricht
nicht aus und helfen Sie so Logica dabei die Umwelt zu schuetzen /
Por favor ajude a Logica a respeitar o ambiente nao imprimindo este
correio electronico.
This e-mail and any attachment is for authorised use by the intended
recipient(s) only. It may contain proprietary material, confidential
information and/or be subject to legal privilege. It should not be
copied, disclosed to, retained or used by, any other party. If you
are
not an intended recipient then please promptly delete this e-mail and
any attachment and all copies and inform the sender. Thank you.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected] For
additional
commands, e-mail: [email protected]
Please help Logica to respect the environment by not printing this
email / Pour contribuer comme Logica au respect de l'environnement,
merci de ne pas imprimer ce mail / Bitte drucken Sie diese
Nachricht nicht aus und helfen Sie so Logica dabei die Umwelt zu
schuetzen / Por favor ajude a Logica a respeitar o ambiente nao
imprimindo este correio electronico.
This e-mail and any attachment is for authorised use by the intended
recipient(s) only. It may contain proprietary material, confidential
information and/or be subject to legal privilege. It should not be
copied, disclosed to, retained or used by, any other party. If you
are not an intended recipient then please promptly delete this e-
mail and any attachment and all copies and inform the sender. Thank
you.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
