Package org.pentaho.reporting.libraries.formula

Examples of org.pentaho.reporting.libraries.formula.FormulaContext

129
130
131
132
133
134
135
136
137
138
139
            GridBagConstraints.BOTH, new Insets(0, 0, 0, 0), 0, 0));
  }

  public void setFormulaContext(final FormulaContext formulaContext)
  {
    final FormulaContext old = this.formulaContext;
    this.formulaContext = formulaContext;
    if (formulaContext != null && formulaContext != old)
    {
      final DefaultComboBoxModel aModel = new DefaultComboBoxModel();
      aModel.addElement(null);
View Full Code Here
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
    return EMPTY_DATA;
  }

  public void testDateConversion1904 ()
  {
    final FormulaContext context = getContext();
    final Date januaryFirst1904 = DateUtil.createDate(1904, 1, 1, context.getLocalizationContext());
    final Date januaryFirst1900 = DateUtil.createDate(1900, 1, 1, context.getLocalizationContext());
    final Date marchFirst1904 = DateUtil.createDate(1904, 3, 1, context.getLocalizationContext());
    final Date marchFirst1900 = DateUtil.createDate(1900, 3, 1, context.getLocalizationContext());

    // these numbers must match whatever OpenOffice computes ..
    assertEqual(HSSFDateUtil.getExcelDate(januaryFirst1900, false, HSSFDateUtil.computeZeroDate("1904", false)), new BigDecimal(-1460));
    assertEqual(HSSFDateUtil.getExcelDate(marchFirst1900, false, HSSFDateUtil.computeZeroDate("1904", false)), new BigDecimal(-1401));
    assertEqual(HSSFDateUtil.getExcelDate(januaryFirst1904, false, HSSFDateUtil.computeZeroDate("1904", false)), new BigDecimal(0));
View Full Code Here
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
  }

  public void testDateConversion1900 ()
  {
    final FormulaContext context = getContext();
    final Date januaryFirst1904 = DateUtil.createDate(1904, 1, 1, context.getLocalizationContext());
    final Date januaryFirst1900 = DateUtil.createDate(1900, 1, 1, context.getLocalizationContext());
    final Date marchFirst1904 = DateUtil.createDate(1904, 3, 1, context.getLocalizationContext());
    final Date marchFirst1900 = DateUtil.createDate(1900, 3, 1, context.getLocalizationContext());

    // these numbers must match whatever OpenOffice computes ..
    assertEqual(HSSFDateUtil.getExcelDate(januaryFirst1900, false, HSSFDateUtil.computeZeroDate("1900", false)), new BigDecimal(0));
    assertEqual(HSSFDateUtil.getExcelDate(marchFirst1900, false, HSSFDateUtil.computeZeroDate("1900", false)), new BigDecimal(59));
    assertEqual(HSSFDateUtil.getExcelDate(januaryFirst1904, false, HSSFDateUtil.computeZeroDate("1900", false)), new BigDecimal(1460));
View Full Code Here
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
  }


  public void testDateConversion1899 ()
  {
    final FormulaContext context = getContext();
    final Date januaryFirst1904 = DateUtil.createDate(1904, 1, 1, context.getLocalizationContext());
    final Date januaryFirst1900 = DateUtil.createDate(1900, 1, 1, context.getLocalizationContext());
    final Date marchFirst1904 = DateUtil.createDate(1904, 3, 1, context.getLocalizationContext());
    final Date marchFirst1900 = DateUtil.createDate(1900, 3, 1, context.getLocalizationContext());

    // these numbers must match whatever OpenOffice computes ..
    assertEqual(HSSFDateUtil.getExcelDate(januaryFirst1900, false, HSSFDateUtil.computeZeroDate("1899", false)), new BigDecimal(2));
    assertEqual(HSSFDateUtil.getExcelDate(marchFirst1900, false, HSSFDateUtil.computeZeroDate("1899", false)), new BigDecimal(61));
    assertEqual(HSSFDateUtil.getExcelDate(januaryFirst1904, false, HSSFDateUtil.computeZeroDate("1899", false)), new BigDecimal(1462));
View Full Code Here
210
211
212
213
214
215
216
217
218
219
220
  }

  public TypeValuePair evaluate() throws EvaluationException
  {
    // First, grab the parameters and their types.
    final FormulaContext context = getContext();
    // And if everything is ok, compute the stuff ..
    if (function == null)
    {
      throw EvaluationException.getInstance(LibFormulaErrorValue.ERROR_INVALID_FUNCTION_VALUE);
    }
View Full Code Here
44
45
46
47
48
49
50
51
52
53
54
55
56
    setParsePosition(parsePosition);
  }

  public TypeValuePair evaluate() throws EvaluationException
  {
    final FormulaContext context = getContext();
    final Type type = context.resolveReferenceType(name);
    final Object value = context.resolveReference(name);
    if (value == null)
    {
      throw EvaluationException.getInstance(LibFormulaErrorValue.ERROR_NA_VALUE);
    }
    return new TypeValuePair(type, value);
View Full Code Here
58
59
60
61
62
63
64
65
66
67
68
69
  public Type getValueType()
  {
    try
    {
      final FormulaContext context = getContext();
      return context.resolveReferenceType(name);
    }
    catch (final EvaluationException evalex)
    {
      // exception ignored.
      return ErrorType.TYPE;
View Full Code Here
324
325
326
327
328
329
330
331
332
333
334
  private Trans prepareTransformation(final DataRow parameters,
                                      final DataFactoryContext context,
                                      final TransMeta transMeta) throws EvaluationException, ParseException, KettleException
  {
    final FormulaContext formulaContext = new WrappingFormulaContext(context.getFormulaContext(), parameters);
    final String[] params = fillArguments(formulaContext);

    final Trans trans = new Trans(transMeta);
    trans.setArguments(params);
    updateTransformationParameter(formulaContext, trans);
View Full Code Here
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
    return EMPTY_DATA;
  }

  public void testDateConversion1904 ()
  {
    final FormulaContext context = getContext();
    final Date januaryFirst1904 = DateUtil.createDate(1904, 1, 1, context.getLocalizationContext());
    final Date januaryFirst1900 = DateUtil.createDate(1900, 1, 1, context.getLocalizationContext());
    final Date marchFirst1904 = DateUtil.createDate(1904, 3, 1, context.getLocalizationContext());
    final Date marchFirst1900 = DateUtil.createDate(1900, 3, 1, context.getLocalizationContext());

    // these numbers must match whatever OpenOffice computes ..
    assertEqual(HSSFDateUtil.getExcelDate(januaryFirst1900, false, HSSFDateUtil.computeZeroDate("1904", false)), new BigDecimal(-1460));
    assertEqual(HSSFDateUtil.getExcelDate(marchFirst1900, false, HSSFDateUtil.computeZeroDate("1904", false)), new BigDecimal(-1401));
    assertEqual(HSSFDateUtil.getExcelDate(januaryFirst1904, false, HSSFDateUtil.computeZeroDate("1904", false)), new BigDecimal(0));
View Full Code Here
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
  }

  public void testDateConversion1900 ()
  {
    final FormulaContext context = getContext();
    final Date januaryFirst1904 = DateUtil.createDate(1904, 1, 1, context.getLocalizationContext());
    final Date januaryFirst1900 = DateUtil.createDate(1900, 1, 1, context.getLocalizationContext());
    final Date marchFirst1904 = DateUtil.createDate(1904, 3, 1, context.getLocalizationContext());
    final Date marchFirst1900 = DateUtil.createDate(1900, 3, 1, context.getLocalizationContext());

    // these numbers must match whatever OpenOffice computes ..
    assertEqual(HSSFDateUtil.getExcelDate(januaryFirst1900, false, HSSFDateUtil.computeZeroDate("1900", false)), new BigDecimal(0));
    assertEqual(HSSFDateUtil.getExcelDate(marchFirst1900, false, HSSFDateUtil.computeZeroDate("1900", false)), new BigDecimal(59));
    assertEqual(HSSFDateUtil.getExcelDate(januaryFirst1904, false, HSSFDateUtil.computeZeroDate("1900", false)), new BigDecimal(1460));
View Full Code Here
TOP

Related Classes of org.pentaho.reporting.libraries.formula.FormulaContext

  • org.pentaho.openformula.ui.FunctionListPanel
  • org.pentaho.reporting.engine.classic.extensions.datasources.kettle.AbstractKettleTransformationProducer
  • org.pentaho.reporting.libraries.formula.lvalues.ContextLookup
  • org.pentaho.reporting.libraries.formula.lvalues.FormulaFunction
  • org.pentaho.reporting.libraries.formula.typing.DateConversionTest
    • 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.