Apache OpenOffice (AOO) Bugzilla – Issue 20494
Q-PCD MSInteroperability-6
Last modified: 2013-08-07 15:15:02 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 -
added keyword Q-PCD
Depends on array calculation issues.
*** Issue 11064 has been marked as a duplicate of this issue. ***
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'
Eike, we need to create separate issues for the remaining points, and then close this one.
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
Closing.
*** Issue 34324 has been marked as a duplicate of this issue. ***