Hello, I don't know how to submit my patch. I look at the lastest trunk but there is not. Thank you.
-----Message d'origine----- De : David Fisher [mailto:[email protected]] Envoyé : jeudi 30 avril 2009 17:18 À : POI Users List Objet : Re: Java POI HSSF issue with Excel Outline and Expand/Collapse 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] 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]
