Issue 43804 - sumif problem with complex args
Summary: sumif problem with complex args
Status: CLOSED DUPLICATE of issue 4904
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: recent-trunk
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
: 43803 (view as issue list)
Depends on:
Blocks:
 
Reported: 2005-03-01 15:28 UTC by tulitanssi
Modified: 2005-03-08 18:43 UTC (History)
1 user (show)

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

Attachments
shows sumif-with-complex-args bug (13.50 KB, application/vnd.ms-excel)
2005-03-01 15:30 UTC, tulitanssi 		no flags Details
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 tulitanssi 2005-03-01 15:28:20 UTC 
The sumif function gives err:508 when args to it are complex, e.g. indirect
function etc.
I attached an example. The example works with MS Excel but not with OO Calc.

This problem has been around in all versions of Calc, I'm using 1.9.79 now.
Comment 1 tulitanssi 2005-03-01 15:30:40 UTC 
Created attachment 23182 [details]
shows sumif-with-complex-args bug
Comment 2 frank 2005-03-02 20:30:59 UTC 
*** Issue 43803 has been marked as a duplicate of this issue. ***
Comment 3 frank 2005-03-02 20:34:09 UTC 
Hi,

not a Prio 2 Task.

Frank
Comment 4 tulitanssi 2005-03-04 16:53:29 UTC 
About priority: for me this is a show-stopper, i.e. I must continue using MS
Excel until this has been resolved. :(
Comment 5 frank 2005-03-07 11:36:53 UTC 
Hi,

even if this does not sound exactly as 4904 , it's the same root cause. So double.

Frank

*** This issue has been marked as a duplicate of 4904 ***
Comment 6 frank 2005-03-07 11:37:13 UTC 
closed double
Comment 7 tulitanssi 2005-03-08 18:43:57 UTC 
This problem has been known (according to duplicates) for almost three years
now. When will it be fixed? Any idea?