Examples of org.apache.poi.hssf.record.formula.Ptg

Package org.apache.poi.hssf.record.formula

Examples of org.apache.poi.hssf.record.formula.Ptg

org.apache.poi.hssf.record.formula.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)

    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

   */
  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

     * @param ref area reference
     */
    public void setAreaReference(String ref){
        //Trying to find if what ptg do we need
        RangeAddress ra = new RangeAddress(ref);
        Ptg oldPtg;
        Ptg ptg;


        if (field_13_name_definition==null ||field_13_name_definition.isEmpty()){
            field_13_name_definition = new Stack();
            oldPtg = createNewPtg();
        } else {

View Full Code Here

        Stack stack = new Stack();
        int   pos           = start_of_expression + offset;
        int   sizeCounter   = 0;
        try {
            while (sizeCounter < size) {
                Ptg ptg = Ptg.createPtg(data, pos);


                pos += ptg.getSize();
                sizeCounter += ptg.getSize();
                stack.push(ptg);
            }
        } catch (java.lang.UnsupportedOperationException uoe) {
            System.err.println("[WARNING] Unknown Ptg "
                    + uoe.getMessage() );

View Full Code Here


    private void serializePtgs(byte [] data, int offset) {
        int pos = offset;


        for (int k = 0; k < field_13_name_definition.size(); k++) {
            Ptg ptg = ( Ptg ) field_13_name_definition.get(k);


            ptg.writeBytes(data, pos);
            pos += ptg.getSize();
        }
    }

View Full Code Here

    /** gets the extern sheet number
     * @return extern sheet index
     */
    public short getExternSheetNumber(){
        if (field_13_name_definition == null) return 0;
        Ptg ptg = (Ptg) field_13_name_definition.peek();
        short result = 0;


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


        } else if (ptg.getClass() == Ref3DPtg.class){
            result = ((Ref3DPtg) ptg).getExternSheetIndex();
        }


        return result;
    }

View Full Code Here


    /** sets the extern sheet number
     * @param externSheetNumber extern sheet number
     */
    public void setExternSheetNumber(short externSheetNumber){
        Ptg ptg;


        if (field_13_name_definition == null || field_13_name_definition.isEmpty()){
            field_13_name_definition = new Stack();
            ptg = createNewPtg();
        } else {
            ptg = (Ptg) field_13_name_definition.peek();
        }


        if (ptg.getClass() == Area3DPtg.class){
            ((Area3DPtg) ptg).setExternSheetIndex(externSheetNumber);


        } else if (ptg.getClass() == Ref3DPtg.class){
            ((Ref3DPtg) ptg).setExternSheetIndex(externSheetNumber);
        }


    }

View Full Code Here

        }


    }


    private Ptg createNewPtg(){
        Ptg ptg = new Area3DPtg();
        field_13_name_definition.push(ptg);


        return ptg;
    }

View Full Code Here

    /** gets the reference , the area only (range)
     * @return area reference
     */
    public String getAreaReference(){
        if (field_13_name_definition == null) return "#REF!";
        Ptg ptg = (Ptg) field_13_name_definition.peek();
        String result = "";


        if (ptg.getClass() == Area3DPtg.class){
            result = ((Area3DPtg) ptg).getArea();


        } else if (ptg.getClass() == Ref3DPtg.class){
            result = ((Ref3DPtg) ptg).getArea();
        }


        return result;
    }

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

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.apache.poi.hssf.record.formula.Ptg

org.apache.poi.hssf.dev.FormulaViewer

org.apache.poi.hssf.model.OperandClassTransformer

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.