https://bz.apache.org/bugzilla/show_bug.cgi?id=61396
Bug ID: 61396
Summary: DataBarFormatting, setWidthMin by default 10 % in
excel output(when i getWidthMin gives 0 and i unable
to setWidthMin to any other value)
Product: POI
Version: 3.14-FINAL
Hardware: PC
Status: NEW
Severity: normal
Priority: P2
Component: SS Common
Assignee: [email protected]
Reporter: [email protected]
Target Milestone: ---
public void conditionalFormatting(Sheet sheet) {
SheetConditionalFormatting sheetCF =
sheet.getSheetConditionalFormatting();
ExtendedColor color =
sheet.getWorkbook().getCreationHelper().createExtendedColor();
color.setARGBHex("FF63BE7B");
CellRangeAddress[] regions = { CellRangeAddress.valueOf("B2:B7") };
ConditionalFormattingRule rule1 =
sheetCF.createConditionalFormattingRule(color);
DataBarFormatting db1 = rule1.getDataBarFormatting();
db1.getMinThreshold().setRangeType(RangeType.MIN);
db1.getMaxThreshold().setRangeType(RangeType.MAX);
sheetCF.addConditionalFormatting(regions, rule1);
}
also can't make it, Bar Colors:fill:color(gradient only working)
--
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]
