[patch] Patch for shiftRows to update area references too

shiftRows_update_the_area_too.patch (text/plain), 2.26 KB, created by Antti Koskimäki on 2008-09-11 07:57:56 UTC

(hide)

Description: Patch for shiftRows to update area references too

Filename:

MIME Type:

Creator: Antti Koskimäki

Created: 2008-09-11 07:57:56 UTC

Size: 2.26 KB

patch

obsolete

>Index: src/java/org/apache/poi/hssf/usermodel/HSSFSheet.java >=================================================================== >--- src/java/org/apache/poi/hssf/usermodel/HSSFSheet.java (revision 694253) >+++ src/java/org/apache/poi/hssf/usermodel/HSSFSheet.java (working copy) >@@ -44,6 +44,7 @@ > import org.apache.poi.hssf.record.WindowTwoRecord; > import org.apache.poi.hssf.record.aggregates.DataValidityTable; > import org.apache.poi.hssf.record.formula.Ptg; >+import org.apache.poi.hssf.record.formula.AreaPtg; > import org.apache.poi.hssf.record.formula.RefPtg; > import org.apache.poi.hssf.util.CellRangeAddress; > import org.apache.poi.hssf.util.PaneInformation; >@@ -1282,6 +1283,7 @@ > Ptg[] ptgs = FormulaParser.parse(c.getCellFormula(), workbook); > boolean changed = false; > for(int i=0; i<ptgs.length; i++) { >+ // single reference, like A1 > if(ptgs[i] instanceof RefPtg) { > RefPtg rptg = (RefPtg)ptgs[i]; > if(startRow <= rptg.getRowAsInt() && >@@ -1291,6 +1293,23 @@ > changed = true; > } > } >+ // area refence, like A1:A4 >+ if(ptgs[i] instanceof AreaPtg) { >+ AreaPtg aptg = (AreaPtg)ptgs[i]; >+ if(startRow <= aptg.getFirstRow() && >+ aptg.getFirstRow() <= endRow) { >+ // First row of area references a row that moved >+ aptg.setFirstRow(aptg.getFirstRow() + n); >+ changed = true; >+ } >+ if(startRow <= aptg.getLastRow() && >+ aptg.getLastRow() <= endRow) { >+ // Last row of area references a row that moved >+ aptg.setLastRow(aptg.getLastRow() + n); >+ changed = true; >+ } >+ } >+ > } > // If any references were changed, then > // re-create the formula string View Attachment As Diff View Attachment As Raw

This is ASF Bugzilla: the Apache Software Foundation bug system. In case of problems with the functioning of ASF Bugzilla, please contact bugzilla-admin@apache.org. Please Note: this e-mail address is only for reporting problems with ASF Bugzilla. Mail about any other subject will be silently ignored.

• • Home
  • | New
  • | Browse
  • | Search
  • |
    [?]
  • | Reports
  • | Help
  • | New Account
  • | Log In
    Remember [x]
  • | Forgot Password
    Login: [x]