Bug 22727 - Cannot copy Font color
Summary: Cannot copy Font color
Status: RESOLVED INVALID
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 2.0-pre3
Hardware: PC Windows XP
: P3 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-08-26 12:21 UTC by Andreas Liebscher
Modified: 2005-07-28 00:43 UTC (History)
0 users



Attachments

Note You need to log in before you can comment on or make changes to this bug.
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.