Bug 61396 - DataBarFormatting, setWidthMin by default 10 % in excel output(when i getWidthMin gives 0 and i unable to setWidthMin to any other value)
Summary: DataBarFormatting, setWidthMin by default 10 % in excel output(when i getWidt...
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: SS Common (show other bugs)
Version: 3.14-FINAL
Hardware: PC All
: P3 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2017-08-09 13:18 UTC by raja
Modified: 2017-09-17 21:15 UTC (History)
1 user (show)



Attachments
excel out put (26.31 KB, image/png)
2017-08-09 14:42 UTC, raja
Details

Note You need to log in before you can comment on or make changes to this bug.
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...