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

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

138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
    FormulaParser fp = new FormulaParser(simpleif, null);
    fp.parse();
    Ptg[] asts = fp.getRPNPtg();
    assertEquals(9, asts.length);
   
    IntPtg op1 = (IntPtg) asts[0];
    IntPtg op2 = (IntPtg) asts[1];
    EqualPtg eq = (EqualPtg) asts[2];   
    AttrPtg ifPtg = (AttrPtg) asts[3];
    IntPtg res1 = (IntPtg) asts[4];
       
    AttrPtg ptgGoto= (AttrPtg) asts[5];   
    assertEquals("Goto 1 Length", (short)10, ptgGoto.getData());
   
    IntPtg res2 = (IntPtg) asts[6];   
    AttrPtg ptgGoto2 = (AttrPtg) asts[7];   
    assertEquals("Goto 2 Length", (short)3, ptgGoto2.getData());
   
    assertEquals("If FALSE offset", (short)7, ifPtg.getData());
   
View Full Code Here
192
193
194
195
196
197
198
199
200
201
202
203
    assertTrue("IF Attr set correctly", (asts[3] instanceof AttrPtg));
    AttrPtg ifFunc = (AttrPtg)asts[3];
    assertTrue("It is not an if", ifFunc.isOptimizedIf());
   
    assertTrue("Single Value is not an IntPtg", (asts[4] instanceof IntPtg));
    IntPtg intPtg = (IntPtg)asts[4];
    assertEquals("Result", (short)10, intPtg.getValue());
   
    assertTrue("Ptg is not a Variable Function", (asts[6] instanceof FuncVarPtg));
    FuncVarPtg funcPtg = (FuncVarPtg)asts[6];
    assertEquals("Arguments", 2, funcPtg.getNumberOfOperands());
   
