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.
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?
Guys...discover the mail list. Moreover reading the doc (quick guide) would be a good start.... Bugzilla is not the place to ask questions.