You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2017/08/09 13:18:24 UTC
[Bug 61396] New: DataBarFormatting, setWidthMin by default 10 % in
excel output(when i getWidthMin gives 0 and i unable to setWidthMin to any
other value)
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: dev@poi.apache.org
Reporter: cbenagaraj86@gmail.com
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 61396] DataBarFormatting, setWidthMin by default 10 % in excel
output(when i getWidthMin gives 0 and i unable to setWidthMin to any other
value)
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=61396
raja <cb...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
OS| |All
--- Comment #2 from raja <cb...@gmail.com> ---
also setWidthMax by default 90 % in excel output
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 61396] DataBarFormatting, setWidthMin by default 10 % in excel
output(when i getWidthMin gives 0 and i unable to setWidthMin to any other
value)
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=61396
--- Comment #1 from raja <cb...@gmail.com> ---
Created attachment 35209
--> https://bz.apache.org/bugzilla/attachment.cgi?id=35209&action=edit
excel out put
right side column imnage is expected
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 61396] DataBarFormatting, setWidthMin by default 10 % in excel
output(when i getWidthMin gives 0 and i unable to setWidthMin to any other
value)
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=61396
raja <cb...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Severity|normal |major
OS|All |Windows 10
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 61396] DataBarFormatting, setWidthMin by default 10 % in excel
output(when i getWidthMin gives 0 and i unable to setWidthMin to any other
value)
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=61396
raja <cb...@gmail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Priority|P2 |P1
OS| |All
CC| |cbenagaraj86@gmail.com
Severity|major |blocker
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
[Bug 61396] DataBarFormatting, setWidthMin by default 10 % in excel
output(when i getWidthMin gives 0 and i unable to setWidthMin to any other
value)
Posted by bu...@apache.org.
https://bz.apache.org/bugzilla/show_bug.cgi?id=61396
Dominik Stadler <do...@gmx.at> changed:
What |Removed |Added
----------------------------------------------------------------------------
Priority|P1 |P3
Severity|blocker |normal
--- Comment #3 from Dominik Stadler <do...@gmx.at> ---
FYI, it doesn't help much setting highest priority on a bug for a visual
glitch, there are likely more severe things to report...
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org