Groups - OpenDocument Formula Specification 2009-05-01 (ODT) (OpenDocument-formula-20090501.odt) uploaded

[erack@sun.com]

LOOKUP()
- If the query is Text and the value found is Number,
  #N/A is returned.

HLOOKUP(), VLOOKUP()
- In sorted range mode, if the query is Text and the
  value found is Number, #N/A is returned.

MATCH()
- In ascending sorted range mode, if the query is Text
  and the value found is Number, #N/A is returned.
- In descending sorted range mode, if the query is
  Number and the value found is Text, #N/A is returned.

REPLACE()
- start > length => start = length, no error
- count > length - start => count = length - start, no
  error

FDIST()
- If the numerator degrees of freedom (r1) is 1, then
  the density function has a pole at x=0. The draft
  spec does not define the return value in that case.
  For x<0 it defines that the return value is 0. For
  x>=0 it defines it with a term which has a subterm
  x^(r1/2-1). And x^(-1/2) is not defined for x=0.
  Mention that an error is to be returned in that case.
- Change ugly looking hard to read formula to better
  one using {x}over{y} instead of x/y and use left( ...
  right) braces.

LEGACY.FDIST()
- Change ugly looking hard to read formula to better
  one using {x}over{y} instead of x/y and use left( ...
  right) braces.

Test cases
- Remove all Level columns and remaining references to
  Level in text.

DATEDIF()
- Test cases missing results.
  Gnumeric and Excel confirmed:
  =DATEDIF(DATE(1990;2;15); DATE(1993;9;15); "y")   => 3
  =DATEDIF(DATE(1990;2;15); DATE(1993;9;15); "d")   => 1308
  =DATEDIF(DATE(1990;2;15); DATE(1993;9;15); "yd")  => 212

DATEDIF()
- Don't talk about "between", use the difference instead.

TIMEVALUE()
- Change test case
  =TIMEVALUE("1999-11-22 06:05:07")=TIME(6;5;7)
  to
  =ROUND(TIMEVALUE("1999-11-22 06:05:07");10)=ROUND(TIME(6;5;7);10)

TIME()
- Test case wrong: =TIME(11;-125;-144)*60*60*24 should
  not return -31956 but 31956 instead.

DateParam conversion in test cases
- Replace all implicit "YYYY-MM-DD" conversions with
  DATE(YYYY;MM;DD).
- Test conversion only for DATEVALUE() test cases.

EOMONTH()
- test case
  - the expression: =EOMONTH("2000-04-30";-2)=DATE(2006;2;29) should be:
    =EOMONTH("2000-04-30";-2)=DATE(2000;2;29)
    =EOMONTH(DATE(2000;04;30);-2)=DATE(2000;2;29)
  - the expression: =EOMONTH("2006-01-05";5)=DATE(2002;6;30 should be:
    =EOMONTH(DATE(2006;01;05);5)=DATE(2006;6;30)

EDATE()
- test cases
  - the expression: =EDATE("2000-04-30";-2)=DATE(2006;2;29) should be:
    =EDATE(DATE(2000;04;30);-2)=DATE(2000;2;29)
  - the expression: =EDATE("2000-04-05";24)=DATE(2002;4;12) should be:
    =EDATE(DATE(2000;04;05);24)=DATE(2002;4;5)

DAY()
- Test case, the expression, =DAY("2006-12-15") should
  return 15 not 12 as indicated.
  - Also, replace with =DAY(DATE(2006;12;15))

EUROCONVERT()
- Add Slovak Koruna SKK/EUR 30.1260 with 2 decimals.

PERCENTRANK()
- X_a < X < X_b: make that Y < X < Z with Z=Y+1
- Clarify that Y is the largest number smaller than
  X and Z the smallest number larger than X.
- Remove "Despite its name, PERCENTRANK returns ..."

PERMUT()
- Remove P(n,k) from formula.

PERMUTATIONA()
- Add constraint of integer parameters.


 -- Mr. Eike Rathke

The document revision named OpenDocument Formula Specification 2009-05-01
(ODT) (OpenDocument-formula-20090501.odt) has been submitted by Mr. Eike
Rathke to the OpenDocument - Formula document repository.  This document is
revision #72 of openformula-spec-20060221.odt.

Document Description:
OpenFormula is an open format for exchanging recalculated formulas between
office application implementations, particularly for spreadsheets.
OpenFormula defines the types, syntax, and semantics for calculated
formulas, including many predefined functions and operations, so that
formulas can be exchanged between applications and produce substantively
equal outputs when recalculated with equal inputs. Both closed and open
source software can implement OpenFormula.

OpenFormula is intended to be a supporting document to the Open Document
Format for Office Applications (OpenDocument) format, particularly for
defining its attributes table:formula and text:formula. It can be used in
other circumstances where a simple, easy-to-read infix notation is desired
for exchanging recalculated formulas.

View Document Details:
http://www.oasis-open.org/committees/document.php?document_id=32350

Download Document:  
http://www.oasis-open.org/committees/download.php/32350/OpenDocument-formula-20090501.odt

Revision:
This document is revision #72 of openformula-spec-20060221.odt.  The
document details page referenced above will show the complete revision
history.


PLEASE NOTE:  If the above links do not work for you, your email application
may be breaking the link into two pieces.  You may be able to copy and paste
the entire link address into the address field of your web browser.

-OASIS Open Administration