To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=57401
                  Issue #:|57401
                  Summary:|Array formula incompatibility with Excel
                Component:|Spreadsheet
                  Version:|OOo 2.0
                 Platform:|All
                      URL:|
               OS/Version:|All
                   Status:|UNCONFIRMED
        Status whiteboard:|
                 Keywords:|
               Resolution:|
               Issue type:|DEFECT
                 Priority:|P3
             Subcomponent:|code
              Assigned to:|spreadsheet
              Reported by:|alanmandel





------- Additional comments from [EMAIL PROTECTED] Sat Nov  5 08:06:51 -0800 
2005 -------
In Excel, entering the array formula {=COUNTIF(<range>,<range>)} in a cell
produces a 1 if there are no duplicate entries in <range>, and some value
greater than 1 if there are duplicates.

In Calc 2.0, the array formula {=COUNTIF(<range>,<range>)} cannot be entered
into a single cell within Calc; it is intead spread over the number of cells in
<range>.

To reproduce, for example, putting [Q,R,Q,T,U] in cells A1 through A5, and the
array formula {=countif(A1:A5;A1:A5)} in B1, produces:

    A       B
   ------------
1 | Q       0
2 | R       0
3 | Q       0
4 | T       0
5 | U       0

Whereas in Excel, it produces:

    A       B
   ------------
1 | Q       2
2 | R       
3 | Q       
4 | T       
5 | U      

Note that if the Excel spreadsheet is created first and saved in Excel, OO 2.0
will open the spreadsheet with the array formula properly contained only in cell
B1, like this, even though its computation is incorrect:

    A       B
   ------------
1 | Q       0
2 | R       
3 | Q       
4 | T       
5 | U      

In my example above, the data in <range> is non-numeric.  Interestingly, if the
data in <range> is numeric, then a spreadsheet created in Excel with this
COUNTIF formula will open and compute properly in oo 2.0.

---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]


---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to