Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Status:||CLOSED FIXED||QA Contact:||issues@sc <issues>|
|Issue Type:||FEATURE||Latest Confirmation in:||---|
|Issue Depends on:||4070, 4485, 19765|
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