+props svn:eol-style=native

git-svn-id: https://svn.apache.org/repos/asf/poi/branches/ss_border_property_template@1747852 13f79535-47bb-0310-9956-ffa450edef68

1 files changed, 111 insertions, 111 deletions

diff --git a/src/examples/src/org/apache/poi/ss/examples/DrawingBorders.java b/src/examples/src/org/apache/poi/ss/examples/DrawingBorders.java
index 5add842662..1910bfa7d0 100644
--- a/src/examples/src/org/apache/poi/ss/examples/DrawingBorders.java
+++ b/src/examples/src/org/apache/poi/ss/examples/DrawingBorders.java
@@ -1,111 +1,111 @@
-/*

- *  ====================================================================

- *    Licensed to the Apache Software Foundation (ASF) under one or more

- *    contributor license agreements.  See the NOTICE file distributed with

- *    this work for additional information regarding copyright ownership.

- *    The ASF licenses this file to You under the Apache License, Version 2.0

- *    (the "License"); you may not use this file except in compliance with

- *    the License.  You may obtain a copy of the License at

- *

- *        http://www.apache.org/licenses/LICENSE-2.0

- *

- *    Unless required by applicable law or agreed to in writing, software

- *    distributed under the License is distributed on an "AS IS" BASIS,

- *    WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.

- *    See the License for the specific language governing permissions and

- *    limitations under the License.

- * ====================================================================

- */

-

-package org.apache.poi.ss.examples;

-

-import java.io.FileOutputStream;

-import java.io.IOException;

-

-import org.apache.poi.hssf.usermodel.HSSFWorkbook;

-import org.apache.poi.ss.usermodel.Cell;

-import org.apache.poi.ss.usermodel.CellStyle;

-import org.apache.poi.ss.usermodel.IndexedColors;

-import org.apache.poi.ss.usermodel.Row;

-import org.apache.poi.ss.usermodel.Sheet;

-import org.apache.poi.ss.usermodel.Workbook;

-import org.apache.poi.ss.util.PropertyTemplate;

-import org.apache.poi.ss.util.CellRangeAddress;

-import org.apache.poi.xssf.usermodel.XSSFWorkbook;

-

-/**

- * Excel Border Drawing - examples

- * 

- * <p>

- * Partly based on the code snippets from

- * org.apache.poi.ss.examples.ConditionalFormats

- * </p>

- */

-public class DrawingBorders {

-

-    public static void main(String[] args) throws IOException {

-        Workbook wb;

-

-        if (args.length > 0 && args[0].equals("-xls")) {

-            wb = new HSSFWorkbook();

-        } else {

-            wb = new XSSFWorkbook();

-        }

-

-        // add a sheet, and put some values into it

-        Sheet sh1 = wb.createSheet("Sheet1");

-        Row r = sh1.createRow(0);

-        Cell c = r.createCell(1);

-        c.setCellValue("All Borders Medium Width");

-        r = sh1.createRow(4);

-        c = r.createCell(1);

-        c.setCellValue("Medium Outside / Thin Inside Borders");

-        r = sh1.createRow(8);

-        c = r.createCell(1);

-        c.setCellValue("Colored Borders");

-

-        // draw borders (three 3x3 grids)

-        PropertyTemplate pt = new PropertyTemplate();

-        // #1) these borders will all be medium in default color

-        pt.drawBorders(new CellRangeAddress(1, 3, 1, 3),

-                CellStyle.BORDER_MEDIUM, PropertyTemplate.Extent.ALL);

-        // #2) these cells will have medium outside borders and thin inside borders

-        pt.drawBorders(new CellRangeAddress(5, 7, 1, 3),

-                CellStyle.BORDER_MEDIUM, PropertyTemplate.Extent.OUTSIDE);

-        pt.drawBorders(new CellRangeAddress(5, 7, 1, 3), CellStyle.BORDER_THIN,

-                PropertyTemplate.Extent.INSIDE);

-        // #3) these cells will all be medium weight with different colors for the

-        //     outside, inside horizontal, and inside vertical borders. The center

-        //     cell will have no borders.

-        pt.drawBorders(new CellRangeAddress(9, 11, 1, 3),

-                CellStyle.BORDER_MEDIUM, IndexedColors.RED.getIndex(),

-                PropertyTemplate.Extent.OUTSIDE);

-        pt.drawBorders(new CellRangeAddress(9, 11, 1, 3),

-                CellStyle.BORDER_MEDIUM, IndexedColors.BLUE.getIndex(),

-                PropertyTemplate.Extent.INSIDE_VERTICAL);

-        pt.drawBorders(new CellRangeAddress(9, 11, 1, 3),

-                CellStyle.BORDER_MEDIUM, IndexedColors.GREEN.getIndex(),

-                PropertyTemplate.Extent.INSIDE_HORIZONTAL);

-        pt.drawBorders(new CellRangeAddress(10, 10, 2, 2),

-                CellStyle.BORDER_NONE, 

-                PropertyTemplate.Extent.ALL);

-

-        // apply borders to sheet

-        pt.applyBorders(sh1);

-        

-        // add another sheet and apply the borders to it

-        Sheet sh2 = wb.createSheet("Sheet2");

-        pt.applyBorders(sh2);

-

-        // Write the output to a file

-        String file = "db-poi.xls";

-        if (wb instanceof XSSFWorkbook)

-            file += "x";

-        FileOutputStream out = new FileOutputStream(file);

-        wb.write(out);

-        out.close();

-        wb.close();

-        System.out.println("Generated: " + file);

-    }

-

-}

