Thank you for your response. -----Message d'origine----- De : Dave Fisher [mailto:[email protected]] Envoyé : mardi 16 juin 2009 17:50 À : POI Users List Objet : Re: Java POI HSSF issue with Excel Outline and Expand/Collapse
Hi - You submit the patch in a bug report to the Apache Bugzilla at https://issues.apache.org/bugzilla/ Start your subject with "[Patch]" - someone will look it over to see how it applies - once it is in bugzilla it won't be lost. I think that recently work was done by someone else with RecordsAggregate - but my memory is fuzzy - you can search the mail lists at nabble.com in Nabble 1 (old nabble) Regards, Dave On Jun 16, 2009, at 8:34 AM, Bittard, Julien wrote: > 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] > --------------------------------------------------------------------- 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]
