Issue 95176 - Excels "matrix summary formula" is not handled in OO
Summary: Excels "matrix summary formula" is not handled in OO
Status: CLOSED DUPLICATE of issue 46681
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 3.0
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-10-20 08:26 UTC by guzi
Modified: 2008-10-23 14:50 UTC (History)
1 user (show)

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

Attachments
example file for a matrix summary formula (16.50 KB, text/plain)
2008-10-20 08:28 UTC, guzi 		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 guzi 2008-10-20 08:26:48 UTC 
The formula SUM(IF(A3:A10=A14;IF(B1:D1=B14;B3:D10;0);0))says "wrong data type"
in OO where Excel calculates a matrix summary formula
Comment 1 guzi 2008-10-20 08:28:26 UTC 
Created attachment 57284 [details]
example file for a matrix summary formula
Comment 2 ooo 2008-10-23 14:48:25 UTC 
Actually it's non-replicated vectors.

*** This issue has been marked as a duplicate of 46681 ***
Comment 3 ooo 2008-10-23 14:50:35 UTC 
Closing dup.