https://issues.apache.org/bugzilla/show_bug.cgi?id=53564
Priority: P2
Bug ID: 53564
Assignee: [email protected]
Summary: Cannot draw a diagonal border
Severity: normal
Classification: Unclassified
Reporter: [email protected]
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: [email protected]
For additional commands, e-mail: [email protected]
