Package org.apache.poi.ss.formula

Examples of org.apache.poi.ss.formula.FormulaShifter

2398
2399
2400
2401
2402
2403
2404
2405
2406
2407
2408
            }
        }
        XSSFRowShifter rowShifter = new XSSFRowShifter(this);

        int sheetIndex = getWorkbook().getSheetIndex(this);
        FormulaShifter shifter = FormulaShifter.createForRowShift(sheetIndex, startRow, endRow, n);

        rowShifter.updateNamedRanges(shifter);
        rowShifter.updateFormulas(shifter);
        rowShifter.shiftMerged(startRow, endRow, n);
        rowShifter.updateConditionalFormatting(shifter);
View Full Code Here
2374
2375
2376
2377
2378
2379
2380
2381
2382
2383
2384
            }
        }
        XSSFRowShifter rowShifter = new XSSFRowShifter(this);

        int sheetIndex = getWorkbook().getSheetIndex(this);
        FormulaShifter shifter = FormulaShifter.createForRowShift(sheetIndex, startRow, endRow, n);

        rowShifter.updateNamedRanges(shifter);
        rowShifter.updateFormulas(shifter);
        rowShifter.shiftMerged(startRow, endRow, n);
        rowShifter.updateConditionalFormatting(shifter);
View Full Code Here
1490
1491
1492
1493
1494
1495
1496
1497
1498
1499
1500
        // Update any formulas on this sheet that point to
        //  rows which have been moved
        int sheetIndex = _workbook.getSheetIndex(this);
        short externSheetIndex = _book.checkExternSheet(sheetIndex);
        FormulaShifter shifter = FormulaShifter.createForRowShift(externSheetIndex, startRow, endRow, n);
        _sheet.updateFormulasAfterCellShift(shifter, externSheetIndex);

        int nSheets = _workbook.getNumberOfSheets();
        for (int i = 0; i < nSheets; i++) {
            InternalSheet otherSheet = _workbook.getSheetAt(i).getSheet();
View Full Code Here
411
412
413
414
415
416
417
418
419
420
421
    public void setSheetOrder(String sheetname, int pos ) {
        int oldSheetIndex = getSheetIndex(sheetname);
        _sheets.add(pos,_sheets.remove(oldSheetIndex));
        workbook.setSheetOrder(sheetname, pos);

        FormulaShifter shifter = FormulaShifter.createForSheetShift(oldSheetIndex, pos);
        for (HSSFSheet sheet : _sheets) {
            sheet.getSheet().updateFormulasAfterCellShift(shifter, /* not used */ -1 );
        }

        workbook.updateNamesAfterCellShift(shifter);
View Full Code Here
TOP

Related Classes of org.apache.poi.ss.formula.FormulaShifter

  • org.apache.poi.hssf.model.TestSheet
  • org.apache.poi.hssf.usermodel.HSSFSheet
  • org.apache.poi.hssf.usermodel.HSSFWorkbook
  • org.apache.poi.ss.formula.ptg.Area3DPtg
  • org.apache.poi.ss.formula.ptg.Area3DPxg
  • org.apache.poi.ss.formula.ptg.AreaErrPtg
  • org.apache.poi.ss.formula.ptg.Deleted3DPxg
  • org.apache.poi.ss.formula.ptg.DeletedArea3DPtg
  • org.apache.poi.ss.formula.ptg.DeletedRef3DPtg
  • org.apache.poi.ss.formula.ptg.Ptg
    • 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.