ODFF 1.3 Small Group Evaluator requirements

[wojciechczerniak]

Description

The first milestone should be to meet ODFF 1.3 Small Group Evaluator requirements. This gives us an MVP as defined by the OpenFormula standard.

Most of those requirements are already met. Some of the functions are already on our list #13

Requirements for Small Group Evaluator

From ODFF 1.3:

• A) 3.7 It shall implement at least the limits defined in the “Basic Limits” section Basic Limits #59
• B) It shall implement the syntax defined in these sections on syntax:
  • 4.11.11 Criteria
  • 5.2 Basic Expressions Support omitting optional function parameters #76
  • 5.3 Constant Numbers
  • 5.4 Constant Strings
  • 5.5 Operators
    • Prefix "-" has higher precedence than "^"
    • Reference intersection has a higher precedence than reference union
    • Precedence can be overridden by using parentheses
    • "Unnecessary" parentheses and white space should be retained, people add them to improve readability.
  • 5.6 Functions and Function Parameters
    • Function names are case-insensitive (spec)
    • Functions can be called wit 0 parameters i.e. =TRUE() (spec)
    • Parameters are separated using the semicolon ; (spec)
    • Supports naming as defined by XML letter, digit and combiningChar
  • 5.7 Nonstandard Function Names (spec)
    • Not supported function should compute as an Error other than #N/A
    • Functions that are not part of the ODFF spec should be namespaced if possible
  • 5.8 References Escaping apostrophe in sheet name #64 Parse/unparse absolute sheet name #65 Sheet name case sensitivity #66
  • 5.11 Simple Named Expressions
  • 5.12 Constant Errors Errors should be parsed from string and propagated #63
  • 5.14 Whitespace Keep the whitespace #68
    • Ignore the whitespace in calculations
    • Support four whitespace types: SPACE (U+0020), CHARACTER TABULATION (U+0009), LINE FEED (U+000A), CARRIAGE RETURN (U+000D)
    • Retain whitespace entered by the user for formatting purposes
• C) It shall implement all implicit conversions for the types it implements, at least
  • 6.3.2 Conversion to Scalar
  • 6.3.5 Conversion to Number
    • Number, return as is
    • Logical, return 0 if FALSE, and 1 if TRUE
    • Text
    • Reference ... 😱
  • 6.3.12 Conversion to Logical
    • Number is TRUE for <>0 and FALSE for 0
    • Depends on implementation
      • Return always FALSE
      • Return always Error
      • Convert "false" (ignore case) to FALSE, "true" to TRUE. Fallback to FALSE or return an Error if conversion failed. Locale specific, use "prawda" for pl-PL etc.
    • Logical as is
    • Reference, convert to scalar first. Empty cell is FALSE.
  • 6.3.14 Conversion to Text
    • Number is transformed to Text with no whitespace
    • Text is returned as is
    • Logical returns "TRUE" and "FALSE" as uppercase strings
    • Reference: conversion to scalar. If empty, return empty string. (fails on range)
  • Reference
  • and when an expression returns an Error
• D) It shall implement the following operators (which are all the operators except reference union (~)):
  • 6.4.9 Infix Operator Ordered Comparison ("<", "<=", ">", ">=") (spec)
  • 6.4.10 Infix Operator "&” (spec)
  • 6.4.2 Infix Operator "+” (spec)
  • 6.4.3 Infix Operator "-” (spec)
  • 6.4.4 Infix Operator "*” (spec)
  • 6.4.5 Infix Operator "/” (spec)
  • 6.4.6 Infix Operator "^” (spec)
  • 6.4.7 Infix Operator "=” (spec)
  • 6.4.8 Infix Operator "<>” (spec)
  • 6.4.14 Postfix Operator “%” Support coercion of string with percent sign into number #44 (spec)
  • 6.4.15 Prefix Operator “+” Operator unary plus is not supported #70 (spec)
  • 6.4.16 Prefix Operator “-” (spec)
  • 6.4.12 Infix Operator Reference Intersection ("!") Does not support reference operators  #15 (spec)
  • 6.4.11 Infix Operator Range (":") Does not support reference operators  #15 (spec)
• E) It shall implement at least the following functions as defined in this specification Extracted to separate issue, will be tracked here ODFF 1.3 Small Group Evaluator functions #274
• F) It need not evaluate references that contain more than one area.
• G) It need not implement
  • inline arrays 5.13
  • complex numbers 4.4
  • and the reference union operator 6.4.13

Reference

https://www.oasis-open.org/committees/documents.php?wg_abbrev=office