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

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

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

org.apache.poi.hssf.record.formula.NumberPtg
Number Stores a floating point value in a formula value stored in a 8 byte field using IEEE notation @author Avik Sengupta @author Jason Height (jheight at chariot dot net dot au)

    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

    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

    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

        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

            String numberStr = number.toString();
            int intVal;
            try {
                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) {
            number.append(number1);
        }


        number.append('.');
        number.append(number2);


        if (exponent != null) {
            number.append('E');
            number.append(exponent);
        }


        return new NumberPtg(number.toString());
    }

View Full Code Here

    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

  private static Ptg[] convertDoubleFormula(String formula, Double value, HSSFSheet sheet) {
    if (formula == null) {
      if (value == null) {
        return Ptg.EMPTY_PTG_ARRAY;
      }
      return new Ptg[] { new NumberPtg(value.doubleValue()), };
    }
    if (value != null) {
      throw new IllegalStateException("Both formula and value cannot be present");
    }
        HSSFWorkbook wb = sheet.getWorkbook();

View Full Code Here

    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

  private static Ptg[] convertDoubleFormula(String formula, Double value, HSSFSheet sheet) {
    if (formula == null) {
      if (value == null) {
        return Ptg.EMPTY_PTG_ARRAY;
      }
      return new Ptg[] { new NumberPtg(value.doubleValue()), };
    }
    if (value != null) {
      throw new IllegalStateException("Both formula and value cannot be present");
    }
        HSSFWorkbook wb = sheet.getWorkbook();

View Full Code Here

        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

0 1 2

TOP

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

org.apache.poi.hssf.model.TestFormulaParser

org.apache.poi.hssf.usermodel.DVConstraint

org.apache.poi.ss.formula.FormulaParser

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.