Examples of Formula

com.extentech.formats.XLS.Formula

FORMULA (0x406) describes a cell that contains a formula.

 offset  name        size    contents 0       rw          2       Row 2       col         2       Column   4       ixfe        2       Index to the XF record 6       num         8       Current value of the formula 14      grbit       2       Option Flags 16      chn         4       (Reserved, must be zero) A field that specifies an application-specific cache of information. This cache exists for performance reasons only, and can be rebuilt based on information stored elsewhere in the file without affecting calculation results. 20      cce         2       Parsed Expression length 22      rgce        cce     Parsed Expression

The grbit field contains the following flags:

 byte   bits   mask   name           asserted if 0      0      0x01   fAlwaysCalc    the result must not be cached     1      0x02   fCalcOnLoad    the cached value is incorrect 2      0x04   (Reserved) 3      0x08   fShrFmla       this is a reference to a shared formula 7-4    0xF0   (Unused) 1      7-0    0xFF   (Unused)

In most cases, formulas should have fAlwaysCalc asserted to ensure that correct values are displayed upon opening of the file in Excel.

edu.stanford.nlp.sempre.Formula
A Formula is a logical form, which is the result of semantic parsing. Current implementation is lambda calculus with primitives like description logic and DCS to lessen the use of variables.
Important note: define hashCode() for each Formula which only depends on the value, not on random bits (don't include object IDs or enums). @author Percy Liang
it.eng.spagobi.tools.scheduler.Formula
jimm.datavision.Formula
A formula is a Bean Scripting Framework (BSF) script evaluated at runtime. It may contain database column values, other formulas, special values, and aggregates.
Before being evaluated, the following substitutions are made withing the evaluation string of a formula:
- {table_name.column_name} is replaced by the current value of the column table_name.column_name, but only if the column exists. If it doesn't, then the entire "{...}" text is kept as-is.
- {@id_number} is replaced by the results of evaluating the formula whose id is id_number.
- {%special_value_name} is replaced by a special value (report title, report run date, page number, or record number).
- {?id_number} is replaced by a parameter value (string, number, or date).
- {!id_number} is replaced by a user column's value (string, number, or date).
jxl.write.Formula
A cell, created by user applications, which contains a numerical value
kodkod.ast.Formula
A first-order formula. Unless otherwise noted, all methods in this class throw a NullPointerException when given null arguments. @author Emina Torlak
org.hibernate.annotations.Formula
org.hibernate.mapping.Formula
A formula is a derived column value @author Gavin King
org.jfree.formula.Formula
Creation-Date: 31.10.2006, 14:43:05 @author Thomas Morgner
org.mizartools.dli.Formula
org.openntf.domino.helpers.Formula
@author nfreeman
org.pentaho.reporting.libraries.formula.Formula
Creation-Date: 31.10.2006, 14:43:05 @author Thomas Morgner
org.projectforge.excel.Formula
org.renjin.stats.internals.models.Formula
Encapsulates the properties of R model formulae, which consist of three elements:
- A response (or dependent) variable
- An intercept flag (0=do not fit intercept, 1=fit intercept)
- A list of independent variable terms
Within the context of R model formulas, a variable is any valid R expression that can be evaluated within the formula's {@link Environment} (usually adata.frame object). It is often a symbol, like simply {@code x} or {@code y}, but a variable in this context a variable can also be a function of a Symbol, such as {@code log(x)} or any valid R expression, such {@code sqrt(x/y)}.
A term is a combination of one or more variables. This class stores terms in their expanded form: the formula described by {@code y ~ a * b} actually has three terms: {@code a}, {@code b}, and {@code a:b}, where {@code a:b} is an interaction term. See {@link FormulaInterpreter} for more information on the DSL.
This internal class is used by the primitives that manipulate model formulas.
org.sonar.api.measures.Formula
@since 1.11
org.zkoss.zss.model.Formula
A formula value stored in a cell. @author tomyeh

Examples of org.hibernate.mapping.Formula

      }
      Iterator columns = sourceValue.getColumnIterator();
      Random random = new Random();
      while ( columns.hasNext() ) {
        Object current = columns.next();
        Formula formula = new Formula();
        String formulaString;
        if ( current instanceof Column ) {
          formulaString = ( (Column) current ).getQuotedName();
        }
        else if ( current instanceof Formula ) {
          formulaString = ( (Formula) current ).getFormula();
        }
        else {
          throw new AssertionFailure( "Unknown element in column iterator: " + current.getClass() );
        }
        if ( fromAndWhere != null ) {
          formulaString = Template.renderWhereStringTemplate( formulaString, "$alias$", new HSQLDialect() );
          formulaString = "(select " + formulaString + fromAndWhere + ")";
          formulaString = StringHelper.replace(
              formulaString,
              "$alias$",
              "a" + random.nextInt( 16 )
          );
        }
        formula.setFormula( formulaString );
        targetValue.addFormula( formula );


      }
      return targetValue;
    }

View Full Code Here

