poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From slaub...@apache.org
Subject cvs commit: jakarta-poi/src/java/org/apache/poi/hssf/usermodel HSSFSheet.java
Date Fri, 16 May 2003 16:30:48 GMT
slaubach    2003/05/16 09:30:46

  Modified:    src/java/org/apache/poi/hssf/usermodel HSSFSheet.java
  Log:
  Added ability to copy row height during shift.  Also gave the ability to reset the row height
on a shift for the original rows.
  
  Revision  Changes    Path
  1.21      +32 -4     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.20
  retrieving revision 1.21
  diff -u -r1.20 -r1.21
  --- HSSFSheet.java	30 Apr 2003 04:39:00 -0000	1.20
  +++ HSSFSheet.java	16 May 2003 16:30:46 -0000	1.21
  @@ -890,13 +890,30 @@
       /**
        * Shifts rows between startRow and endRow n number of rows.
        * If you use a negative number, it will shift rows up.
  +     * Code ensures that rows don't wrap around.
  +     *
  +     * Calls shiftRows(startRow, endRow, n, false, false);
  +     *
  +     * @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 ) {
  +	shiftRows(startRow, endRow, n, false, false);
  +    }
  +
  +    /**
  +     * Shifts rows between startRow and endRow n number of rows.
  +     * If you use a negative number, it will shift rows up.
        * Code ensures that rows don't wrap around
        *
        * @param startRow the row to start shifting
        * @param endRow the row to end shifting
        * @param n the number of rows to shift
  +     * @param copyRowHeight whether to copy the row height during the shift
  +     * @param resetOriginalRowHeight whether to set the original row's height to the default
        */
  -    public void shiftRows( int startRow, int endRow, int n )
  +    public void shiftRows( int startRow, int endRow, int n, boolean copyRowHeight, boolean
resetOriginalRowHeight)
       {
           int s, e, inc;
           if ( n < 0 )
  @@ -914,18 +931,29 @@
           for ( int rowNum = s; rowNum >= startRow && rowNum <= endRow &&
rowNum >= 0 && rowNum < 65536; rowNum += inc )
           {
               HSSFRow row = getRow( rowNum );
  -            HSSFRow row2Replace = getRow( rowNum + n );
  +            HSSFRow row2Replace = getRow( rowNum + n );	    
               if ( row2Replace == null )
                   row2Replace = createRow( rowNum + n );
  -
  +	    
               HSSFCell cell;
  +
  +	    // Removes the cells before over writting them.
               for ( short col = row2Replace.getFirstCellNum(); col <= row2Replace.getLastCellNum();
col++ )
               {
                   cell = row2Replace.getCell( col );
                   if ( cell != null )
                       row2Replace.removeCell( cell );
               }
  -	    if (row == null) continue;
  +	    if (row == null) continue; // Nothing to do for this row
  +	    else {
  +		if (copyRowHeight) {
  +		    row2Replace.setHeight(row.getHeight());
  +		}
  +		
  +		if (resetOriginalRowHeight) {
  +		    row.setHeight((short)0xff);
  +		} 
  +	    }
               for ( short col = row.getFirstCellNum(); col <= row.getLastCellNum(); col++
)
               {
                   cell = row.getCell( col );
  
  
  

Mime
View raw message