Bug 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 Reporter: raja <cbenagaraj86>
Component: SS CommonAssignee: POI Developers List <dev>
Status: NEW ---    
Severity: normal CC: cbenagaraj86
Priority: P3    
Version: 3.14-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: All   
Attachments: excel out put

Description raja 2017-08-09 13:18:24 UTC
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)
Comment 1 raja 2017-08-09 14:42:16 UTC
Created attachment 35209 [details]
excel out put

right side column imnage is expected
Comment 2 raja 2017-08-10 07:36:56 UTC
also setWidthMax by default 90 % in excel output
Comment 3 Dominik Stadler 2017-09-17 21:15:40 UTC
FYI, it doesn't help much setting highest priority on a bug for a visual glitch, there are likely more severe things to report...