Custom background color in conditional formatting using Apache POI

Question

I have a XSSF workbook and I want to define a custom background color in a set of cells with a conditional formatting defined, but the problem is that the setFillBackgroundColor() method in the PatternFormatting class only accepts a type short argument, not a XSSFColor like this:

PatternFormatting fill = rule1.createPatternFormatting();
fill.setFillBackgroundColor(new XSSFColor(new java.awt.Color(80, 80, 100));
fill.setFillPattern(PatternFormatting.SOLID_FOREGROUND);

I can do fill.setFillBackgroundColor(IndexedColors.RED.index), but I want to define a custom color. How can i do this?.

that fill.setFillBackgroundColor(new XSSFColor(new java.awt.Color(80, 80, 100)); is custom R=80 G=80 B=100 right? what is the problem by using that? — Angga
@Angga The problem is the setFillBackgroundColor() method in the PatternFormatting class only accepts a type short argument, not a XSSFColor. — edkalel

stijnh stijnh · Accepted Answer · 2017-07-05T16:20:38

For anyone still reading this and having the problem the requester describes back in 2014, you are probably on a version of Apache POI before 3.13. Try upgrading to at least 3.13 where you should indeed be able to do:

fill.setFillBackgroundColor(new XSSFColor(new java.awt.Color(80, 80, 100))

(see also here: https://bz.apache.org/bugzilla/show_bug.cgi?id=56774)

Custom background color in conditional formatting using Apache POI

1 Answers