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

org.apache.poi.ss.formula.ptg.Ref3DPxg

Title: XSSF 3D Reference

Description: Defines a cell in an external or different sheet.

REFERENCE:

This is XSSF only, as it stores the sheet / book references in String form. The HSSF equivalent using indexes is {@link Ref3DPtg}

        return null;
      }
      return rowMoveRefPtg(rptg);
    }
    if(ptg instanceof Ref3DPxg) {
        Ref3DPxg rpxg = (Ref3DPxg)ptg;
        if (rpxg.getExternalWorkbookNumber() > 0 ||
               ! _sheetName.equals(rpxg.getSheetName())) {
                // only move 3D refs that refer to the sheet with cells being moved
            return null;
        }
            return rowMoveRefPtg(rpxg);
    }

View Full Code Here

    if (ptg instanceof Area3DPtg) {
      Area3DPtg area3DPtg = (Area3DPtg) ptg;
      return new DeletedArea3DPtg(area3DPtg.getExternSheetIndex());
    }
        if (ptg instanceof Ref3DPxg) {
            Ref3DPxg pxg = (Ref3DPxg)ptg;
            return new Deleted3DPxg(pxg.getExternalWorkbookNumber(), pxg.getSheetName());
        }
        if (ptg instanceof Area3DPxg) {
            Area3DPxg pxg = (Area3DPxg)ptg;
            return new Deleted3DPxg(pxg.getExternalWorkbookNumber(), pxg.getSheetName());
        }


    throw new IllegalArgumentException("Unexpected ref ptg class (" + ptg.getClass().getName() + ")");
  }

View Full Code Here

        }
  }
    public Ptg get3DReferencePtg(CellReference cell, SheetIdentifier sheet) {
        if (sheet._bookName != null) {
            int bookIndex = resolveBookIndex(sheet._bookName);
            return new Ref3DPxg(bookIndex, sheet, cell);
        } else {
            return new Ref3DPxg(sheet, cell);
        }
    }

View Full Code Here

                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){
                    Area3DPtg area3D = (Area3DPtg)ptg;
                    return refWorkbookContext.getArea3DEval(area3D);
                } else if(ptg instanceof Area3DPxg){

View Full Code Here

TOP

Related Classes of org.apache.poi.ss.formula.ptg.Ref3DPxg

org.apache.poi.ss.formula.FormulaShifter

org.apache.poi.ss.formula.OperationEvaluationContext

org.apache.poi.ss.util.CellReference

org.apache.poi.xssf.usermodel.XSSFEvaluationWorkbook

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.