Bug 6830

Summary: Solid fill pattern doesn't allow for colors
Product: POI Reporter: william.barker
Component: HSSFAssignee: POI Developers List <dev>
Status: CLOSED INVALID    
Severity: normal CC: poi-dev
Priority: P3    
Version: 2.0-dev   
Target Milestone: ---   
Hardware: Other   
OS: other   

Description william.barker 2002-03-04 01:29:24 UTC
This is using the current CVS HEAD.

When I specify:
	HSSFCellStyle  col1 = wb.createCellStyle();
	col1.setFillPattern(HSSFCellStyle.SOLID_FILL);
	col1.setFillBackgroundColor(HSSFCellStyle.PALE_BLUE);

All of the cells show up with a black background in Excel (2000).  I get the 
same results using other colors, and all of the other FillPattern constants 
work fine.
Comment 1 Andy Oliver 2002-03-04 01:51:36 UTC
Think about it.  You're filling it solid...  with the FOREGROUND color.  So set
the foreground color to blue instead of the background color.  I made the same
mistake initially and thought it was just Excel being weird...now I get it.
Comment 2 william.barker 2002-03-04 02:05:33 UTC
Works.  Thanks much, and keep up the good work!
Comment 3 Andy Oliver 2002-03-04 03:00:44 UTC
this should probably be in a faq...it triped me up too.