DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://nagoya.apache.org/bugzilla/show_bug.cgi?id=22727>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=22727

Cannot copy Font color

           Summary: Cannot copy Font color
           Product: POI
           Version: 2.0-pre3
          Platform: PC
        OS/Version: Windows XP
            Status: NEW
          Severity: Normal
          Priority: Other
         Component: HSSF
        AssignedTo: [EMAIL PROTECTED]
        ReportedBy: [EMAIL PROTECTED]


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.

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to