You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2009/01/08 14:19:12 UTC
DO NOT REPLY [Bug 46493] New: BackGround color not working
https://issues.apache.org/bugzilla/show_bug.cgi?id=46493
Summary: BackGround color not working
Product: POI
Version: 3.2-FINAL
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: major
Priority: P1
Component: HSSF
AssignedTo: dev@poi.apache.org
ReportedBy: bcaramu@gmail.com
HSSFCellStyle.setFillBackgroundColor not working
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 46493] BackGround color not working
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46493
Yegor Kozlov <ye...@dinom.ru> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |NEEDINFO
--- Comment #1 from Yegor Kozlov <ye...@dinom.ru> 2009-01-08 07:10:04 PST ---
post sample code to reproduce the problem.
Also, see the Quick Guide:
http://poi.apache.org/spreadsheet/quick-guide.html#FillsAndFrills
Yegor
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 46493] BackGround color not working
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46493
Yegor Kozlov <ye...@dinom.ru> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|ASSIGNED |RESOLVED
Resolution| |WONTFIX
--- Comment #3 from Yegor Kozlov <ye...@dinom.ru> 2009-01-29 08:19:18 PST ---
You need to set the type of fill pattern. The following snippet of code works
fine to me:
CellStyle style = wb.createCellStyle();
style.setFillForegroundColor( IndexedColors.LIGHT_BLUE.getIndex() );
style.setFillPattern(CellStyle.SOLID_FOREGROUND);
style.setFont( font );
Cell cell = row.createCell( 0 );
cell.setCellStyle( style );
cell.setCellValue( "foo" );
See the quick guide: http://poi.apache.org/spreadsheet/quick-guide.html
Yegor
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 46493] BackGround color not working
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46493
Graham Smith <gr...@crazysquirrel.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |graham@crazysquirrel.com
Status|NEEDINFO |ASSIGNED
--- Comment #2 from Graham Smith <gr...@crazysquirrel.com> 2009-01-21 11:15:05 PST ---
I don't know about version 3.2 but in 3.5 beta 4 the following code (with
suitable code around it to create a workbook and save it etc) doesn't create a
cell with a light blue background - the background is white. This functionality
worked in 3.5 beta 3 (but setting the font as bold didn't work).
Font font = wb.createFont();
font.setBoldweight( Font.BOLDWEIGHT_BOLD );
CellStyle style = wb.createCellStyle();
style.setFillBackgroundColor( IndexedColors.LIGHT_BLUE.getIndex() );
style.setFont( font );
Cell cell = row.createCell( 0 );
cell.setCellStyle( style );
cell.setCellValue( "foo" );
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 46493] BackGround color not working
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=46493
Rama Krishna G <bc...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |bcaramu@gmail.com
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org