Examples of org.jfree.formula.Formula

  {
    try
    {
      final FormattedTextElement element = (FormattedTextElement) getNode();
      final FormulaExpression formulaExpression = element.getValueExpression();
      final Formula formula = formulaExpression.getCompiledFormula();
      final LValue lValue = formula.getRootReference();
      return isReferenceChanged(lValue);
    }
    catch (final ParseException e)
    {
      Log.debug("Parse Exception", e);

View Full Code Here

Examples of org.mizartools.dli.Formula

    VariableId vid2 = new VariableId();
    vid2.setId(vid.getId());
    for (org.mizartools.system.xml.PartialDef partialDef : defMeaning.getPartialDefList()){
      partList.add(getPart(abstractSignature, partialDef, vid2));
    }
    Formula formula = getFormula(abstractSignature, defMeaning.getFormula(), vid2);
    Term term = getTerm(abstractSignature, defMeaning.getTerm(), vid2);
    ProperDefiniens properDefiniens = new ProperDefiniens(partList , formula, term);
    return properDefiniens;
  }

View Full Code Here

Examples of org.openntf.domino.helpers.Formula

  }


  @Override
  public void run() {
    Session session = this.getSession();
    Formula formula = new Formula();
    String source = "REM {Begin_Do_Not_Tag};\r\n" + "\r\n" + "SenderName := @If(SendTo = \"\";EnterSendTo;SendTo);\r\n"
        + "Send := @Subset(SenderName; 1);\r\n" + "CN1 := @Trim(@Name([CN]; Send));\r\n"
        + "CN := @If(@Contains(@Right(Send;\"@\");\">\") & CN1 = \"\";@Trim(Send); CN1);\r\n"
        + "G := @If(CN = \"\"; @Name([G]; @Subset(SenderName; 1)); \"\");\r\n"
        + "S := @If(CN = \"\"; @Name([S]; @Subset(SenderName; 1)); \"\");\r\n"
        + "Person := @If(CN != \"\"; CN; G + \" \" + S);\r\n"
        + "@If(@Left(Person;1)=\"\\\"\" & @Right(Person;1)=\"\\\"\"; @LeftBack(@RightBack(Person;1);1); Person);\r\n"
        + "REM {End_Do_Not_Tag};";
    formula.setExpression(source);
    org.openntf.domino.helpers.Formula.Parser parser = formula.getParser();
    if (parser != null) {
      parser.parse();
      Set<String> literals = parser.getLiterals();
      System.out.println("BEGIN LITERALS");
      for (String literal : literals) {

View Full Code Here

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

                new DefaultTableModel(), -1, new DefaultProcessingContext());
      }




      final String formula = computeFormula(configIndicator);
      final Formula compiledFormula = new Formula(formula);
      compiledFormula.initialize(new ReportFormulaContext(formulaContext, expressionRuntime));
      final Object o = compiledFormula.evaluate();
      if (o instanceof ErrorValue)
      {
        throw EvaluationException.getInstance((ErrorValue) o);
      }
      if (o == null)

View Full Code Here

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


    try
    {
      if (compiledFormula == null)
      {
        compiledFormula = new Formula(formulaExpression);
      }


      final ExpressionRuntime expressionRuntime = getRuntime();


      final ReportFormulaContext context =

View Full Code Here

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

    try
    {
      if (initial != null)
      {
        final ExpressionRuntime expressionRuntime = getRuntime();
        final Formula initFormula = new Formula(initialExpression);
        final ReportFormulaContext context = new ReportFormulaContext
            (getFormulaContext(), expressionRuntime);
        try
        {
          initFormula.initialize(context);
          return initFormula.evaluate();
        }
        finally
        {
          context.close();
        }

View Full Code Here

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


    try
    {
      if (compiledFormula == null)
      {
        compiledFormula = new Formula(formulaExpression);
      }
      final ExpressionRuntime expressionRuntime = getRuntime();
      final ReportFormulaContext context =
          new ReportFormulaContext(getFormulaContext(), expressionRuntime);
      try

View Full Code Here

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

      {
        errorTextHolder.setText(Messages.getInstance().getString("FormulaEditorDialog.ShortErrorNoFormulaContext"));
        errorTextHolder.setToolTipText(Messages.getInstance().getString("FormulaEditorDialog.ErrorNoFormulaContext"));
        return;
      }
      final Formula formula = new Formula(formulaText);
      formula.initialize(formulaContext);
      final TypeValuePair pair = formula.evaluateTyped();


      if (pair.getValue() instanceof LibFormulaErrorValue)
      {
        errorTextHolder.setText(Messages.getInstance().getString("FormulaEditorDialog.ShortEvaluationError"));
        errorTextHolder.setToolTipText(Messages.getInstance().getString("FormulaEditorDialog.EvaluationError"));

View Full Code Here

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


public class FormulaParsePosition
{
  public static void main(String[] args) throws EvaluationException, ParseException
  {
    final Formula f = new Formula("IF(NOT(TRUE()));\"Testing\"; \"Other\"");


    // connects the parsed formula to the context. The context provides the
    // operator and function implementations and resolves the references.
    f.initialize(new DefaultFormulaContext());


    final LValue rootReference = f.getRootReference();
    print(rootReference, 0);
  }

View Full Code Here

0 1 2 3 4 5 6

TOP

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.