Issue 110500 - On error LOG should return #NUM! or #VALUE! and not Err:502
Summary: On error LOG should return #NUM! or #VALUE! and not Err:502
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: viewing (show other issues)
Version: OOo 1.0.0
Hardware: Unknown All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-03-30 17:26 UTC by dipesh
Modified: 2013-08-01 05:36 UTC (History)
2 users (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description dipesh 2010-03-30 17:26:13 UTC 
Reproduce;
1) Add "=LOG(A2,10)" to C3
2) Add "abcdef" to A2

Result;
on 1) oocalc displays "Err:502"
on 2) oocalc displays "Err:502"

Expected;
on 1) oocalc should display "#NUM!"
on 2) oocalc should display "#VALUE!"

Why?
Because that's what Excel does too and now KSpread too where we fixed it to
behave like Excel.
Comment 1 dipesh 2010-03-30 17:42:43 UTC 
Some more details. This is what we do with the argument according to what Excel
does;

    if (args[0].isError())
        return args [0];
    if (args[0].isEmpty())
        return Value::errorNUM();
    if (args[0].isNumber() == false)
        return Value::errorVALUE();
    if (args[0].asFloat() <= 0)
        return Value::errorNUM();
Comment 2 Joost Andrae 2010-03-31 11:03:39 UTC 
In OOO320_m14 Calc gives #VALUE! for C3
Comment 3 Edwin Sharp 2013-08-01 05:36:32 UTC 
Step Calc Rev. 1507307 Excel 2007
1    Err:508           #NUM!
2    Err:508           #VALUE!