Bug 22727

Summary: Cannot copy Font color
Product: POI Reporter: Andreas Liebscher <Andreas.Liebscher>
Component: HSSFAssignee: POI Developers List <dev>
Status: RESOLVED INVALID    
Severity: normal    
Priority: P3    
Version: 2.0-pre3   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   

Description Andreas Liebscher 2003-08-26 12:21:43 UTC 
I load an excel template to insert some values. In the template the first 
columns of some rows define some colors I need to use during inserting new 
rows. So I retrieve these values by fontX = workbook.getFont(sheet.getRow
(x).getCell(0).getCellStyle.getFontIndex()).
During appending new lines I try to determine the wanted color by calling 
cell.getCellStyle.setFont(fontX).
After writing the changed excel and opening it, the colors of the cells seem to 
be determined randomly and even the colors are different in cells of the same 
row, though I used the same font object for all cells in a row.
Comment 1 blue 2005-07-28 08:38:05 UTC 
I wonder how to get font from cellStyle.
the method HSSFCellStyle.getFontIndex() return a short value,
but how can i get the HSSFFont by it?
Comment 2 Andy Oliver 2005-07-28 08:43:08 UTC 
Guys...discover the mail list.  Moreover reading the doc (quick guide) would be
a good start....  Bugzilla is not the place to ask questions.