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

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

706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
  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
733
734
735
736
737
738
739
740
741
742
743
  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
793
794
795
796
797
798
799
800
801
802
803
                intVal = Integer.parseInt(numberStr);
            } catch (NumberFormatException e) {
                return new NumberPtg(numberStr);
            }
            if (IntPtg.isInRange(intVal)) {
                return new IntPtg(intVal);
            }
            return new NumberPtg(numberStr);
        }

        if (number1 != null) {
View Full Code Here
728
729
730
731
732
733
734
735
736
737
738
  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
909
910
911
912
913
914
915
916
917
918
919
                intVal = Integer.parseInt(numberStr);
            } catch (NumberFormatException e) {
                return new NumberPtg(numberStr);
            }
            if (IntPtg.isInRange(intVal)) {
                return new IntPtg(intVal);
            }
            return new NumberPtg(numberStr);
        }

        if (number1 != null) {
View Full Code Here
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
    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
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
  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
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
    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
193
194
195
196
197
198
199
200
201
202
203
204
    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
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
    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
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.