poi-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From jmarkmur...@apache.org
Subject svn commit: r1754700 - in /poi: site/src/documentation/content/xdocs/spreadsheet/ trunk/src/examples/src/org/apache/poi/ss/examples/ trunk/src/java/org/apache/poi/ss/util/ trunk/src/testcases/org/apache/poi/ss/util/
Date Mon, 01 Aug 2016 04:21:15 GMT
Author: jmarkmurphy
Date: Mon Aug  1 04:21:14 2016
New Revision: 1754700

URL: http://svn.apache.org/viewvc?rev=1754700&view=rev
Log:
revert changes made in r1754691

Removed:
    poi/trunk/src/examples/src/org/apache/poi/ss/examples/DrawingBorders.java
    poi/trunk/src/java/org/apache/poi/ss/util/BorderExtent.java
    poi/trunk/src/java/org/apache/poi/ss/util/CellStyleTemplate.java
    poi/trunk/src/testcases/org/apache/poi/ss/util/TestCellStyleTemplate.java
Modified:
    poi/site/src/documentation/content/xdocs/spreadsheet/quick-guide.xml
    poi/trunk/src/java/org/apache/poi/ss/util/CellAddress.java

Modified: poi/site/src/documentation/content/xdocs/spreadsheet/quick-guide.xml
URL: http://svn.apache.org/viewvc/poi/site/src/documentation/content/xdocs/spreadsheet/quick-guide.xml?rev=1754700&r1=1754699&r2=1754700&view=diff
==============================================================================
--- poi/site/src/documentation/content/xdocs/spreadsheet/quick-guide.xml (original)
+++ poi/site/src/documentation/content/xdocs/spreadsheet/quick-guide.xml Mon Aug  1 04:21:14
2016
@@ -76,7 +76,6 @@
                     <li><link href="#Hiding">Hiding and Un-Hiding Rows</link></li>
                     <li><link href="#CellProperties">Setting Cell Properties</link></li>
                     <li><link href="#PivotTable">Create a Pivot Table</link></li>
-                    <li><link href="#DrawingBorders">Drawing Borders</link></li>
                     <li><link href="#RichText">Cells with multiple styles</link></li>
                 </ul>
             </section>
@@ -2229,64 +2228,6 @@ the data to populate another drop down l
   pivotTable.addReportFilter(3);
         </source>
       </section>
-  <anchor id="DrawingBorders"/>
-    <section>
-      <title>Drawing Borders</title>
-      <p>
-      In Excel, you can apply a set of borders on an entire workbook region at the press
of a button. The PropertyTemplate
-      object simulates this with methods and constants defined to allow drawing top, bottom,
left, right, horizontal,
-      vertical, inside, outside, or all borders around a range of cells. Additional methods
allow for applying colors
-      to the borders. 
-      </p>
-      <p>
-      It works like this: you create a PropertyTemplate object which is a container for the
borders you wish to apply to a
-      sheet. Then you add borders and colors to the PropertyTemplate, and finally apply it
to whichever sheets you need
-      that set of borders on. You can create multiple PropertyTemplate objects and apply
them to a single sheet, or you can 
-      apply the same PropertyTemplate object to multiple sheets. It is just like a preprinted
form.
-      </p>
-      <source>
-  // 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
-  Workbook wb = new XSSFWorkbook();
-  Sheet sh = wb.createSheet("Sheet1");
-  pt.applyBorders(sh);
-      </source>
-      <p>
-      NOTE: The last pt.drawBorders() call removes the borders from the range by using CellStyle.BORDER_NONE.
Like
-      setCellStyleProperties, the applyBorders method merges the properties of a cell style,
so existing borders
-      are changed only if they are replaced by something else, or removed only if they are
replaced by 
-      CellStyle.BORDER_NONE. To remove a color from a border, use IndexedColor.AUTOMATIC.getIndex().
-      </p>
-      <p>Additionally, to remove a border or color from the PropertyTemplate object,
use Extent.NONE.</p>
-      <p>
-      This does not work with diagonal borders yet.
-      </p>
-    </section>
       <anchor id="RichText"/>
       <section><title>Cells with multiple styles (Rich Text Strings)</title>
         <p>

Modified: poi/trunk/src/java/org/apache/poi/ss/util/CellAddress.java
URL: http://svn.apache.org/viewvc/poi/trunk/src/java/org/apache/poi/ss/util/CellAddress.java?rev=1754700&r1=1754699&r2=1754700&view=diff
==============================================================================
--- poi/trunk/src/java/org/apache/poi/ss/util/CellAddress.java (original)
+++ poi/trunk/src/java/org/apache/poi/ss/util/CellAddress.java Mon Aug  1 04:21:14 2016
@@ -97,15 +97,6 @@ public class CellAddress implements Comp
     }
     
     /**
-     * Create a new CellAddress object.
-     *
-     * @param address a cell address
-     */
-    public CellAddress(CellAddress address) {
-        this(address._row, address._col);
-    }    
-    
-    /**
      * Get the cell address row
      *
      * @return row



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


Mime
View raw message