Possible Font creation bug

[Dale Monti]

In the below code (Code begin:) no cells are italic. This is because
when createFont() is called for the second time a new XSSFFont object is
created but not added to the styles table because it thinks it's already
there. Maybe if the font is in the styles table createFont() should
return that object instead of creating a new one?

It's misleading because if the font is not in the styles table then
cellStyle.setFont doesn't do anything. I don't know if it's really a bug
since there is no point in calling createFont() the first time. But if
you create a Font and don't change any of the Font attributes then
create another Font you may run into this problem. Also, I don't think
HSSF behaves the same way.

A workaround I have found is to add the font manually to the styles table.

font2.putFont(book.getStylesSource()); //use after setting font attributes

Code begin:
    try{
            File f = new File("C:\\test\\FontBug.xlsx");
            XSSFWorkbook book = new XSSFWorkbook();
            XSSFSheet sheet = book.createSheet("sheet1");
            XSSFRow row = sheet.createRow(0);
            XSSFCellStyle cellStyle = book.createCellStyle();
            XSSFFont font = book.createFont();
            cellStyle.setFont(font);
           
          //font2
            XSSFCellStyle cellStyle2 = book.createCellStyle();
            XSSFFont font2 = book.createFont();
            font2.setItalic(true);
            cellStyle2.setFont(font2);
           
            int colNum = 3;
            for(int i = 0; i < colNum; i++){
                XSSFCell cell = row.createCell(i);
                cell.setCellType(XSSFCell.CELL_TYPE_STRING);
                if(i==1){
                    cell.setCellStyle(cellStyle2);
                }else{
                    cell.setCellStyle(cellStyle);
                }
                cell.setCellValue("test"+i);
            }

            book.write(new BufferedOutputStream(new FileOutputStream(f)));
            System.out.println("done");
        }catch (Exception e){
            e.printStackTrace();
        }

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@...
For additional commands, e-mail: user-help@...