Package org.apache.poi.ss.formula.EvaluationWorkbook

Examples of org.apache.poi.ss.formula.EvaluationWorkbook.ExternalSheet

360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
    return operation.evaluate(ops, srcRowNum, (short)srcColNum);
  }
  private SheetRefEvaluator createExternSheetRefEvaluator(EvaluationTracker tracker,
      ExternSheetReferenceToken ptg) {
    int externSheetIndex = ptg.getExternSheetIndex();
    ExternalSheet externalSheet = _workbook.getExternalSheet(externSheetIndex);
    if (externalSheet != null) {
      WorkbookEvaluator otherEvaluator = _collaboratingWorkbookEnvironment.getWorkbookEvaluator(externalSheet.getWorkbookName());
      EvaluationWorkbook otherBook = otherEvaluator._workbook;
      int otherSheetIndex = otherBook.getSheetIndex(externalSheet.getSheetName());
      return new SheetRefEvaluator(otherEvaluator, tracker, otherBook, otherSheetIndex);
    }
    int otherSheetIndex = _workbook.convertFromExternSheetIndex(externSheetIndex);
    return new SheetRefEvaluator(this, tracker, _workbook, otherSheetIndex);
View Full Code Here
1785
1786
1787
1788
1789
1790
1791
    public ExternalSheet getExternalSheet(int externSheetIndex) {
        String[] extNames = linkTable.getExternalBookAndSheetName(externSheetIndex);
        if (extNames == null) {
            return null;
        }
        return new ExternalSheet(extNames[0], extNames[1]);
    }
View Full Code Here
1817
1818
1819
1820
1821
1822
1823
    public ExternalSheet getExternalSheet(int externSheetIndex) {
        String[] extNames = linkTable.getExternalBookAndSheetName(externSheetIndex);
        if (extNames == null) {
            return null;
        }
        return new ExternalSheet(extNames[0], extNames[1]);
    }
View Full Code Here
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
  private ExternSheetNameResolver() {
    // no instances of this class
  }

  public static String prependSheetName(FormulaRenderingWorkbook book, int field_1_index_extern_sheet, String cellRefText) {
    ExternalSheet externalSheet = book.getExternalSheet(field_1_index_extern_sheet);
    StringBuffer sb;
    if (externalSheet != null) {
      String wbName = externalSheet.getWorkbookName();
      String sheetName = externalSheet.getSheetName();
      sb = new StringBuffer(wbName.length() + sheetName.length() + cellRefText.length() + 4);
      SheetNameFormatter.appendFormat(sb, wbName, sheetName);
    } else {
      String sheetName = book.getSheetNameByExternSheet(field_1_index_extern_sheet);
      sb = new StringBuffer(sheetName.length() + cellRefText.length() + 4);
View Full Code Here
1839
1840
1841
1842
1843
1844
1845
1846
1847
1848
        String[] extNames = linkTable.getExternalBookAndSheetName(externSheetIndex);
        if (extNames == null) {
            return null;
        }
        if (extNames.length == 2) {
            return new ExternalSheet(extNames[0], extNames[1]);
        } else {
            return new ExternalSheetRange(extNames[0], extNames[1], extNames[2]);
        }
    }
View Full Code Here
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
    return operation.evaluate(ops, srcRowNum, (short)srcColNum);
  }
  private SheetRefEvaluator createExternSheetRefEvaluator(EvaluationTracker tracker,
      ExternSheetReferenceToken ptg) {
    int externSheetIndex = ptg.getExternSheetIndex();
    ExternalSheet externalSheet = _workbook.getExternalSheet(externSheetIndex);
    if (externalSheet != null) {
      WorkbookEvaluator otherEvaluator = _collaboratingWorkbookEnvironment.getWorkbookEvaluator(externalSheet.getWorkbookName());
      EvaluationWorkbook otherBook = otherEvaluator._workbook;
      int otherSheetIndex = otherBook.getSheetIndex(externalSheet.getSheetName());
      return new SheetRefEvaluator(otherEvaluator, tracker, otherBook, otherSheetIndex);
    }
    int otherSheetIndex = _workbook.convertFromExternSheetIndex(externSheetIndex);
    return new SheetRefEvaluator(this, tracker, _workbook, otherSheetIndex);
View Full Code Here
1841
1842
1843
1844
1845
1846
1847
    public ExternalSheet getExternalSheet(int externSheetIndex) {
        String[] extNames = linkTable.getExternalBookAndSheetName(externSheetIndex);
        if (extNames == null) {
            return null;
        }
        return new ExternalSheet(extNames[0], extNames[1]);
    }
View Full Code Here
1764
1765
1766
1767
1768
1769
1770
    public ExternalSheet getExternalSheet(int externSheetIndex) {
        String[] extNames = linkTable.getExternalBookAndSheetName(externSheetIndex);
        if (extNames == null) {
            return null;
        }
        return new ExternalSheet(extNames[0], extNames[1]);
    }
View Full Code Here
TOP

Related Classes of org.apache.poi.ss.formula.EvaluationWorkbook.ExternalSheet

  • org.apache.poi.hssf.model.InternalWorkbook
  • org.apache.poi.hssf.model.Workbook
  • org.apache.poi.hssf.record.formula.ExternSheetNameResolver
  • org.apache.poi.ss.formula.OperationEvaluationContext
  • org.apache.poi.ss.formula.ptg.ExternSheetNameResolver
  • org.apache.poi.ss.formula.WorkbookEvaluator
    • 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.