[patch] Patch to shift rows.

patch.txt (text/plain), 10.12 KB, created by Shawn Laubach on 2002-10-05 19:15:57 UTC

(hide)

Description: Patch to shift rows.

Filename:

MIME Type:

Creator: Shawn Laubach

Created: 2002-10-05 19:15:57 UTC

Size: 10.12 KB

patch

obsolete

>? build/classes >? build/contrib >? build/docs >? build/examples >? build/jakarta-poi-1.9.0-dev-20021005.jar >? build/jakarta-poi-contrib-1.9.0-dev-20021005.jar >? build/jakarta-poi-examples-1.9.0-dev-20021005.jar >? build/jakarta-poi-scratchpad-1.9.0-dev-20021005.jar >? build/java >? build/scratchpad >? build/testcases >? build/work >? tools/cents/forrest.cent/legal >? tools/cents/forrest.cent/tasks.properties >? tools/cents/forrest.cent/xbuild.xml >? tools/cents/forrest.cent/conf/cocoon.xconf >? tools/cents/forrest.cent/conf/sitemap.xmap >? tools/cents/forrest.cent/lib/avalon-excalibur-4.1.jar >? tools/cents/forrest.cent/lib/avalon-framework-4.1.2.jar >? tools/cents/forrest.cent/lib/avalon-scratchpad-20020212.jar >? tools/cents/forrest.cent/lib/cocoon-scratchpad-part.jar >? tools/cents/forrest.cent/lib/cocoon.jar >? tools/cents/forrest.cent/lib/commons-collections-1.0.jar >? tools/cents/forrest.cent/lib/commons-httpclient-20011012.jar >? tools/cents/forrest.cent/lib/jakarta-regexp-1.2.jar >? tools/cents/forrest.cent/lib/logkit-1.0.1.jar >? tools/cents/forrest.cent/lib/resolver-20020130.jar >? tools/cents/forrest.cent/resources/library/xslt/changes2document.xsl >? tools/cents/forrest.cent/resources/library/xslt/copyover.xsl >? tools/cents/forrest.cent/resources/library/xslt/doclist.xsl >? tools/cents/forrest.cent/resources/library/xslt/doclist2document.xsl >? tools/cents/forrest.cent/resources/library/xslt/faq2document.xsl >? tools/cents/forrest.cent/resources/library/xslt/filterlinks.xsl >? tools/cents/forrest.cent/resources/library/xslt/todo2document.xsl >? tools/cents/forrest.cent/resources/resources/images >? tools/cents/forrest.cent/resources/resources/schema/CatalogManager.properties >? tools/cents/forrest.cent/resources/resources/schema/README >? tools/cents/forrest.cent/resources/resources/schema/catalog >? tools/cents/forrest.cent/resources/resources/schema/catalog.xcat >? tools/cents/forrest.cent/resources/resources/schema/dtd/book-cocoon-v10.dtd >? tools/cents/forrest.cent/resources/resources/schema/dtd/changes-v11.dtd >? tools/cents/forrest.cent/resources/resources/schema/dtd/document-v11.dtd >? tools/cents/forrest.cent/resources/resources/schema/dtd/faq-v11.dtd >? tools/cents/forrest.cent/resources/resources/schema/dtd/javadoc-v04draft.dtd >? tools/cents/forrest.cent/resources/resources/schema/dtd/project.dtd >? tools/cents/forrest.cent/resources/resources/schema/dtd/specification-v11.dtd >? tools/cents/forrest.cent/resources/resources/schema/dtd/todo-v11.dtd >? tools/cents/forrest.cent/resources/resources/schema/dtd/xgump.dtd >? tools/cents/forrest.cent/resources/resources/schema/entity/ISOdia.pen >? tools/cents/forrest.cent/resources/resources/schema/entity/ISOgrk1.pen >? tools/cents/forrest.cent/resources/resources/schema/entity/ISOlat1.pen >? tools/cents/forrest.cent/resources/resources/schema/entity/ISOnum.pen >? tools/cents/forrest.cent/resources/resources/schema/entity/ISOpub.pen >? tools/cents/forrest.cent/resources/resources/schema/entity/ISOtech.pen >? tools/cents/forrest.cent/resources/skins/avalon-site >? tools/cents/forrest.cent/resources/skins/basic >? tools/cents/forrest.cent/resources/skins/forrest-site >? tools/cents/forrest.cent/resources/skins/scarab-site2 >? tools/cents/forrest.cent/resources/skins/xml-apache-site >? tools/cents/forrest.cent/resources/skins/jakarta-site/images/add.jpg >? tools/cents/forrest.cent/resources/skins/jakarta-site/images/ant_logo_medium.gif >? tools/cents/forrest.cent/resources/skins/jakarta-site/images/built-with-cocoon.gif >? tools/cents/forrest.cent/resources/skins/jakarta-site/images/favicon.ico >? tools/cents/forrest.cent/resources/skins/jakarta-site/images/krysalis-compatible.jpg >? tools/cents/forrest.cent/resources/skins/jakarta-site/images/note.gif >? tools/cents/forrest.cent/resources/skins/jakarta-site/images/remove.jpg >? tools/cents/forrest.cent/resources/skins/jakarta-site/images/update.jpg >? tools/cents/forrest.cent/resources/skins/jakarta-site/images/void.gif >? tools/cents/forrest.cent/resources/skins/jakarta-site/xslt/html/book2menu.xsl >? tools/cents/forrest.cent/resources/skins/jakarta-site/xslt/html/document2html.xsl >? tools/cents/forrest.cent/resources/skins/jakarta-site/xslt/html/site2xhtml.xsl >? tools/cents/forrest.cent/resources/skins/scarab-site/css/compact.css >? tools/cents/forrest.cent/resources/skins/scarab-site/css/main.css >? tools/cents/forrest.cent/resources/skins/scarab-site/css/ns4_toxins.css >? tools/cents/forrest.cent/resources/skins/scarab-site/css/print.css >? tools/cents/forrest.cent/resources/skins/scarab-site/images/add.jpg >? tools/cents/forrest.cent/resources/skins/scarab-site/images/ant_logo_medium.gif >? tools/cents/forrest.cent/resources/skins/scarab-site/images/built-with-cocoon.gif >? tools/cents/forrest.cent/resources/skins/scarab-site/images/favicon.ico >? tools/cents/forrest.cent/resources/skins/scarab-site/images/grn_alert.gif >? tools/cents/forrest.cent/resources/skins/scarab-site/images/icon_alert.gif >? tools/cents/forrest.cent/resources/skins/scarab-site/images/icon_alertsml.gif >? tools/cents/forrest.cent/resources/skins/scarab-site/images/icon_confirmsml.gif >? tools/cents/forrest.cent/resources/skins/scarab-site/images/icon_downarrow.gif >? tools/cents/forrest.cent/resources/skins/scarab-site/images/icon_downarrow_off.gif >? tools/cents/forrest.cent/resources/skins/scarab-site/images/icon_downarrow_on.gif >? tools/cents/forrest.cent/resources/skins/scarab-site/images/icon_help.gif >? tools/cents/forrest.cent/resources/skins/scarab-site/images/icon_infosml.gif >? tools/cents/forrest.cent/resources/skins/scarab-site/images/icon_uparrow.gif >? tools/cents/forrest.cent/resources/skins/scarab-site/images/icon_uparrow_off.gif >? tools/cents/forrest.cent/resources/skins/scarab-site/images/icon_uparrow_on.gif >? tools/cents/forrest.cent/resources/skins/scarab-site/images/krysalis-compatible.jpg >? tools/cents/forrest.cent/resources/skins/scarab-site/images/note.gif >? tools/cents/forrest.cent/resources/skins/scarab-site/images/nw_min.gif >? tools/cents/forrest.cent/resources/skins/scarab-site/images/remove.jpg >? tools/cents/forrest.cent/resources/skins/scarab-site/images/se_min.gif >? tools/cents/forrest.cent/resources/skins/scarab-site/images/seperator.gif >? tools/cents/forrest.cent/resources/skins/scarab-site/images/seperator2.gif >? tools/cents/forrest.cent/resources/skins/scarab-site/images/seperator3.gif >? tools/cents/forrest.cent/resources/skins/scarab-site/images/strich.gif >? tools/cents/forrest.cent/resources/skins/scarab-site/images/sw_min.gif >? tools/cents/forrest.cent/resources/skins/scarab-site/images/up_pointer.gif >? tools/cents/forrest.cent/resources/skins/scarab-site/images/update.jpg >? tools/cents/forrest.cent/resources/skins/scarab-site/images/void.gif >? tools/cents/forrest.cent/resources/skins/scarab-site/xslt/html/book2menu.xsl >? tools/cents/forrest.cent/resources/skins/scarab-site/xslt/html/document2html.xsl >? tools/cents/forrest.cent/resources/skins/scarab-site/xslt/html/site2xhtml.xsl >? tools/cents/junit.cent/legal >? tools/cents/junit.cent/lib >? tools/cents/junit.cent/tasks.properties >? tools/cents/junit.cent/xbuild.xml >Index: src/java/org/apache/poi/hssf/usermodel/HSSFCell.java >=================================================================== >RCS file: /home/cvspublic/jakarta-poi/src/java/org/apache/poi/hssf/usermodel/HSSFCell.java,v >retrieving revision 1.18 >diff -u -r1.18 HSSFCell.java >--- src/java/org/apache/poi/hssf/usermodel/HSSFCell.java 11 Sep 2002 12:14:28 -0000 1.18 >+++ src/java/org/apache/poi/hssf/usermodel/HSSFCell.java 5 Oct 2002 19:13:16 -0000 >@@ -967,4 +967,15 @@ > throw new RuntimeException("You cannot reference columns with an index of less then 0."); > } > } >+ >+ /** >+ * Sets the cells row. Should be really careful with this. >+ * >+ * @param row the new row number >+ */ >+ public void setRow(int row) { >+ if (record != null) { >+ record.setRow(row); >+ } >+ } > } >Index: src/java/org/apache/poi/hssf/usermodel/HSSFRow.java >=================================================================== >RCS file: /home/cvspublic/jakarta-poi/src/java/org/apache/poi/hssf/usermodel/HSSFRow.java,v >retrieving revision 1.11 >diff -u -r1.11 HSSFRow.java >--- src/java/org/apache/poi/hssf/usermodel/HSSFRow.java 10 May 2002 03:01:10 -0000 1.11 >+++ src/java/org/apache/poi/hssf/usermodel/HSSFRow.java 5 Oct 2002 19:13:16 -0000 >@@ -253,6 +253,13 @@ > { > row.setRowNumber(rowNum); // used only for KEY comparison (HSSFRow) > } >+ if (cells != null) { >+ Iterator i = cells.values().iterator(); >+ while (i.hasNext()) { >+ HSSFCell cell = (HSSFCell)i.next(); >+ cell.setRow(rowNum); >+ } >+ } > } > > /** >Index: src/java/org/apache/poi/hssf/usermodel/HSSFSheet.java >=================================================================== >RCS file: /home/cvspublic/jakarta-poi/src/java/org/apache/poi/hssf/usermodel/HSSFSheet.java,v >retrieving revision 1.13 >diff -u -r1.13 HSSFSheet.java >--- src/java/org/apache/poi/hssf/usermodel/HSSFSheet.java 5 Oct 2002 02:38:07 -0000 1.13 >+++ src/java/org/apache/poi/hssf/usermodel/HSSFSheet.java 5 Oct 2002 19:13:17 -0000 >@@ -829,4 +829,41 @@ > public void setMargin(short margin, double size) { > getSheet().setMargin(margin, size); > } >+ >+ /** >+ * Shifts rows between startRow and endRow n number of rows. >+ * If you use a negative number, it will shift rows up. >+ * >+ * @param startRow the row to start shifting >+ * @param endRow the row to end shifting >+ * @param n the number of rows to shift >+ */ >+ public void shiftRows(int startRow, int endRow, int n) { >+ int s, e, inc; >+ if (n < 0) { >+ s = startRow; >+ e = endRow; >+ inc = 1; >+ } else { >+ s = endRow; >+ e = startRow; >+ inc = -1; >+ } >+ for (int rowNum = s; rowNum >= startRow && rowNum <= endRow; rowNum+=inc) { >+ System.out.println(rowNum); >+ HSSFRow row = getRow(rowNum); >+ HSSFRow row2Replace = getRow(rowNum + n); >+ if (row2Replace != null) { >+ removeRow(row2Replace); >+ } >+ if (row != null) { >+ System.out.println("Shifting " + rowNum); >+ row.setRowNum(rowNum + n); >+ System.out.println(row.getPhysicalNumberOfCells()); >+ } >+ } >+ if (endRow + n > lastrow) lastrow = endRow + n; >+ if (startRow + n > firstrow) firstrow = startRow + n; >+ System.out.println(firstrow + " " + lastrow); >+ } > } View Attachment As Diff View Attachment As Raw

This is ASF Bugzilla: the Apache Software Foundation bug system. In case of problems with the functioning of ASF Bugzilla, please contact bugzilla-admin@apache.org. Please Note: this e-mail address is only for reporting problems with ASF Bugzilla. Mail about any other subject will be silently ignored.

• • Home
  • | New
  • | Browse
  • | Search
  • |
    [?]
  • | Reports
  • | Help
  • | New Account
  • | Log In
    Remember [x]
  • | Forgot Password
    Login: [x]