You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by David Lucas <lu...@gmail.com> on 2009/04/30 04:34:27 UTC
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 );
RE: Java POI HSSF issue with Excel Outline and Expand/Collapse
Posted by "Bittard, Julien" <ju...@logica.com>.
Thank you for your response.
-----Message d'origine-----
De : Dave Fisher [mailto:dave@jmlafferty.com]
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:dfisher@jmlafferty.com] 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:lucasd2130@gmail.com] 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
>> <ju...@logica.com>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:lucasd2130@gmail.com] Envoyé : jeudi 30
>>> avril
>>> 2009 04:34 À : user@poi.apache.org 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: user-unsubscribe@poi.apache.org For
>>> additional commands, e-mail: user-help@poi.apache.org
>>>
>>>
>>
>> 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: user-unsubscribe@poi.apache.org For
>> additional commands, e-mail: user-help@poi.apache.org
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org For additional
> commands, e-mail: user-help@poi.apache.org
>
>
>
> 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: user-unsubscribe@poi.apache.org For additional
> commands, e-mail: user-help@poi.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org For additional commands, e-mail: user-help@poi.apache.org
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Java POI HSSF issue with Excel Outline and Expand/Collapse
Posted by Dave Fisher <da...@jmlafferty.com>.
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:dfisher@jmlafferty.com]
> 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:lucasd2130@gmail.com] 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
>> <ju...@logica.com>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:lucasd2130@gmail.com] Envoyé : jeudi 30
>>> avril
>>> 2009 04:34 À : user@poi.apache.org 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: user-unsubscribe@poi.apache.org For
>>> additional commands, e-mail: user-help@poi.apache.org
>>>
>>>
>>
>> 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: user-unsubscribe@poi.apache.org For
>> additional
>> commands, e-mail: user-help@poi.apache.org
>>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org For
> additional commands, e-mail: user-help@poi.apache.org
>
>
>
> 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: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
RE: Java POI HSSF issue with Excel Outline and Expand/Collapse
Posted by "Bittard, Julien" <ju...@logica.com>.
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:dfisher@jmlafferty.com]
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:lucasd2130@gmail.com] 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
> <ju...@logica.com>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:lucasd2130@gmail.com] Envoyé : jeudi 30
>> avril
>> 2009 04:34 À : user@poi.apache.org 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: user-unsubscribe@poi.apache.org For
>> additional commands, e-mail: user-help@poi.apache.org
>>
>>
>
> 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: user-unsubscribe@poi.apache.org For additional
> commands, e-mail: user-help@poi.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org For additional commands, e-mail: user-help@poi.apache.org
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Java POI HSSF issue with Excel Outline and Expand/Collapse
Posted by David Fisher <df...@jmlafferty.com>.
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:lucasd2130@gmail.com]
> 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
> <ju...@logica.com>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:lucasd2130@gmail.com] Envoyé : jeudi 30
>> avril
>> 2009 04:34 À : user@poi.apache.org 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: user-unsubscribe@poi.apache.org For
>> additional
>> commands, e-mail: user-help@poi.apache.org
>>
>>
>
> 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: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
RE: Java POI HSSF issue with Excel Outline and Expand/Collapse
Posted by "Bittard, Julien" <ju...@logica.com>.
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:lucasd2130@gmail.com]
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
<ju...@logica.com>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:lucasd2130@gmail.com] Envoyé : jeudi 30 avril
> 2009 04:34 À : user@poi.apache.org 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: user-unsubscribe@poi.apache.org For additional
> commands, e-mail: user-help@poi.apache.org
>
>
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
Re: Java POI HSSF issue with Excel Outline and Expand/Collapse
Posted by David Lucas <lu...@gmail.com>.
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
<ju...@logica.com>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:lucasd2130@gmail.com]
> Envoyé : jeudi 30 avril 2009 04:34
> À : user@poi.apache.org
> 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: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>
RE: Java POI HSSF issue with Excel Outline and Expand/Collapse
Posted by "Bittard, Julien" <ju...@logica.com>.
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:lucasd2130@gmail.com]
Envoyé : jeudi 30 avril 2009 04:34
À : user@poi.apache.org
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org