You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@poi.apache.org by ce...@apache.org on 2017/12/28 10:32:04 UTC
svn commit: r1819416 - /poi/site/publish/spreadsheet/quick-guide.html
Author: centic
Date: Thu Dec 28 10:32:03 2017
New Revision: 1819416
URL: http://svn.apache.org/viewvc?rev=1819416&view=rev
Log:
Regenerate quick-guide
Modified:
poi/site/publish/spreadsheet/quick-guide.html
Modified: poi/site/publish/spreadsheet/quick-guide.html
URL: http://svn.apache.org/viewvc/poi/site/publish/spreadsheet/quick-guide.html?rev=1819416&r1=1819415&r2=1819416&view=diff
==============================================================================
--- poi/site/publish/spreadsheet/quick-guide.html (original)
+++ poi/site/publish/spreadsheet/quick-guide.html Thu Dec 28 10:32:03 2017
@@ -677,13 +677,13 @@ if (VERSION > 3) {
// Style the cell with borders all around.
CellStyle style = wb.createCellStyle();
- style.setBorderBottom(CellStyle.BORDER_THIN);
+ style.setBorderBottom(BorderStyle.THIN);
style.setBottomBorderColor(IndexedColors.BLACK.getIndex());
- style.setBorderLeft(CellStyle.BORDER_THIN);
+ style.setBorderLeft(BorderStyle.THIN);
style.setLeftBorderColor(IndexedColors.GREEN.getIndex());
- style.setBorderRight(CellStyle.BORDER_THIN);
+ style.setBorderRight(BorderStyle.THIN);
style.setRightBorderColor(IndexedColors.BLUE.getIndex());
- style.setBorderTop(CellStyle.BORDER_MEDIUM_DASHED);
+ style.setBorderTop(BorderStyle.MEDIUM_DASHED);
style.setTopBorderColor(IndexedColors.BLACK.getIndex());
cell.setCellStyle(style);
@@ -1287,7 +1287,7 @@ Examples:
sheet1.addMergedRegion( region );
// Set the border and border colors.
- final short borderMediumDashed = CellStyle.BORDER_MEDIUM_DASHED;
+ final short borderMediumDashed = BorderStyle.MEDIUM_DASHED;
RegionUtil.setBorderBottom( borderMediumDashed,
region, sheet1, wb );
RegionUtil.setBorderTop( borderMediumDashed,
@@ -3006,10 +3006,10 @@ the data to populate another drop down l
fontFmt.setFontColorIndex(IndexedColors.DARK_RED.index);
BorderFormatting bordFmt = rule1.createBorderFormatting();
- bordFmt.setBorderBottom(BorderFormatting.BORDER_THIN);
- bordFmt.setBorderTop(BorderFormatting.BORDER_THICK);
- bordFmt.setBorderLeft(BorderFormatting.BORDER_DASHED);
- bordFmt.setBorderRight(BorderFormatting.BORDER_DOTTED);
+ bordFmt.setBorderBottom(BorderStyle.THIN);
+ bordFmt.setBorderTop(BorderStyle.THICK);
+ bordFmt.setBorderLeft(BorderStyle.DASHED);
+ bordFmt.setBorderRight(BorderStyle.DOTTED);
PatternFormatting patternFmt = rule1.createPatternFormatting();
patternFmt.setFillBackgroundColor(IndexedColors.YELLOW.index);
@@ -3118,10 +3118,10 @@ the data to populate another drop down l
Map<String, Object> properties = new HashMap<String, Object>();
// border around a cell
- properties.put(CellUtil.BORDER_TOP, CellStyle.BORDER_MEDIUM);
- properties.put(CellUtil.BORDER_BOTTOM, CellStyle.BORDER_MEDIUM);
- properties.put(CellUtil.BORDER_LEFT, CellStyle.BORDER_MEDIUM);
- properties.put(CellUtil.BORDER_RIGHT, CellStyle.BORDER_MEDIUM);
+ properties.put(CellUtil.BORDER_TOP, BorderStyle.MEDIUM);
+ properties.put(CellUtil.BORDER_BOTTOM, BorderStyle.MEDIUM);
+ properties.put(CellUtil.BORDER_LEFT, BorderStyle.MEDIUM);
+ properties.put(CellUtil.BORDER_RIGHT, BorderStyle.MEDIUM);
// Give it a color (RED)
properties.put(CellUtil.TOP_BORDER_COLOR, IndexedColors.RED.getIndex());
---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org