Package org.zkoss.poi.ss.formula

Examples of org.zkoss.poi.ss.formula.PtgShifter

2384
2385
2386
2387
2388
2389
2390
2391
2392
2393
2394
2395
    return changeMerges;
  }
 
  private static void shiftFormulas(Set<Ref> all, Worksheet sheet, int startRow, int endRow, int nRow, int startCol, int endCol, int nCol) {
    final int moveSheetIndex = sheet.getWorkbook().getSheetIndex(sheet);
        final PtgShifter shifter97 = new PtgShifter(moveSheetIndex, startRow, endRow, nRow, startCol, endCol, nCol, SpreadsheetVersion.EXCEL97);
        final PtgShifter shifter2007 = new PtgShifter(moveSheetIndex, startRow, endRow, nRow, startCol, endCol, nCol, SpreadsheetVersion.EXCEL2007);
    for (Ref ref : all) {
      final int tRow = ref.getTopRow();
      final int lCol = ref.getLeftCol();
      final Worksheet srcSheet = getSheet(sheet, ref.getOwnerSheet());
      final Book srcBook = (Book) srcSheet.getWorkbook();
View Full Code Here
257
258
259
260
261
262
263
264
265
266
267
        //update named ranges
        if (startRow <= endRow) {
          final XSSFWorkbook wb = getWorkbook();
          int sheetIndex = wb.getSheetIndex(this);
          final PtgShifter shifter = new PtgShifter(sheetIndex, startRow, endRow, n, 0, maxcol, 0, SpreadsheetVersion.EXCEL2007);
          updateNamedRanges(wb, shifter);
        }
       
        return shiftedRanges;
    }
View Full Code Here
519
520
521
522
523
524
525
526
527
528
529
       
        //update named ranges
        if (startRow <= endRow) {
          final XSSFWorkbook wb = getWorkbook();
          int sheetIndex = wb.getSheetIndex(this);
          final PtgShifter shifter = new PtgShifter(sheetIndex, startRow, endRow, n, 0, maxcol, 0, SpreadsheetVersion.EXCEL2007);
          updateNamedRanges(wb, shifter);
        }

        return shiftedRanges;
  }
View Full Code Here
708
709
710
711
712
713
714
715
716
717
718
        // Update any formulas on this sheet that point to
        // columns which have been moved
        if (startCol <= endCol) {
          XSSFWorkbook book = getWorkbook();
          int sheetIndex = book.getSheetIndex(this);
          PtgShifter shifter = new PtgShifter(sheetIndex, 0, maxrow, 0, startCol, endCol, n, SpreadsheetVersion.EXCEL2007);
          updateNamedRanges(book, shifter);
        }
       
        return shiftedRanges;
    }
View Full Code Here
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
        // Update any formulas on this sheet that point to
        // columns which have been moved
        if (startCol <= endCol) {
          XSSFWorkbook book = getWorkbook();
          int sheetIndex = book.getSheetIndex(this);
          PtgShifter shifter = new PtgShifter(sheetIndex, 0, maxrow, 0, startCol, endCol, n, SpreadsheetVersion.EXCEL2007);
          updateNamedRanges(book, shifter);
        }
       
        return shiftedRanges;
    }
View Full Code Here
1132
1133
1134
1135
1136
1137
1138
1139
1140
1141
1142
        // Update any formulas on this sheet that point to
        // columns which have been moved
        if (tRow <= bRow && lCol <= rCol) {
          XSSFWorkbook book = getWorkbook();
          int sheetIndex = book.getSheetIndex(this);
          PtgShifter shifter = new PtgShifter(sheetIndex, tRow, bRow, nRow, lCol, rCol, nCol, SpreadsheetVersion.EXCEL2007);
          updateNamedRanges(book, shifter);
        }
       
        return shiftedRanges;
    }
View Full Code Here
280
281
282
283
284
285
286
287
288
289
290
        // Update any formulas on this sheet that point to
        //  rows which have been moved
        if (startRow <= endRow) {
          int sheetIndex = _workbook.getSheetIndex(this);
          short externSheetIndex = _book.checkExternSheet(sheetIndex, sheetIndex);
          PtgShifter shifter = new PtgShifter(externSheetIndex, startRow, endRow, n, 0, maxcol, 0, SpreadsheetVersion.EXCEL97);
          updateNamesAfterCellShift(shifter);
        }
       
        return shiftedRanges;
    }
View Full Code Here
448
449
450
451
452
453
454
455
456
457
458
        // Update any formulas on this sheet that point to
        // columns which have been moved
        if (startCol <= endCol) {
          int sheetIndex = _workbook.getSheetIndex(this);
          short externSheetIndex = _book.checkExternSheet(sheetIndex, sheetIndex);
          PtgShifter shifter = new PtgShifter(externSheetIndex, 0, SpreadsheetVersion.EXCEL97.getLastRowIndex(), 0, startCol, endCol, n, SpreadsheetVersion.EXCEL97);
          updateNamesAfterCellShift(shifter);
        }
       
        return shiftedRanges;
    }
View Full Code Here
627
628
629
630
631
632
633
634
635
636
637
        // Update any formulas on this sheet that point to
        // columns which have been moved
        if (startCol <= endCol) {
          int sheetIndex = _workbook.getSheetIndex(this);
          short externSheetIndex = _book.checkExternSheet(sheetIndex, sheetIndex);
          PtgShifter shifter = new PtgShifter(externSheetIndex, tRow, bRow, 0, startCol, endCol, n, SpreadsheetVersion.EXCEL97);
          updateNamesAfterCellShift(shifter);
        }
       
        return shiftedRanges;
    }
View Full Code Here
885
886
887
888
889
890
891
892
893
894
895
        // Update any formulas on this sheet that point to
        //  rows which have been moved
        if (startRow <= endRow) {
          int sheetIndex = _workbook.getSheetIndex(this);
          short externSheetIndex = _book.checkExternSheet(sheetIndex, sheetIndex);
          PtgShifter shifter = new PtgShifter(externSheetIndex, startRow, endRow, n, lCol, rCol, 0, SpreadsheetVersion.EXCEL97);
          updateNamesAfterCellShift(shifter);
        }
       
        return shiftedRanges;
    }
View Full Code Here
TOP

Related Classes of org.zkoss.poi.ss.formula.PtgShifter

  • org.zkoss.zss.model.impl.BookHelper
  • org.zkoss.zss.model.impl.HSSFSheetImpl
  • org.zkoss.zss.model.impl.XSSFSheetImpl
    • Copyright © 2018 www.massapicom. All rights reserved.
    All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.