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

org.apache.poi.ss.formula.ptg.Ptg
Ptg represents a syntactic token in a formula. 'PTG' is an acronym for 'parse thing'. Originally, the name referred to the single byte identifier at the start of the token, but in POI, Ptg encapsulates the whole formula token (initial byte + value data).
Ptgs are logically arranged in a tree representing the structure of the parsed formula. However, in BIFF files Ptgs are written/read in Reverse-Polish Notation order. The RPN ordering also simplifies formula evaluation logic, so POI mostly accesses Ptgs in the same way. @author andy @author avik @author Jason Height (jheight at chariot dot net dot au)

            NameRecord origNameRecord = workbook.getNameRecord(filterDbNameIndex);
            // copy original formula but adjust 3D refs to the new external sheet index
            int newExtSheetIx = workbook.checkExternSheet(newSheetIndex);
            Ptg[] ptgs = origNameRecord.getNameDefinition();
            for (int i=0; i< ptgs.length; i++) {
                Ptg ptg = ptgs[i];


                if (ptg instanceof Area3DPtg) {
                    Area3DPtg a3p = (Area3DPtg) ((OperandPtg) ptg).copy();
                    a3p.setExternSheetIndex(newExtSheetIx);
                    ptgs[i] = a3p;

View Full Code Here

    sb.append(" options=").append(HexDump.shortToHex(_options)).append("\n");
    sb.append(" notUsed=").append(HexDump.intToHex(_field3notUsed)).append("\n");
    sb.append(" formula:").append("\n");
    Ptg[] ptgs = _formula.getTokens();
    for (int i = 0; i < ptgs.length; i++) {
      Ptg ptg = ptgs[i];
      sb.append(ptg.toString()).append(ptg.getRVAType()).append("\n");
    }
    sb.append("]");
    return sb.toString();
  }

View Full Code Here

    for (int k = 0; k < ptgs.length; k++ ) {
      if (k>0) {
        sb.append("\n");
      }
      sb.append("    Ptg[").append(k).append("]=");
      Ptg ptg = ptgs[k];
      sb.append(ptg.toString()).append(ptg.getRVAType());
    }
  }

View Full Code Here

    Ptg[] ptgs = { aptg, };
    
    if (!shifter.adjustFormula(ptgs, currentExternSheetIx)) {
      return cra;
    }
    Ptg ptg0 = ptgs[0];
    if (ptg0 instanceof AreaPtg) {
      AreaPtg bptg = (AreaPtg) ptg0;
      return new CellRangeAddress(bptg.getFirstRow(), bptg.getLastRow(), bptg.getFirstColumn(), bptg.getLastColumn());
    }
    if (ptg0 instanceof AreaErrPtg) {
      return null;
    }
    throw new IllegalStateException("Unexpected shifted ptg class (" + ptg0.getClass().getName() + ")");
  }

View Full Code Here

        NameRecord origNameRecord = getNameRecord(filterDbNameIndex);
        // copy original formula but adjust 3D refs to the new external sheet index
        int newExtSheetIx = checkExternSheet(newSheetIndex);
        Ptg[] ptgs = origNameRecord.getNameDefinition();
        for (int i=0; i< ptgs.length; i++) {
            Ptg ptg = ptgs[i];


            if (ptg instanceof Area3DPtg) {
                Area3DPtg a3p = (Area3DPtg) ((OperandPtg) ptg).copy();
                a3p.setExternSheetIndex(newExtSheetIx);
                ptgs[i] = a3p;

View Full Code Here

   * abnormally-set 'shared formula' flags.
   * (see TestValueRecordsAggregate.testSpuriousSharedFormulaFlag()).<p/>
   */
  private static void handleMissingSharedFormulaRecord(FormulaRecord formula) {
    // make sure 'unshared' formula is actually available
    Ptg firstToken = formula.getParsedExpression()[0];
    if (firstToken instanceof ExpPtg) {
      throw new RecordFormatException(
          "SharedFormulaRecord not found for FormulaRecord with (isSharedFormula=true)");
    }
    // could log an info message here since this is a fairly unusual occurrence.

View Full Code Here

   */
  public int getExternSheetNumber(){
    if (field_13_name_definition.getEncodedSize() < 1) {
      return 0;
    }
    Ptg ptg = field_13_name_definition.getTokens()[0];


    if (ptg.getClass() == Area3DPtg.class){
      return ((Area3DPtg) ptg).getExternSheetIndex();


    }
    if (ptg.getClass() == Ref3DPtg.class){
      return ((Ref3DPtg) ptg).getExternSheetIndex();
    }
    return 0;
  }

View Full Code Here

    sb.append("    .NameIsMultibyte        = ").append(field_11_nameIsMultibyte).append("\n");
    sb.append("    .Name (Unicode text)    = ").append( getNameText() ).append("\n");
    Ptg[] ptgs = field_13_name_definition.getTokens();
    sb.append("    .Formula (nTokens=").append(ptgs.length).append("):") .append("\n");
    for (int i = 0; i < ptgs.length; i++) {
      Ptg ptg = ptgs[i];
      sb.append("       " + ptg.toString()).append(ptg.getRVAType()).append("\n");
    }


    sb.append("    .Menu text       = ").append(field_14_custom_menu_text).append("\n");
    sb.append("    .Description text= ").append(field_15_description_text).append("\n");
    sb.append("    .Help topic text = ").append(field_16_help_topic_text).append("\n");

View Full Code Here

        Ptg[] ptgs = { aptg, };


        if (!shifter.adjustFormula(ptgs, currentExternSheetIx)) {
            return cra;
        }
        Ptg ptg0 = ptgs[0];
        if (ptg0 instanceof AreaPtg) {
            AreaPtg bptg = (AreaPtg) ptg0;
            return new CellRangeAddress(bptg.getFirstRow(), bptg.getLastRow(), bptg.getFirstColumn(), bptg.getLastColumn());
        }
        if (ptg0 instanceof AreaErrPtg) {
            return null;
        }
        throw new IllegalStateException("Unexpected shifted ptg class (" + ptg0.getClass().getName() + ")");
    }

View Full Code Here

        buffer.append("    .customNumberFormat   = ").append(isCustomNumberFormat()).append('\n');
        buffer.append("    .indexNumberFmtRecord = ").append(HexDump.shortToHex(getIndexNumberFmtRecord())).append('\n');
        buffer.append("    .formulaOfLink        = ").append('\n');
        Ptg[] ptgs = field_5_formulaOfLink.getTokens();
        for (int i = 0; i < ptgs.length; i++) {
            Ptg ptg = ptgs[i];
            buffer.append(ptg.toString()).append(ptg.getRVAType()).append('\n');
        }


        buffer.append("[/AI]\n");
        return buffer.toString();
    }

View Full Code Here

0 1 2 3 4 5 6

TOP

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

org.apache.poi.hssf.dev.FormulaViewer

org.apache.poi.hssf.model.InternalWorkbook

org.apache.poi.hssf.model.TestFormulaParser

org.apache.poi.hssf.model.TestFormulaParserIf

org.apache.poi.hssf.model.TestOperandClassTransformer

org.apache.poi.hssf.model.TestRVA

org.apache.poi.hssf.record.aggregates.CFRecordsAggregate

org.apache.poi.hssf.record.aggregates.FormulaRecordAggregate

org.apache.poi.hssf.record.ArrayRecord

org.apache.poi.hssf.record.chart.LinkedDataRecord

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.