Issue 6334 - conditional matrices
Summary: conditional matrices
Status: CLOSED DUPLICATE of issue 4070
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.0
Hardware: All All
: P4 Trivial (vote)
Target Milestone: ---
Assignee: bettina.haberer
QA Contact: issues@sc
URL:
Keywords: rfe_eval_ok
Depends on:
Blocks:
 
Reported: 2002-07-08 00:31 UTC by vince
Modified: 2013-08-07 15:12 UTC (History)
1 user (show)

See Also:
Issue Type: ENHANCEMENT
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 vince 2002-07-08 00:31:27 UTC 
The implementation of matrizes seems to have additional potential. For example: if you have two 
ranges, one named value and the other criteria, itÂ’s not possible to calculate 
{=sum(if(criteria=7;value;0))}. Functions like countif() have restrictions regarding 
multiple criteria et al – thus it really should work this way (entered with Ctrl+Shift).
Comment 1 frank 2002-07-08 08:11:15 UTC 
Hi Falko,

1 4 u

Frank
Comment 2 falko.tesch 2003-03-25 08:04:35 UTC 
Re-assigned for evaluation to Bettina.
Comment 3 bettina.haberer 2003-04-14 16:39:06 UTC 
Yes, support of conditional matrices is needed in Calc.
Comment 4 michael.bemmer 2003-05-06 15:47:49 UTC 
Too late for beta2, re-targeted to 1.1 RC.
Comment 5 bettina.haberer 2003-05-13 13:05:56 UTC 
I changed the milestone target for this large implementation to OOo 2.0.
Comment 6 bettina.haberer 2004-04-08 20:13:37 UTC 
Sorry, no chance to get it done for Q as matrizes are no Q-keyfeature for
spreadsheet.
Comment 7 ooo 2006-12-13 20:14:15 UTC 
Actually this is implemented since OOo2.0

*** This issue has been marked as a duplicate of 4070 ***
Comment 8 ooo 2006-12-13 20:14:45 UTC 
Closing dupe.