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

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

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

org.apache.poi.hssf.record.formula.ArrayPtg
ArrayPtg - handles arrays The ArrayPtg is a little weird, the size of the Ptg when parsing initially only includes the Ptg sid and the reserved bytes. The next Ptg in the expression then follows. It is only after the "size" of all the Ptgs is met, that the ArrayPtg data is actually held after this. So Ptg.createParsedExpression keeps track of the number of ArrayPtg elements and need to parse the data upto the FORMULA record size. @author Jason Height (jheight at chariot dot net dot au)

    Ptg[] ptgs;
    ptgs = parseFormula("mode({1,2,2,#REF!;FALSE,3,3,2})");
    confirmTokenClasses(ptgs, ArrayPtg.class, FuncVarPtg.class);
    assertEquals("{1.0,2.0,2.0,#REF!;FALSE,3.0,3.0,2.0}", ptgs[0].toFormulaString());


    ArrayPtg aptg = (ArrayPtg) ptgs[0];
    Object[][] values = aptg.getTokenArrayValues();
    assertEquals(ErrorConstant.valueOf(HSSFErrorConstants.ERROR_REF), values[0][3]);
    assertEquals(Boolean.FALSE, values[1][0]);
  }

View Full Code Here

        Object[][] values2d = new Object[nRows][];
        rowsData.toArray(values2d);
        int nColumns = values2d[0].length;
        checkRowLengths(values2d, nColumns);


        return new ParseNode(new ArrayPtg(values2d));
    }

View Full Code Here

    assertEquals(2, ptgs.length);
    Ptg ptg0 = ptgs[0];
    assertEquals(ArrayPtg.class, ptg0.getClass());
    assertEquals("{1.0,2.0,2.0,#REF!;FALSE,3.0,3.0,2.0}", ptg0.toFormulaString());


    ArrayPtg aptg = (ArrayPtg) ptg0;
    Object[][] values = aptg.getTokenArrayValues();
    assertEquals(ErrorConstant.valueOf(HSSFErrorConstants.ERROR_REF), values[0][3]);
    assertEquals(Boolean.FALSE, values[1][0]);
  }

View Full Code Here

    assertEquals(2, ptgs.length);
    Ptg ptg0 = ptgs[0];
    assertEquals(ArrayPtg.class, ptg0.getClass());
    assertEquals("{1.0,2.0,2.0,#REF!;FALSE,3.0,3.0,2.0}", ptg0.toFormulaString());


    ArrayPtg aptg = (ArrayPtg) ptg0;
    Object[][] values = aptg.getTokenArrayValues();
    assertEquals(ErrorConstant.valueOf(HSSFErrorConstants.ERROR_REF), values[0][3]);
    assertEquals(Boolean.FALSE, values[1][0]);
  }

View Full Code Here

        Object[][] values2d = new Object[nRows][];
        rowsData.toArray(values2d);
        int nColumns = values2d[0].length;
        checkRowLengths(values2d, nColumns);


        return new ParseNode(new ArrayPtg(values2d));
    }

View Full Code Here

    assertEquals(2, ptgs.length);
    Ptg ptg0 = ptgs[0];
    assertEquals(ArrayPtg.class, ptg0.getClass());
    assertEquals("{1.0,2.0,2.0,#REF!;FALSE,3.0,3.0,2.0}", ptg0.toFormulaString());


    ArrayPtg aptg = (ArrayPtg) ptg0;
    Object[][] values = aptg.getTokenArrayValues();
    assertEquals(ErrorConstant.valueOf(HSSFErrorConstants.ERROR_REF), values[0][3]);
    assertEquals(Boolean.FALSE, values[1][0]);
  }

View Full Code Here

    Ptg[] ptgs;
    ptgs = parseFormula("mode({1,2,2,#REF!;FALSE,3,3,2})");
    confirmTokenClasses(ptgs, ArrayPtg.class, FuncVarPtg.class);
    assertEquals("{1,2,2,#REF!;FALSE,3,3,2}", ptgs[0].toFormulaString());


    ArrayPtg aptg = (ArrayPtg) ptgs[0];
    Object[][] values = aptg.getTokenArrayValues();
    assertEquals(ErrorConstant.valueOf(HSSFErrorConstants.ERROR_REF), values[0][3]);
    assertEquals(Boolean.FALSE, values[1][0]);
  }

View Full Code Here

    Ptg[] ptgs;
    ptgs = parseFormula("mode({1,2,2,#REF!;FALSE,3,3,2})");
    confirmTokenClasses(ptgs, ArrayPtg.class, FuncVarPtg.class);
    assertEquals("{1,2,2,#REF!;FALSE,3,3,2}", ptgs[0].toFormulaString());


    ArrayPtg aptg = (ArrayPtg) ptgs[0];
    Object[][] values = aptg.getTokenArrayValues();
    assertEquals(ErrorConstant.valueOf(HSSFErrorConstants.ERROR_REF), values[0][3]);
    assertEquals(Boolean.FALSE, values[1][0]);
  }

View Full Code Here

        Object[][] values2d = new Object[nRows][];
        rowsData.toArray(values2d);
        int nColumns = values2d[0].length;
        checkRowLengths(values2d, nColumns);


        return new ParseNode(new ArrayPtg(values2d));
    }

View Full Code Here

        Object[][] values2d = new Object[nRows][];
        rowsData.toArray(values2d);
        int nColumns = values2d[0].length;
        checkRowLengths(values2d, nColumns);


        return new ParseNode(new ArrayPtg(values2d));
    }

View Full Code Here

0 1

TOP

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

org.apache.poi.hssf.model.TestFormulaParser

org.apache.poi.hssf.record.UnicodeString

org.apache.poi.ss.formula.FormulaParser

org.apache.poi.hssf.record.RecordFormatException

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.