poi-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From one...@apache.org
Subject svn commit: r1748105 - /poi/trunk/src/java/org/apache/poi/ss/util/RegionUtil.java
Date Mon, 13 Jun 2016 07:27:18 GMT
Author: onealj
Date: Mon Jun 13 07:27:18 2016
New Revision: 1748105

URL: http://svn.apache.org/viewvc?rev=1748105&view=rev
Log:
whitespace (tabs to spaces)

Modified:
    poi/trunk/src/java/org/apache/poi/ss/util/RegionUtil.java

Modified: poi/trunk/src/java/org/apache/poi/ss/util/RegionUtil.java
URL: http://svn.apache.org/viewvc/poi/trunk/src/java/org/apache/poi/ss/util/RegionUtil.java?rev=1748105&r1=1748104&r2=1748105&view=diff
==============================================================================
--- poi/trunk/src/java/org/apache/poi/ss/util/RegionUtil.java (original)
+++ poi/trunk/src/java/org/apache/poi/ss/util/RegionUtil.java Mon Jun 13 07:27:18 2016
@@ -30,189 +30,189 @@ import org.apache.poi.ss.usermodel.Workb
  */
 public final class RegionUtil {
 
-	private RegionUtil() {
-		// no instances of this class
-	}
-
-	/**
-	 * For setting the same property on many cells to the same value
-	 */
-	private static final class CellPropertySetter {
-
-		private final String _propertyName;
-		private final Short _propertyValue;
-
-
-		public CellPropertySetter(String propertyName, int value) {
-			_propertyName = propertyName;
-			_propertyValue = Short.valueOf((short) value);
-		}
-
-
-		public void setProperty(Row row, int column) {
-			Cell cell = CellUtil.getCell(row, column);
-			CellUtil.setCellStyleProperty(cell, _propertyName, _propertyValue);
-		}
-	}
-
-	/**
-	 * Sets the left border for a region of cells by manipulating the cell style of the individual
-	 * cells on the left
-	 *
-	 * @param border The new border
-	 * @param region The region that should have the border
-	 * @param workbook The workbook that the region is on.
-	 * @param sheet The sheet that the region is on.
-	 */
-	public static void setBorderLeft(int border, CellRangeAddress region, Sheet sheet,
-			Workbook workbook) {
-		int rowStart = region.getFirstRow();
-		int rowEnd = region.getLastRow();
-		int column = region.getFirstColumn();
-
-		CellPropertySetter cps = new CellPropertySetter(CellUtil.BORDER_LEFT, border);
-		for (int i = rowStart; i <= rowEnd; i++) {
-			cps.setProperty(CellUtil.getRow(i, sheet), column);
-		}
-	}
-
-	/**
-	 * Sets the leftBorderColor attribute of the RegionUtil object
-	 *
-	 * @param color The color of the border
-	 * @param region The region that should have the border
-	 * @param workbook The workbook that the region is on.
-	 * @param sheet The sheet that the region is on.
-	 */
-	public static void setLeftBorderColor(int color, CellRangeAddress region, Sheet sheet,
-			Workbook workbook) {
-		int rowStart = region.getFirstRow();
-		int rowEnd = region.getLastRow();
-		int column = region.getFirstColumn();
-
-		CellPropertySetter cps = new CellPropertySetter(CellUtil.LEFT_BORDER_COLOR, color);
-		for (int i = rowStart; i <= rowEnd; i++) {
-			cps.setProperty(CellUtil.getRow(i, sheet), column);
-		}
-	}
-
-	/**
-	 * Sets the borderRight attribute of the RegionUtil object
-	 *
-	 * @param border The new border
-	 * @param region The region that should have the border
-	 * @param workbook The workbook that the region is on.
-	 * @param sheet The sheet that the region is on.
-	 */
-	public static void setBorderRight(int border, CellRangeAddress region, Sheet sheet,
-			Workbook workbook) {
-		int rowStart = region.getFirstRow();
-		int rowEnd = region.getLastRow();
-		int column = region.getLastColumn();
-
-		CellPropertySetter cps = new CellPropertySetter(CellUtil.BORDER_RIGHT, border);
-		for (int i = rowStart; i <= rowEnd; i++) {
-			cps.setProperty(CellUtil.getRow(i, sheet), column);
-		}
-	}
-
-	/**
-	 * Sets the rightBorderColor attribute of the RegionUtil object
-	 *
-	 * @param color The color of the border
-	 * @param region The region that should have the border
-	 * @param workbook The workbook that the region is on.
-	 * @param sheet The sheet that the region is on.
-	 */
-	public static void setRightBorderColor(int color, CellRangeAddress region, Sheet sheet,
-			Workbook workbook) {
-		int rowStart = region.getFirstRow();
-		int rowEnd = region.getLastRow();
-		int column = region.getLastColumn();
-
-		CellPropertySetter cps = new CellPropertySetter(CellUtil.RIGHT_BORDER_COLOR, color);
-		for (int i = rowStart; i <= rowEnd; i++) {
-			cps.setProperty(CellUtil.getRow(i, sheet), column);
-		}
-	}
-
-	/**
-	 * Sets the borderBottom attribute of the RegionUtil object
-	 *
-	 * @param border The new border
-	 * @param region The region that should have the border
-	 * @param workbook The workbook that the region is on.
-	 * @param sheet The sheet that the region is on.
-	 */
-	public static void setBorderBottom(int border, CellRangeAddress region, Sheet sheet,
-			Workbook workbook) {
-		int colStart = region.getFirstColumn();
-		int colEnd = region.getLastColumn();
-		int rowIndex = region.getLastRow();
-		CellPropertySetter cps = new CellPropertySetter(CellUtil.BORDER_BOTTOM, border);
-		Row row = CellUtil.getRow(rowIndex, sheet);
-		for (int i = colStart; i <= colEnd; i++) {
-			cps.setProperty(row, i);
-		}
-	}
-
-	/**
-	 * Sets the bottomBorderColor attribute of the RegionUtil object
-	 *
-	 * @param color The color of the border
-	 * @param region The region that should have the border
-	 * @param workbook The workbook that the region is on.
-	 * @param sheet The sheet that the region is on.
-	 */
-	public static void setBottomBorderColor(int color, CellRangeAddress region, Sheet sheet,
-			Workbook workbook) {
-		int colStart = region.getFirstColumn();
-		int colEnd = region.getLastColumn();
-		int rowIndex = region.getLastRow();
-		CellPropertySetter cps = new CellPropertySetter(CellUtil.BOTTOM_BORDER_COLOR, color);
-		Row row = CellUtil.getRow(rowIndex, sheet);
-		for (int i = colStart; i <= colEnd; i++) {
-			cps.setProperty(row, i);
-		}
-	}
-
-	/**
-	 * Sets the borderBottom attribute of the RegionUtil object
-	 *
-	 * @param border The new border
-	 * @param region The region that should have the border
-	 * @param workbook The workbook that the region is on.
-	 * @param sheet The sheet that the region is on.
-	 */
-	public static void setBorderTop(int border, CellRangeAddress region, Sheet sheet,
-			Workbook workbook) {
-		int colStart = region.getFirstColumn();
-		int colEnd = region.getLastColumn();
-		int rowIndex = region.getFirstRow();
-		CellPropertySetter cps = new CellPropertySetter(CellUtil.BORDER_TOP, border);
-		Row row = CellUtil.getRow(rowIndex, sheet);
-		for (int i = colStart; i <= colEnd; i++) {
-			cps.setProperty(row, i);
-		}
-	}
-
-	/**
-	 * Sets the topBorderColor attribute of the RegionUtil object
-	 *
-	 * @param color The color of the border
-	 * @param region The region that should have the border
-	 * @param workbook The workbook that the region is on.
-	 * @param sheet The sheet that the region is on.
-	 */
-	public static void setTopBorderColor(int color, CellRangeAddress region, Sheet sheet,
-			Workbook workbook) {
-		int colStart = region.getFirstColumn();
-		int colEnd = region.getLastColumn();
-		int rowIndex = region.getFirstRow();
-		CellPropertySetter cps = new CellPropertySetter(CellUtil.TOP_BORDER_COLOR, color);
-		Row row = CellUtil.getRow(rowIndex, sheet);
-		for (int i = colStart; i <= colEnd; i++) {
-			cps.setProperty(row, i);
-		}
-	}
+    private RegionUtil() {
+        // no instances of this class
+    }
+
+    /**
+     * For setting the same property on many cells to the same value
+     */
+    private static final class CellPropertySetter {
+
+        private final String _propertyName;
+        private final Short _propertyValue;
+
+
+        public CellPropertySetter(String propertyName, int value) {
+            _propertyName = propertyName;
+            _propertyValue = Short.valueOf((short) value);
+        }
+
+
+        public void setProperty(Row row, int column) {
+            Cell cell = CellUtil.getCell(row, column);
+            CellUtil.setCellStyleProperty(cell, _propertyName, _propertyValue);
+        }
+    }
+
+    /**
+     * Sets the left border for a region of cells by manipulating the cell style of the individual
+     * cells on the left
+     *
+     * @param border The new border
+     * @param region The region that should have the border
+     * @param workbook The workbook that the region is on.
+     * @param sheet The sheet that the region is on.
+     */
+    public static void setBorderLeft(int border, CellRangeAddress region, Sheet sheet,
+            Workbook workbook) {
+        int rowStart = region.getFirstRow();
+        int rowEnd = region.getLastRow();
+        int column = region.getFirstColumn();
+
+        CellPropertySetter cps = new CellPropertySetter(CellUtil.BORDER_LEFT, border);
+        for (int i = rowStart; i <= rowEnd; i++) {
+            cps.setProperty(CellUtil.getRow(i, sheet), column);
+        }
+    }
+
+    /**
+     * Sets the leftBorderColor attribute of the RegionUtil object
+     *
+     * @param color The color of the border
+     * @param region The region that should have the border
+     * @param workbook The workbook that the region is on.
+     * @param sheet The sheet that the region is on.
+     */
+    public static void setLeftBorderColor(int color, CellRangeAddress region, Sheet sheet,
+            Workbook workbook) {
+        int rowStart = region.getFirstRow();
+        int rowEnd = region.getLastRow();
+        int column = region.getFirstColumn();
+
+        CellPropertySetter cps = new CellPropertySetter(CellUtil.LEFT_BORDER_COLOR, color);
+        for (int i = rowStart; i <= rowEnd; i++) {
+            cps.setProperty(CellUtil.getRow(i, sheet), column);
+        }
+    }
+
+    /**
+     * Sets the borderRight attribute of the RegionUtil object
+     *
+     * @param border The new border
+     * @param region The region that should have the border
+     * @param workbook The workbook that the region is on.
+     * @param sheet The sheet that the region is on.
+     */
+    public static void setBorderRight(int border, CellRangeAddress region, Sheet sheet,
+            Workbook workbook) {
+        int rowStart = region.getFirstRow();
+        int rowEnd = region.getLastRow();
+        int column = region.getLastColumn();
+
+        CellPropertySetter cps = new CellPropertySetter(CellUtil.BORDER_RIGHT, border);
+        for (int i = rowStart; i <= rowEnd; i++) {
+            cps.setProperty(CellUtil.getRow(i, sheet), column);
+        }
+    }
+
+    /**
+     * Sets the rightBorderColor attribute of the RegionUtil object
+     *
+     * @param color The color of the border
+     * @param region The region that should have the border
+     * @param workbook The workbook that the region is on.
+     * @param sheet The sheet that the region is on.
+     */
+    public static void setRightBorderColor(int color, CellRangeAddress region, Sheet sheet,
+            Workbook workbook) {
+        int rowStart = region.getFirstRow();
+        int rowEnd = region.getLastRow();
+        int column = region.getLastColumn();
+
+        CellPropertySetter cps = new CellPropertySetter(CellUtil.RIGHT_BORDER_COLOR, color);
+        for (int i = rowStart; i <= rowEnd; i++) {
+            cps.setProperty(CellUtil.getRow(i, sheet), column);
+        }
+    }
+
+    /**
+     * Sets the borderBottom attribute of the RegionUtil object
+     *
+     * @param border The new border
+     * @param region The region that should have the border
+     * @param workbook The workbook that the region is on.
+     * @param sheet The sheet that the region is on.
+     */
+    public static void setBorderBottom(int border, CellRangeAddress region, Sheet sheet,
+            Workbook workbook) {
+        int colStart = region.getFirstColumn();
+        int colEnd = region.getLastColumn();
+        int rowIndex = region.getLastRow();
+        CellPropertySetter cps = new CellPropertySetter(CellUtil.BORDER_BOTTOM, border);
+        Row row = CellUtil.getRow(rowIndex, sheet);
+        for (int i = colStart; i <= colEnd; i++) {
+            cps.setProperty(row, i);
+        }
+    }
+
+    /**
+     * Sets the bottomBorderColor attribute of the RegionUtil object
+     *
+     * @param color The color of the border
+     * @param region The region that should have the border
+     * @param workbook The workbook that the region is on.
+     * @param sheet The sheet that the region is on.
+     */
+    public static void setBottomBorderColor(int color, CellRangeAddress region, Sheet sheet,
+            Workbook workbook) {
+        int colStart = region.getFirstColumn();
+        int colEnd = region.getLastColumn();
+        int rowIndex = region.getLastRow();
+        CellPropertySetter cps = new CellPropertySetter(CellUtil.BOTTOM_BORDER_COLOR, color);
+        Row row = CellUtil.getRow(rowIndex, sheet);
+        for (int i = colStart; i <= colEnd; i++) {
+            cps.setProperty(row, i);
+        }
+    }
+
+    /**
+     * Sets the borderBottom attribute of the RegionUtil object
+     *
+     * @param border The new border
+     * @param region The region that should have the border
+     * @param workbook The workbook that the region is on.
+     * @param sheet The sheet that the region is on.
+     */
+    public static void setBorderTop(int border, CellRangeAddress region, Sheet sheet,
+            Workbook workbook) {
+        int colStart = region.getFirstColumn();
+        int colEnd = region.getLastColumn();
+        int rowIndex = region.getFirstRow();
+        CellPropertySetter cps = new CellPropertySetter(CellUtil.BORDER_TOP, border);
+        Row row = CellUtil.getRow(rowIndex, sheet);
+        for (int i = colStart; i <= colEnd; i++) {
+            cps.setProperty(row, i);
+        }
+    }
+
+    /**
+     * Sets the topBorderColor attribute of the RegionUtil object
+     *
+     * @param color The color of the border
+     * @param region The region that should have the border
+     * @param workbook The workbook that the region is on.
+     * @param sheet The sheet that the region is on.
+     */
+    public static void setTopBorderColor(int color, CellRangeAddress region, Sheet sheet,
+            Workbook workbook) {
+        int colStart = region.getFirstColumn();
+        int colEnd = region.getLastColumn();
+        int rowIndex = region.getFirstRow();
+        CellPropertySetter cps = new CellPropertySetter(CellUtil.TOP_BORDER_COLOR, color);
+        Row row = CellUtil.getRow(rowIndex, sheet);
+        for (int i = colStart; i <= colEnd; i++) {
+            cps.setProperty(row, i);
+        }
+    }
 }



---------------------------------------------------------------------
To unsubscribe, e-mail: commits-unsubscribe@poi.apache.org
For additional commands, e-mail: commits-help@poi.apache.org


Mime
View raw message