Bug 6830 - Solid fill pattern doesn't allow for colors
Summary: Solid fill pattern doesn't allow for colors
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 2.0-dev
Hardware: Other other
: P3 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2002-03-04 01:29 UTC by william.barker
Modified: 2004-11-16 19:05 UTC (History)
1 user (show)


Note You need to log in before you can comment on or make changes to this bug.
Description william.barker 2002-03-04 01:29:24 UTC
This is using the current CVS HEAD.

When I specify:
	HSSFCellStyle  col1 = wb.createCellStyle();

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.