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 com.extentech.formats.XLS.Formula

          if (cel==null) { // 20090203 KSC
            continue;            
          }
            
          try{
            Formula f = (Formula)cel.getFormulaRec();
            if (f!=null){
              Object oby = f.calculateFormula();
                String s = String.valueOf(oby);
                try{
                  //Double d = new Double(s);
                    returnval = new Double(s);
                }catch(NumberFormatException ex) {

View Full Code Here

Examples of edu.stanford.nlp.sempre.Formula

    List<EntityLexicalEntry> res = new LinkedList<EntityLexicalEntry>();
    textDesc = textDesc.replaceAll("\\?", "\\\\?").toLowerCase();
    List<Document> docs = searcher.searchDocs(textDesc);
    for (Document doc : docs) {


      Formula formula = Formula.fromString(doc.get(FbIndexField.ID.fieldName()));
      String[] fbDescriptions = new String[]{doc.get(FbIndexField.TEXT.fieldName())};
      String typesDesc = doc.get(FbIndexField.TYPES.fieldName());


      Set<String> types = new HashSet<String>();
      if (typesDesc != null) {

View Full Code Here

Examples of it.eng.spagobi.tools.scheduler.Formula

              strategy.setRoleToBeUsed(userRole[1]);
              biobjpar.setParameterValuesRetriever(strategy);
            } else if (useFormulaParameters.containsKey(biobjpar.getParameterUrlName())) { 
              FormulaParameterValuesRetriever strategy = new FormulaParameterValuesRetriever();
              String fName = useFormulaParameters.get(biobjpar.getParameterUrlName());
              Formula f = Formula.getFormula(fName);
              strategy.setFormula(f);
              biobjpar.setParameterValuesRetriever(strategy);
            } else {
              for(int j=0; j<parCouples.length; j++) {
                String parCouple = parCouples[j];

View Full Code Here

Examples of jimm.datavision.Formula

    this.data = source.getData();
    this.query.findSelectablesUsed();  // Needed so we can find columns later


    String script = query.getWhereClause();
    if (script != null && script.length() > 0)
  whereClauseFormula = new Formula(null, source.getReport(), "", script);
}

View Full Code Here

Examples of jimm.datavision.Formula

              String language)
{
    super(I18N.get("ReportStartupScriptEditCommand.name"));
    this.report = report;


    Formula f = report.getStartFormula();


    newExpression = expression;
    oldExpression = f == null ? null : f.getExpression();


    newLanguage = language;
    oldLanguage = f == null ? null : f.getLanguage();
}

View Full Code Here

Examples of jimm.datavision.Formula

    newLanguage = language;
    oldLanguage = f == null ? null : f.getLanguage();
}


public void perform() {
    Formula f = null;
    if (oldExpression == null) {
  f = new Formula(null, report, "", "");
  report.setStartFormula(f);
    }
    else
  f = report.getStartFormula();


    f.setEditableExpression(newExpression);
    f.setLanguage(newLanguage);
}

View Full Code Here

Examples of jimm.datavision.Formula


public void undo() {
    if (oldExpression == null)
  report.setStartFormula(null);
    else {
  Formula f = report.getStartFormula();
  f.setEditableExpression(oldExpression);
  f.setLanguage(oldLanguage);
    }
}

View Full Code Here

Examples of jimm.datavision.Formula

    this.query = query;
    this.query.findSelectablesUsed();  // Needed so we can find columns later


    String script = query.getWhereClause();
    if (script != null && script.length() > 0)
  whereClauseFormula = new Formula(null, source.getReport(), "", script);
}

View Full Code Here

Examples of jxl.write.Formula


    protected Formula formula() throws JRException
    {
      try
      {
        return new Formula(x, y, formula, getLoadedCellStyle(baseStyle));
      }
      catch(Exception e)//FIXMENOW what exceptions could we get here?
      {
        if(log.isWarnEnabled())
        {

View Full Code Here

Examples of kodkod.ast.Formula

   * predicates replaced with equivalent constraints.
   */
  private AnnotatedNode<Formula> inlinePredicates(final AnnotatedNode<Formula> annotated, final Set<RelationPredicate> truePreds) {
    final AbstractReplacer inliner = new AbstractReplacer(annotated.sharedNodes()) {
      public Formula visit(RelationPredicate pred) {
        Formula ret = lookup(pred);
        if (ret!=null) return ret;
        return truePreds.contains(pred) ? cache(pred, Formula.TRUE) : cache(pred, pred.toConstraints());
      }
    };
    return annotate(annotated.node().accept(inliner));

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.