public Number evaluate( final Number number1, final Number number2 ) throws EvaluationException { final BigDecimal bd1 = NumberUtil.getAsBigDecimal( number1 ); final BigDecimal bd2 = NumberUtil.getAsBigDecimal( number2 ); return NumberUtil.divide( bd1, bd2 ); }
/** * Converts a <code>Date</code> value according to the requested <code>Type</code> to the proper <code>Date</code> * subclasses (<code>java.sql.Time</code>, <code>java.sql.Date</code>) if needed. If the requested type is unknown, no * conversion takes place and the input date is returned. * * @param fromDate The date to convert. * @param toType The requested type of date. * @return The converted date. */ public static Date normalizeDate( final Date fromDate, final Type toType ) { return normalizeDate( fromDate, toType, true ); }
public static String extractStaticTextFromFormula(final String formula) { if (formula == null) { return null; } final String formulaFragment = extractFormula(formula); return extractStaticTextFromFormulaFragment(formulaFragment); }
public Date convertToDate( final Type type1, final Object value ) throws EvaluationException { if ( type1.isFlagSet( Type.NUMERIC_TYPE ) || type1.isFlagSet( Type.ANY_TYPE ) ) { if ( type1.isFlagSet( Type.DATE_TYPE ) || type1.isFlagSet( Type.DATETIME_TYPE ) || type1.isFlagSet( Type.TIME_TYPE ) || type1.isFlagSet( Type.ANY_TYPE ) ) { if ( value instanceof Date ) { return DateUtil.normalizeDate( (Date) value, type1 ); } } } final Number serial = convertToNumber( type1, value ); final BigDecimal bd = NumberUtil.getAsBigDecimal( serial ); return HSSFDateUtil.getJavaDate( bd ); }
public String toString() { return FormulaUtil.quoteReference(name); }
public TypeValuePair evaluate( final FormulaContext context, final ParameterCallback parameters ) throws EvaluationException { final Date now = DateUtil.now( context ); final Date date = DateUtil.normalizeDate( now, DateTimeType.DATE_TYPE ); return new TypeValuePair( DateTimeType.DATE_TYPE, date ); } }
public String toString() { if (value instanceof Number) { return String.valueOf(value); } return FormulaUtil.quoteString(String.valueOf(value)); }
public static String extractFormula( final String formula ) { String[] strings = extractFormulaContext( formula ); return strings[ 1 ]; }
private static Date monthend( final Date date, final LocalizationContext context ) { final Calendar gc = DateUtil.createCalendar( date, context ); gc.set( Calendar.DAY_OF_MONTH, gc.getActualMaximum( Calendar.DAY_OF_MONTH ) ); return gc.getTime(); }
public static String encode (final String s, final String encoding) throws UnsupportedEncodingException { if ("utf-8".equalsIgnoreCase(encoding)) { return encodeUTF8(s); } return encodeBytes(s.getBytes(encoding)); }
private BigDecimal compute( final Number value, final BigDecimal computedResult ) { if ( value == null ) { // no-op .. return computedResult; } return computedResult.add( NumberUtil.getAsBigDecimal( value ) ); } }
public Date convertToDate(final Type type1, final Object value) throws EvaluationException { if (type1.isFlagSet(Type.NUMERIC_TYPE) || type1.isFlagSet(Type.ANY_TYPE)) { if (type1.isFlagSet(Type.DATE_TYPE) || type1.isFlagSet(Type.DATETIME_TYPE) || type1.isFlagSet(Type.TIME_TYPE) || type1.isFlagSet(Type.ANY_TYPE)) { if (value instanceof Date) { return DateUtil.normalizeDate((Date) value, type1); } } } final Number serial = convertToNumber(type1, value); final BigDecimal bd = NumberUtil.getAsBigDecimal(serial); return HSSFDateUtil.getJavaDate(bd); }
public static String extractStaticTextFromFormula( final String formula ) { if ( formula == null ) { return null; } final String formulaFragment = extractFormula( formula ); return extractStaticTextFromFormulaFragment( formulaFragment ); }
public Number evaluate(final Number number1, final Number number2) throws EvaluationException { final BigDecimal bd1 = NumberUtil.getAsBigDecimal(number1); final BigDecimal bd2 = NumberUtil.getAsBigDecimal(number2); return NumberUtil.divide(bd1, bd2); }
public String toString() { return FormulaUtil.quoteReference( name ); }
public TypeValuePair evaluate( final FormulaContext context, final ParameterCallback parameters ) throws EvaluationException { final Date now = DateUtil.now( context ); final Date date = DateUtil.normalizeDate( now, DateTimeType.DATETIME_TYPE ); return new TypeValuePair( DateTimeType.DATETIME_TYPE, date ); } }
public String toString() { if ( value instanceof Number ) { return String.valueOf( value ); } return FormulaUtil.quoteString( String.valueOf( value ) ); }
public static String extractFormula(final String formula) { String[] strings = extractFormulaContext(formula); return strings[1]; }
/** * Converts a <code>Date</code> value according to the requested <code>Type</code> to the proper <code>Date</code> * subclasses (<code>java.sql.Time</code>, <code>java.sql.Date</code>) if needed. If the requested type is unknown, no * conversion takes place and the input date is returned. * * @param fromDate The date to convert. * @param toType The requested type of date. * @return The converted date. */ public static Date normalizeDate(final Date fromDate, final Type toType) { return normalizeDate(fromDate, toType, true); }
private static Date monthend(final Date date, final LocalizationContext context) { final Calendar gc = DateUtil.createCalendar(date, context); gc.set(Calendar.DAY_OF_MONTH, gc.getActualMaximum(Calendar.DAY_OF_MONTH)); return gc.getTime(); }