https://bz.apache.org/bugzilla/show_bug.cgi?id=62492
Bug ID: 62492
Summary: XSSFFontFormatting.setFontColor
IndexOutOfBoundsException
Product: POI
Version: 3.17-FINAL
Hardware: PC
Status: NEW
Severity: major
Priority: P2
Component: XSSF
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
I am trying to set the font of a conditional formatting However when I run
FontFormatting font1 = rule1.createFontFormatting();
font1.setFontColor(new XSSFColor(new java.awt.Color(198, 239, 206)));
I get an IndexOutOfBoundsException Shown below.
Exception in thread "main" java.lang.IndexOutOfBoundsException
at
org.openxmlformats.schemas.spreadsheetml.x2006.main.impl.CTFontImpl.setColorArray(Unknown
Source)
at
org.apache.poi.xssf.usermodel.XSSFFontFormatting.setFontColor(XSSFFontFormatting.java:125)
The code that breaks is
@Override
public void setFontColor(Color color) {
XSSFColor xcolor = XSSFColor.toXSSFColor(color);
if (xcolor == null) {
_font.getColorList().clear();
} else {
_font.setColorArray(0, xcolor.getCTColor());
}
}
This stack overflow post is the only place I can find the issue mentioned,
however I dont beleive they ever submitted a bug report
https://stackoverflow.com/questions/45611870/can-not-set-font-color-in-conditional-formatting-cell-via-apache-poi
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
