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)
Created attachment 35209 [details] excel out put right side column imnage is expected
also setWidthMax by default 90 % in excel output
FYI, it doesn't help much setting highest priority on a bug for a visual glitch, there are likely more severe things to report...