Issue 86283 - DELTA/GESTEP functions with non-numeric args are inconsistent
Summary: DELTA/GESTEP functions with non-numeric args are inconsistent
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOo 2.3.1
Hardware: All All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2008-02-20 19:25 UTC by drking
Modified: 2017-05-20 11:11 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description drking 2008-02-20 19:25:04 UTC
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.
Comment 1 drking 2008-02-24 07:42:05 UTC
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.
Comment 2 amy2008 2008-09-09 08:03:22 UTC
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
Comment 3 frank 2008-09-09 08:37:08 UTC
Hi Eike,

one for you I think.

Comment 4 drking 2008-09-09 09:02:24 UTC
>In MS Excel, DELTA/GESTEP functions don't exist.

They're categorised as 'engineering functions' in Excel - so yes, Excel does 
have them.

Comment 5 Marcus 2017-05-20 11:11:42 UTC
Reset assigne to the default "".