? 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);
+    }
 }