Colored sheet tabs

[Scott Anderson <sa...@airvana.com>]

Hello,

 

Is it possible to ad color to the tabs for each sheet in HSSF? I'm
converting some old code over from XElem, and I can't seem to find any
documentation for how to do this.

 

Thanks,

Scott

RE: Colored sheet tabs

[Nick Burch <ni...@torchbox.com>]

On Tue, 17 Mar 2009, Scott Anderson wrote:
> Can anyone confirm this? It's getting close to crunch time, and my 
> decision on how to proceed will depend on whether it's possible to add 
> this feature.

I'd suggest creating two files, by following this proceedure:
1) create a simple two tab spreadsheet
2) save
3) open, save as
4) take a copy of the saved-as file, that's file 1
5) open file 1, colour a tab
6) save as, this is file 2

Then, run biffviewer against the two files, diff the output, and see what 
record(s) hold the tab colouring

Nick

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

RE: Colored sheet tabs

[Scott Anderson <sa...@airvana.com>]

Can anyone confirm this? It's getting close to crunch time, and my
decision on how to proceed will depend on whether it's possible to add
this feature.

Thanks,
Scott

-----Original Message-----
From: MSB [mailto:markbrdsly@tiscali.co.uk] 
Sent: Wednesday, March 11, 2009 3:50 AM
To: user@poi.apache.org
Subject: Re: Colored sheet tabs


Scott, I could be wrong but I do not think that it is possible to set
the
colours of the tabs. Originally, HSSF targeted a releatively early
version
of the BIFF8 file format in order to ensure compatibility; tab colouring
was
added by Microsoft later as far as I am aware. It could be worth asking
the
developers to add it as an enhancement - though it may not be possible
if I
am correct about the version constraint - or you could try to add this
feature as a patch to HSSF yourself.

Either way, I would wait for a reply from someone such as Nick, David,
Yegor, Josh, et al before accepting my reply as definitive.


Scott A wrote:
> 
> Hello,
> 
>  
> 
> Is it possible to ad color to the tabs for each sheet in HSSF? I'm
> converting some old code over from XElem, and I can't seem to find any
> documentation for how to do this.
> 
>  
> 
> Thanks,
> 
> Scott
> 
> 
> 

-- 
View this message in context:
http://www.nabble.com/Colored-sheet-tabs-tp22441380p22450164.html
Sent from the POI - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
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: Colored sheet tabs

[MSB <ma...@tiscali.co.uk>]

Scott, I could be wrong but I do not think that it is possible to set the
colours of the tabs. Originally, HSSF targeted a releatively early version
of the BIFF8 file format in order to ensure compatibility; tab colouring was
added by Microsoft later as far as I am aware. It could be worth asking the
developers to add it as an enhancement - though it may not be possible if I
am correct about the version constraint - or you could try to add this
feature as a patch to HSSF yourself.

Either way, I would wait for a reply from someone such as Nick, David,
Yegor, Josh, et al before accepting my reply as definitive.


Scott A wrote:
> 
> Hello,
> 
>  
> 
> Is it possible to ad color to the tabs for each sheet in HSSF? I'm
> converting some old code over from XElem, and I can't seem to find any
> documentation for how to do this.
> 
>  
> 
> Thanks,
> 
> Scott
> 
> 
> 

-- 
View this message in context: http://www.nabble.com/Colored-sheet-tabs-tp22441380p22450164.html
Sent from the POI - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org