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