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 2012/07/18 13:23:20 UTC
[Bug 53564] New: Cannot draw a diagonal border
https://issues.apache.org/bugzilla/show_bug.cgi?id=53564
Priority: P2
Bug ID: 53564
Assignee: dev@poi.apache.org
Summary: Cannot draw a diagonal border
Severity: normal
Classification: Unclassified
Reporter: a523z@yandex.ru
Hardware: PC
Status: NEW
Version: 3.8
Component: HSSF
Product: POI
Hi evetyone,
I'm working with the 3.8 version of POI
and have problem when I try to set the Diagonal border of a cell
it doesn't appear
Below is the sample code:
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheetConditionalFormatting scf = wb.createSheet("Page
1").getSheetConditionalFormatting();
HSSFConditionalFormattingRule rule =
scf.createConditionalFormattingRule(ComparisonOperator.GT, "10");
HSSFFontFormatting font = rule.createFontFormatting();
font.setStrikeout(true);
HSSFBorderFormatting bord = rule.createBorderFormatting();
bord.setBorderDiagonal(BorderFormatting.BORDER_THICK);
bord.setBorderBottom(BorderFormatting.BORDER_THICK);
bord.setBottomBorderColor((short)30);
bord.setDiagonalBorderColor((short)30);
CellRangeAddress[] cra = {new CellRangeAddress(1, 3, 0, 3)};
scf.addConditionalFormatting(cra, rule);
Thanks for your help.
--
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