Examples of Ref3DPtg

org.apache.poi.hssf.record.formula.Ref3DPtg
Title: Reference 3D Ptg
Description: Defined a cell in extern sheet.
REFERENCE:
@author Libin Roman (Vista Portal LDT. Developer) @author Jason Height (jheight at chariot dot net dot au) @version 1.0-pre
org.apache.poi.ss.formula.ptg.Ref3DPtg

Title: Reference 3D Ptg

Description: Defined a cell in extern sheet.

REFERENCE:

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 Ref3DPxg}

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

      }
      RefPtg rptg = (RefPtg)ptg;
      return rowMoveRefPtg(rptg);
    }
    if(ptg instanceof Ref3DPtg) {
      Ref3DPtg rptg = (Ref3DPtg)ptg;
      if (_externSheetIndex != rptg.getExternSheetIndex()) {
        // only move 3D refs that refer to the sheet with cells being moved
        // (currentExternSheetIx is irrelevant)
        return null;
      }
      return rowMoveRefPtg(rptg);

View Full Code Here

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

  }


    private Ptg adjustPtgDueToShiftMove(Ptg ptg) {
        Ptg updatedPtg = null;
        if(ptg instanceof Ref3DPtg) {
            Ref3DPtg ref = (Ref3DPtg)ptg;
            if(ref.getExternSheetIndex() == _srcSheetIndex){
                ref.setExternSheetIndex(_dstSheetIndex);
                updatedPtg = ref;
            } else if (ref.getExternSheetIndex() == _dstSheetIndex){
                ref.setExternSheetIndex(_srcSheetIndex);
                updatedPtg = ref;
            }
        }
        return updatedPtg;
    }

View Full Code Here

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

  private static Ptg createDeletedRef(Ptg ptg) {
    if (ptg instanceof RefPtg) {
      return new RefErrorPtg();
    }
    if (ptg instanceof Ref3DPtg) {
      Ref3DPtg rptg = (Ref3DPtg) ptg;
      return new DeletedRef3DPtg(rptg.getExternSheetIndex());
    }
    if (ptg instanceof AreaPtg) {
      return new AreaErrPtg();
    }
    if (ptg instanceof Area3DPtg) {

View Full Code Here

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

            if (ptg instanceof Area3DPtg) {
                Area3DPtg a3p = (Area3DPtg) ((OperandPtg) ptg).copy();
                a3p.setExternSheetIndex(newExtSheetIx);
                ptgs[i] = a3p;
            } else if (ptg instanceof Ref3DPtg) {
                Ref3DPtg r3p = (Ref3DPtg) ((OperandPtg) ptg).copy();
                r3p.setExternSheetIndex(newExtSheetIx);
                ptgs[i] = r3p;
            }
        }
        NameRecord newNameRecord = createBuiltInName(NameRecord.BUILTIN_FILTER_DB, newSheetIndex+1);
        newNameRecord.setNameDefinition(ptgs);

View Full Code Here

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

            if (evaluationName.getNameDefinition().length > 1) {
               throw new RuntimeException("Complex name formulas not supported yet");
            }
            Ptg ptg = evaluationName.getNameDefinition()[0];
            if(ptg instanceof Ref3DPtg){
               Ref3DPtg ref3D = (Ref3DPtg)ptg;
               int sheetIndex = refWorkbookEvaluator.getSheetIndexByExternIndex(ref3D.getExternSheetIndex());
               String sheetName = refWorkbookEvaluator.getSheetName(sheetIndex);
               SheetRefEvaluator sre = createExternSheetRefEvaluator(workbookName, sheetName);
               return new LazyRefEval(ref3D.getRow(), ref3D.getColumn(), sre);
            }else if(ptg instanceof Area3DPtg){
               Area3DPtg area3D = (Area3DPtg)ptg;
               int sheetIndex = refWorkbookEvaluator.getSheetIndexByExternIndex(area3D.getExternSheetIndex());
               String sheetName = refWorkbookEvaluator.getSheetName(sheetIndex);
               SheetRefEvaluator sre = createExternSheetRefEvaluator(workbookName, sheetName);

View Full Code Here

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

    //  all the ptgs give back the right things
    Ptg[] ptgs = fRecs[0].getParsedExpression();
    assertEquals(1, ptgs.length);
    assertTrue(ptgs[0] instanceof Ref3DPtg);


    Ref3DPtg ptg = (Ref3DPtg)ptgs[0];
    HSSFEvaluationWorkbook book = HSSFEvaluationWorkbook.create(stubHSSF);
    assertEquals("Sheet1!A1", ptg.toFormulaString(book));




    // Now check we get the right formula back for
    //  a few sample ones
    FormulaRecord fr;

View Full Code Here

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

            if (ptg instanceof Area3DPtg) {
                Area3DPtg a3p = (Area3DPtg) ((OperandPtg) ptg).copy();
                a3p.setExternSheetIndex(newExtSheetIx);
                ptgs[i] = a3p;
            } else if (ptg instanceof Ref3DPtg) {
                Ref3DPtg r3p = (Ref3DPtg) ((OperandPtg) ptg).copy();
                r3p.setExternSheetIndex(newExtSheetIx);
                ptgs[i] = r3p;
            }
        }
        NameRecord newNameRecord = createBuiltInName(NameRecord.BUILTIN_FILTER_DB, newSheetIndex+1);
        newNameRecord.setNameDefinition(ptgs);

View Full Code Here

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

    byte ptgSid = in.readByte();
    switch(ptgSid) {
      case AreaPtg.sid:   return new AreaPtg(in);
      case Area3DPtg.sid: return new Area3DPtg(in);
      case RefPtg.sid:  return new RefPtg(in);
      case Ref3DPtg.sid:  return new Ref3DPtg(in);
    }
    return null;
  }

View Full Code Here

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

        return _iBook.getExternalSheetIndex(workbookName, sheetName);
    }
    
    public Ptg get3DReferencePtg(CellReference cr, SheetIdentifier sheet) {
        int extIx = getSheetExtIx(sheet);
        return new Ref3DPtg(cr, extIx);
    }

View Full Code Here

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

                OperationEvaluationContext refWorkbookContext = new OperationEvaluationContext(
                        refWorkbookEvaluator, refWorkbookEvaluator.getWorkbook(), -1, -1, -1, _tracker);
                
                Ptg ptg = evaluationName.getNameDefinition()[0];
                if (ptg instanceof Ref3DPtg){
                    Ref3DPtg ref3D = (Ref3DPtg)ptg;
                    return refWorkbookContext.getRef3DEval(ref3D);
                } else if (ptg instanceof Ref3DPxg){
                    Ref3DPxg ref3D = (Ref3DPxg)ptg;
                    return refWorkbookContext.getRef3DEval(ref3D);
                } else if(ptg instanceof Area3DPtg){

View Full Code Here

0 1 2 3 4 5

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.