86283
2008-02-20 19:25:04 +0000
DELTA/GESTEP functions with non-numeric args are inconsistent
2017-05-20 11:11:42 +0000
1
1
2
Application
Calc
programming
OOo 2.3.1
All
All
CONFIRMED
P4
Trivial
---
1
openoffice
issues
issues
DEFECT
---
---
0
oldest_to_newest
999825
0
openoffice
2008-02-20 19:25:04 +0000
If cell A1 contains dog (text) and cell B1 contains 0:
DELTA(A1;B1) returns 1
DELTA(B1;A1) returns Err:502
OK, this is not the most important issue in the world, but for my money this
function ought to trap *any* non-numeric parameter and give an error. The
function is mathematical (Kronecker delta), defined just for numbers I believe.
In ODFF it seems to be defined just for numbers, but I can't figure out if that
means it *must* give an error for non-numbers.
DELTA("dog";0) does return an error.
999826
1
openoffice
2008-02-24 07:42:05 +0000
In addition:
=GESTEP("xxx";-2) correctly returns an error, as specified in ODFF, but
=GESTEP(A1;-2) where A1 contains xxx (text) returns 1.
Presumably the same thing.
999827
2
amy2008
2008-09-09 08:03:22 +0000
Can reproduce it in OOo3.0_RC1 on WinXP. According to the help, DELTA(A1;B1),
A1 and B1 must be numeric.
In MS Excel, DELTA/GESTEP functions don't exist.
Li Meiying
999828
3
frank
2008-09-09 08:37:08 +0000
Hi Eike,
one for you I think.
Frank
999829
4
openoffice
2008-09-09 09:02:24 +0000
>In MS Excel, DELTA/GESTEP functions don't exist.
They're categorised as 'engineering functions' in Excel - so yes, Excel does
have them.
1890649
5
marcus
2017-05-20 11:11:42 +0000
Reset assigne to the default "issues@openoffice.apache.org".