Examples of NameXPtg

org.apache.poi.hssf.record.formula.NameXPtg
@author aviks
org.apache.poi.ss.formula.ptg.NameXPtg
A Name, be that a Named Range or a Function / User Defined Function, addressed in the HSSF External Sheet style.
This is HSSF only, as it matches the HSSF file format way of referring to the sheet by an extern index. The XSSF equivalent is {@link NameXPxg}

Examples of org.apache.poi.ss.formula.ptg.NameXPtg


  public NameXPtg getNameXPtg(String name) {
        IndexedUDFFinder udfFinder = (IndexedUDFFinder)getUDFFinder();
        FreeRefFunction func = udfFinder.findFunction(name);
    if(func == null) return null;
        else return new NameXPtg(0, udfFinder.getFunctionIndex(name));
  }

View Full Code Here

Examples of org.apache.poi.ss.formula.ptg.NameXPtg


  public NameXPtg getNameXPtg(String name) {
        IndexedUDFFinder udfFinder = (IndexedUDFFinder)getUDFFinder();
        FreeRefFunction func = udfFinder.findFunction(name);
    if(func == null) return null;
        else return new NameXPtg(0, udfFinder.getFunctionIndex(name));
  }

View Full Code Here

Examples of org.apache.poi.ss.formula.ptg.NameXPtg

     * @param udf  locator of user-defiend functions to resolve names of VBA and Add-In functions
     * @return the external name or null
     */
    public NameXPtg getNameXPtg(String name, int sheetRefIndex, UDFFinder udf) {
        LinkTable lnk = getOrCreateLinkTable();
        NameXPtg xptg = lnk.getNameXPtg(name, sheetRefIndex);


        if(xptg == null && udf.findFunction(name) != null) {
            // the name was not found in the list of external names
            // check if the Workbook's UDFFinder is aware about it and register the name if it is
            xptg = lnk.addNameXPtg(name);

View Full Code Here

Examples of org.apache.poi.ss.formula.ptg.NameXPtg

      // Found one
      int thisSheetRefIndex = findRefIndexFromExtBookIndex(i);
      if (thisSheetRefIndex >= 0) {
          // Check for the sheet index match, if requested
          if (sheetRefIndex == -1 || thisSheetRefIndex == sheetRefIndex) {
              return new NameXPtg(thisSheetRefIndex, definedNameIndex);
          }
      }
    }
    return null;
  }

View Full Code Here

Examples of org.apache.poi.ss.formula.ptg.NameXPtg

        int numberOfNames = extBlock.getNumberOfNames();
        // a new name is inserted in the end of the SupBookRecord, after the last name
        _workbookRecordList.add(supLinkIndex + numberOfNames, extNameRecord);
        int fakeSheetIdx = -2; /* the scope is workbook*/
        int ix = _externSheetRecord.getRefIxForSheet(extBlockIndex, fakeSheetIdx, fakeSheetIdx);
        return new NameXPtg(ix, nameIndex);
    }

View Full Code Here

Examples of org.apache.poi.ss.formula.ptg.NameXPtg

     * @param udf  locator of user-defiend functions to resolve names of VBA and Add-In functions
     * @return the external name or null
     */
    public NameXPtg getNameXPtg(String name, UDFFinder udf) {
        LinkTable lnk = getOrCreateLinkTable();
        NameXPtg xptg = lnk.getNameXPtg(name);


        if(xptg == null && udf.findFunction(name) != null) {
            // the name was not found in the list of external names
            // check if the Workbook's UDFFinder is aware about it and register the name if it is
            xptg = lnk.addNameXPtg(name);

View Full Code Here

0 1 2

TOP

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.