Issue 20494

Summary: Q-PCD MSInteroperability-6
Product: Calc Reporter: niklas.nebel
Component: uiAssignee: ooo
Status: CLOSED FIXED QA Contact: issues@sc <issues>
Severity: Trivial    
Priority: P2 CC: issues
Version: OOo 1.0.0   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: FEATURE Latest Confirmation in: ---
Developer Difficulty: ---
Issue Depends on: 4070, 4485, 19765    
Issue Blocks:    

Description niklas.nebel 2003-09-30 17:30:36 UTC 
Task tracking system for Childs
PLEASE CREATE CHILD-TASKS IN ISSUEZILLA!

Source
Mills, Users, Engineering

Category
Improve Calc Filters

Product Requirement 
Spreadsheet performs compatible calculation

Customer Need/Problem
Calculations written in other applications do not always translate to SO/OOo
because users have calculations which are not supported or performed differently
in SO/OOo, so calculation is lost.
1) Conversion of lots of functions with parameters matched as necessary
2) SO/OOo uses ';' while others use ','. This creates a failure of formulas and
trouble inputting the data as users are unaccustomed to ','. so =MAX(A1;B1;C1)
is SO/OOo's way, most people in the world use =MAX(A1,B1,C1)

Comment
The different separators are handled in EaseOfLearning-6

Eng Effort
MED 

Eng Owner
Niklas Nebel

Product Concept
Some special-case features of cell formula calculation are supported in other
applications, but not in SO/OOo.
The following differences have been identified and will be added to 'Q', given
enough time (in order of importance, most important first):
- IF() and CHOOSE() in matrix/array formulas
- OpCode 'ocRange' to span a rectangle of two named cells, like 'name1:name2'
- INDIRECT() with strings of named ranges, for example, =INDIRECT(range)
- EmptyCell return for functions, like LOOKUP()
- OpCode 'ocUnion' to pass multiple ranges as one parameter, like
'(range1;range2)' in INDEX
- General matrix/array parameter handling
- Matrix/array constants as a parameter
- Simple wildcards * and ? as opposed to regular expressions
- Allow a range as second parameter of LARGE() and SMALL()

Functional Specification
-
Comment 1 lutz.hoeger 2003-10-23 07:44:18 UTC 
added keyword Q-PCD
Comment 2 ooo 2003-10-29 19:54:48 UTC 
Depends on array calculation issues.
Comment 3 niklas.nebel 2004-01-26 14:04:00 UTC 
*** Issue 11064 has been marked as a duplicate of this issue. ***
Comment 4 thegoldenear 2004-02-20 18:03:00 UTC 
You should consider including in your list of "The following differences [that]
have been identified..." Issue 17664: 'spreadsheet / calc doesn't import Excel's
OFFSET, expecting SUM(OFFSET'
Comment 5 niklas.nebel 2004-07-29 14:37:14 UTC 
Eike, we need to create separate issues for the remaining points, and then close
this one.
Comment 6 ooo 2004-07-30 12:08:59 UTC 
Remaining issues are:
OpCode 'ocRange': issue 4904
INDIRECT() with strings of named ranges, for example, =INDIRECT(range): issue 4695
EmptyCell return for functions, like LOOKUP(): issue 32340
OpCode 'ocUnion': issue 32341
Matrix/array constants as a parameter: issue 32342
Simple wildcards * and ? as opposed to regular expressions: issue 32344
Allow a range as second parameter of LARGE() and SMALL(): issue 32345
Comment 7 ooo 2004-07-30 12:09:40 UTC 
Closing.
Comment 8 frank 2004-09-20 10:42:11 UTC 
*** Issue 34324 has been marked as a duplicate of this issue. ***