ASF Bugzilla – Attachment 5076 Details for
Bug 17491
[PATCH]Unable to set the order sheets appear in
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
Remember
[x]
|
Forgot Password
Login:
[x]
[patch]
Added function setSheetOrder and a class to test it
patch.txt (text/plain), 10.44 KB, created by
Ruel Loehr
on 2003-02-27 15:22:04 UTC
(
hide
)
Description:
Added function setSheetOrder and a class to test it
Filename:
MIME Type:
Creator:
Ruel Loehr
Created:
2003-02-27 15:22:04 UTC
Size:
10.44 KB
patch
obsolete
>Index: .classpath >=================================================================== >RCS file: /home/cvspublic/jakarta-poi/.classpath,v >retrieving revision 1.3 >diff -u -r1.3 .classpath >--- .classpath 1 Jan 2003 09:24:39 -0000 1.3 >+++ .classpath 27 Feb 2003 15:18:30 -0000 >@@ -3,8 +3,37 @@ > <classpathentry kind="src" path="src/testcases"/> > <classpathentry kind="src" path="src/java"/> > <classpathentry kind="src" path="src/examples/src"/> >- <classpathentry kind="var" path="JRE_LIB" rootpath="JRE_SRCROOT" sourcepath="JRE_SRC"/> >- <classpathentry kind="lib" path="tools/cents/junit.cent/lib/junit-3.7.jar"/> >+ <classpathentry kind="var" path="JRE_LIB" sourcepath="JRE_SRC"/> > <classpathentry kind="lib" path="lib/core/commons-logging-1.0.jar"/> >+ <classpathentry kind="lib" path="F:/finaleclipse/eclipse/workspace/jakarta-poi/tools/cents/junit.cent/lib/ant-junit.jar"/> >+ <classpathentry kind="lib" path="F:/finaleclipse/eclipse/workspace/jakarta-poi/tools/cents/junit.cent/lib/junit-3.7.jar"/> >+ <classpathentry kind="lib" path="F:/finaleclipse/eclipse/workspace/jakarta-poi/tools/cents/umldoclet.cent/lib/UMLDoclet.jar"/> >+ <classpathentry kind="lib" path="F:/finaleclipse/eclipse/workspace/jakarta-poi/tools/cents/jdepend.cent/lib/jdepend.jar"/> >+ <classpathentry kind="lib" path="F:/finaleclipse/eclipse/workspace/jakarta-poi/tools/cents/jdepend.cent/lib/ant-jdepend.jar"/> >+ <classpathentry kind="lib" path="F:/finaleclipse/eclipse/workspace/jakarta-poi/tools/cents/javasrc.cent/lib/javasrc.jar"/> >+ <classpathentry kind="lib" path="F:/finaleclipse/eclipse/workspace/jakarta-poi/tools/cents/javasrc.cent/lib/antlrall.jar"/> >+ <classpathentry kind="lib" path="F:/finaleclipse/eclipse/workspace/jakarta-poi/tools/cents/forrest.cent/lib/resolver-20020130.jar"/> >+ <classpathentry kind="lib" path="F:/finaleclipse/eclipse/workspace/jakarta-poi/tools/cents/forrest.cent/lib/avalon-framework-4.1.2.jar"/> >+ <classpathentry kind="lib" path="F:/finaleclipse/eclipse/workspace/jakarta-poi/tools/cents/forrest.cent/lib/avalon-scratchpad-20020212.jar"/> >+ <classpathentry kind="lib" path="F:/finaleclipse/eclipse/workspace/jakarta-poi/tools/cents/forrest.cent/lib/cocoon.jar"/> >+ <classpathentry kind="lib" path="F:/finaleclipse/eclipse/workspace/jakarta-poi/tools/cents/forrest.cent/lib/cocoon-scratchpad-part.jar"/> >+ <classpathentry kind="lib" path="F:/finaleclipse/eclipse/workspace/jakarta-poi/tools/cents/forrest.cent/lib/commons-collections-1.0.jar"/> >+ <classpathentry kind="lib" path="F:/finaleclipse/eclipse/workspace/jakarta-poi/tools/cents/forrest.cent/lib/commons-httpclient-20011012.jar"/> >+ <classpathentry kind="lib" path="F:/finaleclipse/eclipse/workspace/jakarta-poi/tools/cents/forrest.cent/lib/jakarta-regexp-1.2.jar"/> >+ <classpathentry kind="lib" path="F:/finaleclipse/eclipse/workspace/jakarta-poi/tools/cents/forrest.cent/lib/logkit-1.0.1.jar"/> >+ <classpathentry kind="lib" path="F:/finaleclipse/eclipse/workspace/jakarta-poi/tools/cents/forrest.cent/lib/avalon-excalibur-4.1.jar"/> >+ <classpathentry kind="lib" path="F:/finaleclipse/eclipse/workspace/jakarta-poi/tools/cents/checkstyle.cent/lib/jakarta-regexp-1.2.jar"/> >+ <classpathentry kind="lib" path="F:/finaleclipse/eclipse/workspace/jakarta-poi/tools/cents/checkstyle.cent/lib/checkstyle-2.1.jar"/> >+ <classpathentry kind="lib" path="F:/finaleclipse/eclipse/workspace/jakarta-poi/tools/cents/checkstyle.cent/lib/antlr.jar"/> >+ <classpathentry kind="lib" path="F:/finaleclipse/eclipse/workspace/jakarta-poi/tools/antipede/lib/krysalis-centipede.jar"/> >+ <classpathentry kind="lib" path="F:/finaleclipse/eclipse/workspace/jakarta-poi/tools/antipede/lib/ant-contrib-0.1.jar"/> >+ <classpathentry kind="lib" path="F:/finaleclipse/eclipse/workspace/jakarta-poi/tools/antipede/lib/ant-optional-1.5-dev-20020402.jar"/> >+ <classpathentry kind="lib" path="F:/finaleclipse/eclipse/workspace/jakarta-poi/tools/antipede/lib/ant-taskdefs-dev-20020402.jar"/> >+ <classpathentry kind="lib" path="F:/finaleclipse/eclipse/workspace/jakarta-poi/tools/antipede/lib/ant-xmlproperty-1.5-cvs.jar"/> >+ <classpathentry kind="lib" path="F:/finaleclipse/eclipse/workspace/jakarta-poi/tools/antipede/lib/jjar.jar"/> >+ <classpathentry kind="lib" path="F:/finaleclipse/eclipse/workspace/jakarta-poi/tools/antipede/lib/ant-1.5-dev-20020402.jar"/> >+ <classpathentry kind="lib" path="F:/finaleclipse/eclipse/workspace/jakarta-poi/lib/endorsed/xml-apis.jar"/> >+ <classpathentry kind="lib" path="F:/finaleclipse/eclipse/workspace/jakarta-poi/lib/endorsed/xerces-2.0.0.jar"/> >+ <classpathentry kind="lib" path="F:/finaleclipse/eclipse/workspace/jakarta-poi/lib/endorsed/xalan-2.2.0.jar"/> > <classpathentry kind="output" path="build"/> > </classpath> >Index: src/java/org/apache/poi/hssf/model/Workbook.java >=================================================================== >RCS file: /home/cvspublic/jakarta-poi/src/java/org/apache/poi/hssf/model/Workbook.java,v >retrieving revision 1.25 >diff -u -r1.25 Workbook.java >--- src/java/org/apache/poi/hssf/model/Workbook.java 6 Feb 2003 10:29:44 -0000 1.25 >+++ src/java/org/apache/poi/hssf/model/Workbook.java 27 Feb 2003 15:18:31 -0000 >@@ -428,6 +428,8 @@ > // for compatibility > public void setSheetName(int sheetnum, String sheetname ) { > setSheetName( sheetnum, sheetname, (byte)0 ); >+ >+ > } > > public void setSheetName(int sheetnum, String sheetname, short encoding ) { >@@ -437,6 +439,21 @@ > sheet.setSheetnameLength( (byte)sheetname.length() ); > sheet.setCompressedUnicodeFlag( (byte)encoding ); > } >+ >+ /** >+ * sets the order of appearance for a given sheet. >+ * >+ * @param sheetname the name of the sheet to reorder >+ * @param pos the position that we want to insert the sheet into (0 based) >+ */ >+ >+ public void setSheetOrder(String sheetname, int pos ) { >+ int sheetNumber = getSheetIndex(sheetname); >+ >+ //remove the sheet that needs to be reordered and place it in the spot we want >+ boundsheets.add(pos, boundsheets.remove(sheetNumber)); >+ >+ } > > /** > * gets the name for a given sheet. >Index: src/testcases/org/apache/poi/hssf/usermodel/TestHSSFSheetSetOrder.java >=================================================================== >RCS file: src/testcases/org/apache/poi/hssf/usermodel/TestHSSFSheetSetOrder.java >diff -N src/testcases/org/apache/poi/hssf/usermodel/TestHSSFSheetSetOrder.java >--- /dev/null 1 Jan 1970 00:00:00 -0000 >+++ src/testcases/org/apache/poi/hssf/usermodel/TestHSSFSheetSetOrder.java 27 Feb 2003 15:18:31 -0000 >@@ -0,0 +1,99 @@ >+/* ==================================================================== >+ * The Apache Software License, Version 1.1 >+ * >+ * Copyright (c) 2002 The Apache Software Foundation. All rights >+ * reserved. >+ * >+ * Redistribution and use in source and binary forms, with or without >+ * modification, are permitted provided that the following conditions >+ * are met: >+ * >+ * 1. Redistributions of source code must retain the above copyright >+ * notice, this list of conditions and the following disclaimer. >+ * >+ * 2. Redistributions in binary form must reproduce the above copyright >+ * notice, this list of conditions and the following disclaimer in >+ * the documentation and/or other materials provided with the >+ * distribution. >+ * >+ * 3. The end-user documentation included with the redistribution, >+ * if any, must include the following acknowledgment: >+ * "This product includes software developed by the >+ * Apache Software Foundation (http://www.apache.org/)." >+ * Alternately, this acknowledgment may appear in the software itself, >+ * if and wherever such third-party acknowledgments normally appear. >+ * >+ * 4. The names "Apache" and "Apache Software Foundation" and >+ * "Apache POI" must not be used to endorse or promote products >+ * derived from this software without prior written permission. For >+ * written permission, please contact apache@apache.org. >+ * >+ * 5. Products derived from this software may not be called "Apache", >+ * "Apache POI", nor may "Apache" appear in their name, without >+ * prior written permission of the Apache Software Foundation. >+ * >+ * THIS SOFTWARE IS PROVIDED ``AS IS'' AND ANY EXPRESSED OR IMPLIED >+ * WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES >+ * OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE >+ * DISCLAIMED. IN NO EVENT SHALL THE APACHE SOFTWARE FOUNDATION OR >+ * ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, >+ * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT >+ * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF >+ * USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND >+ * ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, >+ * OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT >+ * OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF >+ * SUCH DAMAGE. >+ * ==================================================================== >+ * >+ * This software consists of voluntary contributions made by many >+ * individuals on behalf of the Apache Software Foundation. For more >+ * information on the Apache Software Foundation, please see >+ * <http://www.apache.org/>. >+ */ >+ >+package org.apache.poi.hssf.usermodel; >+ >+import junit.framework.TestCase; >+ >+import org.apache.poi.hssf.model.Sheet; >+ >+/** >+ * Tests HSSFWorkbook method setSheetOrder() >+ * >+ * >+ * @author Ruel Loehr (loehr1 at us.ibm.com) >+ */ >+ >+public class TestHSSFSheetSetOrder >+ extends TestCase >+{ >+ public TestHSSFSheetSetOrder(String s) >+ { >+ super(s); >+ } >+ >+ /** >+ * Test the sheet set order method >+ */ >+ >+ public void testBackupRecord() >+ throws Exception >+ { >+ HSSFWorkbook wb = new HSSFWorkbook(); >+ >+ for (int i=0; i < 10; i++) >+ { >+ HSSFSheet s = wb.createSheet("Sheet " + i); >+ Sheet sheet = s.getSheet(); >+ } >+ >+ wb.getWorkbook().setSheetOrder("Sheet 6", 0); >+ wb.getWorkbook().setSheetOrder("Sheet 3", 7); >+ wb.getWorkbook().setSheetOrder("Sheet 1", 9); >+ >+ >+ } >+ >+ >+} >Index: tools/cents/checkstyle.cent.jar >=================================================================== >RCS file: tools/cents/checkstyle.cent.jar >diff -N tools/cents/checkstyle.cent.jar >Binary files /dev/null and checkstyle.cent.jar differ
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
Attachments on
bug 17491
: 5076 |
5117
|
5121