View Full Code Here
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
    assertEquals(ptgClass, result.getClass());
    return result;
  }

  public void testParseNumber() {
    IntPtg ip;

    // bug 33160
    ip = (IntPtg) parseSingleToken("40", IntPtg.class);
    assertEquals(40, ip.getValue());
    ip = (IntPtg) parseSingleToken("40000", IntPtg.class);
    assertEquals(40000, ip.getValue());

    // check the upper edge of the IntPtg range:
    ip = (IntPtg) parseSingleToken("65535", IntPtg.class);
    assertEquals(65535, ip.getValue());
    NumberPtg np = (NumberPtg) parseSingleToken("65536", NumberPtg.class);
    assertEquals(65536, np.getValue(), 0);

    np = (NumberPtg) parseSingleToken("65534.6", NumberPtg.class);
    assertEquals(65534.6, np.getValue(), 0);
View Full Code Here
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
  public void testSpaceAtStartOfFormula() {
    // Simulating cell formula of "= 4" (note space)
    // The same Ptg array can be observed if an excel file is saved with that exact formula

    AttrPtg spacePtg = AttrPtg.createSpace(AttrPtg.SpaceType.SPACE_BEFORE, 1);
    Ptg[] ptgs = { spacePtg, new IntPtg(4), };
    String formulaString;
    try {
      formulaString = FormulaParser.toFormulaString(null, ptgs);
    } catch (IllegalStateException e) {
      if(e.getMessage().equalsIgnoreCase("too much stuff left on the stack")) {
        throw new AssertionFailedError("Identified bug 44609");
      }
      // else some unexpected error
      throw e;
    }
    // FormulaParser strips spaces anyway
    assertEquals("4", formulaString);

    ptgs = new Ptg[] { new IntPtg(3), spacePtg, new IntPtg(4), spacePtg, AddPtg.instance, };
    formulaString = FormulaParser.toFormulaString(null, ptgs);
    assertEquals("3+4", formulaString);
  }
View Full Code Here
707
708
709
710
711
712
713
714
715
716
717
  public void testTooFewOperandArgs() {
    // Simulating badly encoded cell formula of "=/1"
    // Not sure if Excel could ever produce this
    Ptg[] ptgs = {
        // Excel would probably have put tMissArg here
        new IntPtg(1),
        DividePtg.instance,
    };
    try {
      FormulaParser.toFormulaString(null, ptgs);
      fail("Expected exception was not thrown");
View Full Code Here
211
212
213
214
215
216
217
218
219
220
221
222
  private static void confirmUnary(String formulaText, double val, Class<?>...expectedTokenTypes) {
    Ptg[] ptgs = parseFormula(formulaText);
    confirmTokenClasses(ptgs, expectedTokenTypes);
    Ptg ptg0 = ptgs[0];
    if (ptg0 instanceof IntPtg) {
      IntPtg intPtg = (IntPtg) ptg0;
      assertEquals((int)val, intPtg.getValue());
    } else if (ptg0 instanceof NumberPtg) {
      NumberPtg numberPtg = (NumberPtg) ptg0;
      assertEquals(val, numberPtg.getValue(), 0.0);
    } else {
      fail("bad ptg0 " + ptg0);
View Full Code Here
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
    assertEquals(ptgClass, result.getClass());
    return result;
  }

  public void testParseNumber() {
    IntPtg ip;

    // bug 33160
    ip = (IntPtg) parseSingleToken("40", IntPtg.class);
    assertEquals(40, ip.getValue());
    ip = (IntPtg) parseSingleToken("40000", IntPtg.class);
    assertEquals(40000, ip.getValue());

    // check the upper edge of the IntPtg range:
    ip = (IntPtg) parseSingleToken("65535", IntPtg.class);
    assertEquals(65535, ip.getValue());
    NumberPtg np = (NumberPtg) parseSingleToken("65536", NumberPtg.class);
    assertEquals(65536, np.getValue(), 0);

    np = (NumberPtg) parseSingleToken("65534.6", NumberPtg.class);
    assertEquals(65534.6, np.getValue(), 0);
View Full Code Here
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
  public void testSpaceAtStartOfFormula() {
    // Simulating cell formula of "= 4" (note space)
    // The same Ptg array can be observed if an excel file is saved with that exact formula

    AttrPtg spacePtg = AttrPtg.createSpace(AttrPtg.SpaceType.SPACE_BEFORE, 1);
    Ptg[] ptgs = { spacePtg, new IntPtg(4), };
    String formulaString;
    try {
      formulaString = toFormulaString(ptgs);
    } catch (IllegalStateException e) {
      if(e.getMessage().equalsIgnoreCase("too much stuff left on the stack")) {
        throw new AssertionFailedError("Identified bug 44609");
      }
      // else some unexpected error
      throw e;
    }
    // FormulaParser strips spaces anyway
    assertEquals("4", formulaString);

    ptgs = new Ptg[] { new IntPtg(3), spacePtg, new IntPtg(4), spacePtg, AddPtg.instance, };
    formulaString = toFormulaString(ptgs);
    assertEquals("3+4", formulaString);
  }
View Full Code Here
684
685
686
687
688
689
690
691
692
693
694
  public void testTooFewOperandArgs() {
    // Simulating badly encoded cell formula of "=/1"
    // Not sure if Excel could ever produce this
    Ptg[] ptgs = {
        // Excel would probably have put tMissArg here
        new IntPtg(1),
        DividePtg.instance,
    };
    try {
      toFormulaString(ptgs);
      fail("Expected exception was not thrown");
View Full Code Here
57
58
59
60
61
62
63
64
65
66
67
   * the whole formula which converts tAttrSum to tFuncVar("SUM") )
   */
  public void testAttrSum() {

    Ptg[] ptgs = {
      new IntPtg(42),
      AttrPtg.SUM,
    };

    ValueEval result = evaluateFormula(ptgs);
    assertEquals(42, ((NumberEval)result).getNumberValue(), 0.0);
View Full Code Here
TOP

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

  • org.apache.poi.hssf.model.TestFormulaParser
  • org.apache.poi.hssf.model.TestFormulaParserIf
  • org.apache.poi.hssf.record.formula.eval.TestRangeEval
  • org.apache.poi.ss.formula.FormulaParser
  • org.apache.poi.ss.formula.TestWorkbookEvaluator
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.