poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 53564] New: Cannot draw a diagonal border
Date Wed, 18 Jul 2012 11:23:20 GMT
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


Mime
View raw message