poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From a...@apache.org
Subject cvs commit: jakarta-poi/src/testcases/org/apache/poi/hssf/usermodel TestHSSFSheet.java
Date Sat, 07 May 2005 17:25:26 GMT
avik        2005/05/07 10:25:26

  Modified:    src/java/org/apache/poi/hssf/model Sheet.java
               src/java/org/apache/poi/hssf/usermodel HSSFSheet.java
               src/testcases/org/apache/poi/hssf/usermodel
                        TestHSSFSheet.java
  Log:
  user API to set window pane when wb is opened
  by Amol Deshmukh and Li Jianming
  
  Revision  Changes    Path
  1.53      +31 -0     jakarta-poi/src/java/org/apache/poi/hssf/model/Sheet.java
  
  Index: Sheet.java
  ===================================================================
  RCS file: /home/cvs/jakarta-poi/src/java/org/apache/poi/hssf/model/Sheet.java,v
  retrieving revision 1.52
  retrieving revision 1.53
  diff -u -r1.52 -r1.53
  --- Sheet.java	5 May 2005 13:07:58 -0000	1.52
  +++ Sheet.java	7 May 2005 17:25:26 -0000	1.53
  @@ -1934,6 +1934,37 @@
           return retval;
       }
       
  +    public short getTopRow() 
  +    {
  +    	return (windowTwo==null) ? (short) 0 : windowTwo.getTopRow();
  +    }
  +    
  +    public void setTopRow(short topRow) 
  +    {
  +    	if (windowTwo!=null) 
  +    	{
  +    		windowTwo.setTopRow(topRow);
  +    	}
  +    }
  +   
  +    /**
  +     * Sets the left column to show in desktop window pane.
  +     * @param the left column to show in desktop window pane
  +     */
  +        public void setLeftCol(short leftCol){
  +        	if (windowTwo!=null) 
  +        	{   
  +        	windowTwo.setLeftCol(leftCol);
  +        	}
  +        }
  +        
  +        public short getLeftCol() 
  +        {
  +        	return (windowTwo==null) ? (short) 0 : windowTwo.getLeftCol();
  +        }
  +        
  +        
  +    
       /**
        * Returns the active row
        *
  
  
  
  1.32      +31 -0     jakarta-poi/src/java/org/apache/poi/hssf/usermodel/HSSFSheet.java
  
  Index: HSSFSheet.java
  ===================================================================
  RCS file: /home/cvs/jakarta-poi/src/java/org/apache/poi/hssf/usermodel/HSSFSheet.java,v
  retrieving revision 1.31
  retrieving revision 1.32
  diff -u -r1.31 -r1.32
  --- HSSFSheet.java	1 May 2005 11:26:18 -0000	1.31
  +++ HSSFSheet.java	7 May 2005 17:25:26 -0000	1.32
  @@ -871,6 +871,37 @@
           sclRecord.setDenominator((short)denominator);
           getSheet().setSCLRecord(sclRecord);
       }
  +    
  +    /**
  +     * The top row in the visible view when the sheet is 
  +     * first viewed after opening it in a viewer 
  +     * @return short indicating the rownum (0 based) of the top row
  +     */
  +    public short getTopRow() 
  +    {
  +    	return sheet.getTopRow();
  +    }
  +    
  +    /**
  +     * The left col in the visible view when the sheet is 
  +     * first viewed after opening it in a viewer 
  +     * @return short indicating the rownum (0 based) of the top row
  +     */
  +    public short getLeftCol() 
  +    {
  +    	return sheet.getLeftCol();
  +    }
  +    
  +    /**
  +     * Sets desktop window pane display area, when the 
  +     * file is first opened in a viewer.
  +     * @param the top row to show in desktop window pane
  +     * @param the left column to show in desktop window pane
  +     */
  +    public void showInPane(short toprow, short leftcol){
  +        this.sheet.setTopRow((short)toprow);
  +        this.sheet.setLeftCol((short)leftcol);
  +        }
   
   	/**
   	 * Shifts the merged regions left or right depending on mode
  
  
  
  1.24      +28 -1     jakarta-poi/src/testcases/org/apache/poi/hssf/usermodel/TestHSSFSheet.java
  
  Index: TestHSSFSheet.java
  ===================================================================
  RCS file: /home/cvs/jakarta-poi/src/testcases/org/apache/poi/hssf/usermodel/TestHSSFSheet.java,v
  retrieving revision 1.23
  retrieving revision 1.24
  diff -u -r1.23 -r1.24
  --- TestHSSFSheet.java	28 Apr 2005 13:44:06 -0000	1.23
  +++ TestHSSFSheet.java	7 May 2005 17:25:26 -0000	1.24
  @@ -409,7 +409,34 @@
           assertEquals ("DBCS Sheet Name 2", wb.getSheetName(1),"\u090f\u0915" );
           assertEquals("DBCS Sheet Name 1", wb.getSheetName(0),"\u091c\u093e");
       }
  -	
  +    
  +    /**
  +     * Testing newly added method that exposes the WINDOW2.toprow
  +     * parameter to allow setting the toprow in the visible view
  +     * of the sheet when it is first opened.
  +     */
  +    public void testTopRow() throws Exception
  +    {
  +        FileInputStream fis = null;
  +        HSSFWorkbook wb     = null;
  +        
  +        String filename = System.getProperty("HSSF.testdata.path");
  +
  +        filename = filename + "/SimpleWithPageBreaks.xls";
  +        fis = new FileInputStream(filename);
  +        wb = new HSSFWorkbook(fis);
  +        fis.close();
  +        
  +        HSSFSheet sheet = wb.getSheetAt(0);
  +        assertNotNull(sheet);
  +        
  +        short toprow = (short) 100;
  +        short leftcol = (short) 50;
  +        sheet.showInPane(toprow,leftcol);
  +        assertEquals("HSSFSheet.getTopRow()", toprow, sheet.getTopRow());
  +        assertEquals("HSSFSheet.getLeftCol()", leftcol, sheet.getLeftCol());
  +    }
  +    
   	public static void main(java.lang.String[] args) {
   		 junit.textui.TestRunner.run(TestHSSFSheet.class);
   	}    
  
  
  

---------------------------------------------------------------------
To unsubscribe, e-mail: poi-dev-unsubscribe@jakarta.apache.org
Mailing List:    http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta POI Project: http://jakarta.apache.org/poi/


Mime
View raw message