I'm using poi 3.14 and all I want is to set the background of the cell to be orange. I don't want a pattern filled, just a solid orange, and yet I cannot get it to work. Here's what I have:
Row row = sheet.createRow(currentRow);
CellStyle style = workbook.createCellStyle();
style.setFillForegroundColor(IndexedColors.AUTOMATIC.getIndex());
style.setFillBackgroundColor(IndexedColors.ORANGE.getIndex());
style.setFillPattern(CellStyle.ALIGN_FILL);
Cell cell = row.createCell(0);
cell.setCellValue("ABCDEFG");
cell.setCellStyle(style);
What I end up with is an orange background with small dots pattern. On Excel's property sheet, it says I have bg=orange, fg=automatic, pattern=25% Gray. How can I use simply a blank pattern style?