+/*
+ *  ====================================================================
+ *    Licensed to the Apache Software Foundation (ASF) under one or more
+ *    contributor license agreements.  See the NOTICE file distributed with
+ *    this work for additional information regarding copyright ownership.
+ *    The ASF licenses this file to You under the Apache License, Version 2.0
+ *    (the "License"); you may not use this file except in compliance with
+ *    the License.  You may obtain a copy of the License at
+ *
+ *        http://www.apache.org/licenses/LICENSE-2.0
+ *
+ *    Unless required by applicable law or agreed to in writing, software
+ *    distributed under the License is distributed on an "AS IS" BASIS,
+ *    WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
+ *    See the License for the specific language governing permissions and
+ *    limitations under the License.
+ * ====================================================================
+ */
+
+package org.apache.poi.ss.examples;
+
+import java.io.FileOutputStream;
+import java.io.IOException;
+
+import org.apache.poi.hssf.usermodel.HSSFWorkbook;
+import org.apache.poi.ss.usermodel.Cell;
+import org.apache.poi.ss.usermodel.CellStyle;
+import org.apache.poi.ss.usermodel.IndexedColors;
+import org.apache.poi.ss.usermodel.Row;
+import org.apache.poi.ss.usermodel.Sheet;
+import org.apache.poi.ss.usermodel.Workbook;
+import org.apache.poi.ss.util.PropertyTemplate;
+import org.apache.poi.ss.util.CellRangeAddress;
+import org.apache.poi.xssf.usermodel.XSSFWorkbook;
+
+/**
+ * Excel Border Drawing - examples
+ * 
+ * <p>
+ * Partly based on the code snippets from
+ * org.apache.poi.ss.examples.ConditionalFormats
+ * </p>
+ */
+public class DrawingBorders {
+
+    public static void main(String[] args) throws IOException {
+        Workbook wb;
+
+        if (args.length > 0 && args[0].equals("-xls")) {
+            wb = new HSSFWorkbook();
+        } else {
+            wb = new XSSFWorkbook();
+        }
+
+        // add a sheet, and put some values into it
+        Sheet sh1 = wb.createSheet("Sheet1");
+        Row r = sh1.createRow(0);
+        Cell c = r.createCell(1);
+        c.setCellValue("All Borders Medium Width");
+        r = sh1.createRow(4);
+        c = r.createCell(1);
+        c.setCellValue("Medium Outside / Thin Inside Borders");
+        r = sh1.createRow(8);
+        c = r.createCell(1);
+        c.setCellValue("Colored Borders");
+
+        // draw borders (three 3x3 grids)
+        PropertyTemplate pt = new PropertyTemplate();
+        // #1) these borders will all be medium in default color
+        pt.drawBorders(new CellRangeAddress(1, 3, 1, 3),
+                CellStyle.BORDER_MEDIUM, PropertyTemplate.Extent.ALL);
+        // #2) these cells will have medium outside borders and thin inside borders
+        pt.drawBorders(new CellRangeAddress(5, 7, 1, 3),
+                CellStyle.BORDER_MEDIUM, PropertyTemplate.Extent.OUTSIDE);
+        pt.drawBorders(new CellRangeAddress(5, 7, 1, 3), CellStyle.BORDER_THIN,
+                PropertyTemplate.Extent.INSIDE);
+        // #3) these cells will all be medium weight with different colors for the
+        //     outside, inside horizontal, and inside vertical borders. The center
+        //     cell will have no borders.
+        pt.drawBorders(new CellRangeAddress(9, 11, 1, 3),
+                CellStyle.BORDER_MEDIUM, IndexedColors.RED.getIndex(),
+                PropertyTemplate.Extent.OUTSIDE);
+        pt.drawBorders(new CellRangeAddress(9, 11, 1, 3),
+                CellStyle.BORDER_MEDIUM, IndexedColors.BLUE.getIndex(),
+                PropertyTemplate.Extent.INSIDE_VERTICAL);
+        pt.drawBorders(new CellRangeAddress(9, 11, 1, 3),
+                CellStyle.BORDER_MEDIUM, IndexedColors.GREEN.getIndex(),
+                PropertyTemplate.Extent.INSIDE_HORIZONTAL);
+        pt.drawBorders(new CellRangeAddress(10, 10, 2, 2),
+                CellStyle.BORDER_NONE, 
+                PropertyTemplate.Extent.ALL);
+
+        // apply borders to sheet
+        pt.applyBorders(sh1);
+        
+        // add another sheet and apply the borders to it
+        Sheet sh2 = wb.createSheet("Sheet2");
+        pt.applyBorders(sh2);
+
+        // Write the output to a file
+        String file = "db-poi.xls";
+        if (wb instanceof XSSFWorkbook)
+            file += "x";
+        FileOutputStream out = new FileOutputStream(file);
+        wb.write(out);
+        out.close();
+        wb.close();
+        System.out.println("Generated: " + file);
+    }
+
+}