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 Common	Assignee:	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...