Setting boreders types and colors around merged regions

[Avinash Kewalramani <AK...@accelrys.com>]

Hi

Is there a utility class for setting border color and styles around a merged region of cells in XSSF?
I see from the documentation that there are utility classes like HSSFRegionUtil and HSSFCellutil
for doing this on the HSSF side. Is there something parallel/similar for working with XSSF worksheets?

Thanks and Regards
A

Re: Setting boreders types and colors around merged regions

[David Fisher <df...@jmlafferty.com>]

Hi Avinash,

It looks as if this contribution could be useful for solving an RFE  
for the new OOXML branch. I am attaching it to https://issues.apache.org/bugzilla/show_bug.cgi?id=9633

Thank you very much. I hope that someone on the POI team will look at  
it soon.

If you have an update, please attach it there.

Regards,
Dave

On Jan 22, 2009, at 12:14 PM, Avinash Kewalramani wrote:

>
> Hi
>
> I did not find any utility classes for XSSF , hence I just took the  
> two classes for HSSF and migrated them so that they can be used with  
> both XSSF and HSSF using the ss usermodel.
>
> I have included the source code here if anyone wants to use it and  
> if the primary authors would like to add this
> to the next POI distribution.I do not know how can I get this into  
> the codebase but I think this might be useful to someone working  
> with merged regions in the new XML styled workbooks.
>
>
> I think these classes can replace the HSSFRegionUtil and  
> HSSFCellUtil class.
>
> Regards
> A
>
>
> -----Original Message-----
> From: Avinash Kewalramani [mailto:AKewalramani@accelrys.com]
> Sent: Thursday, January 22, 2009 10:17 AM
> To: POI Users List
> Subject: Setting boreders types and colors around merged regions
>
> Hi
>
> Is there a utility class for setting border color and styles around  
> a merged region of cells in XSSF?
> I see from the documentation that there are utility classes like  
> HSSFRegionUtil and HSSFCellutil
> for doing this on the HSSF side. Is there something parallel/similar  
> for working with XSSF worksheets?
>
> Thanks and Regards
> A
> < 
> org 
> .zip 
> >---------------------------------------------------------------------
> 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: Setting boreders types and colors around merged regions

[Avinash Kewalramani <AK...@accelrys.com>]

Hi

I did not find any utility classes for XSSF , hence I just took the two classes for HSSF and migrated them so that they can be used with both XSSF and HSSF using the ss usermodel.

I have included the source code here if anyone wants to use it and if the primary authors would like to add this 
to the next POI distribution.I do not know how can I get this into the codebase but I think this might be useful to someone working with merged regions in the new XML styled workbooks.


I think these classes can replace the HSSFRegionUtil and HSSFCellUtil class.

Regards
A


-----Original Message-----
From: Avinash Kewalramani [mailto:AKewalramani@accelrys.com] 
Sent: Thursday, January 22, 2009 10:17 AM
To: POI Users List
Subject: Setting boreders types and colors around merged regions

Hi

Is there a utility class for setting border color and styles around a merged region of cells in XSSF?
I see from the documentation that there are utility classes like HSSFRegionUtil and HSSFCellutil
for doing this on the HSSF side. Is there something parallel/similar for working with XSSF worksheets?

Thanks and Regards
A