To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=113183





------- Additional comments from rolle...@openoffice.org Mon Jan 24 17:34:56 
+0000 2011 -------
A few steps for replicating (without the files above):

1. Open two new spreadsheets in OO Calc.

2. In one spreadsheet, fill the four cells of column A with the following 
values:
 
   a. a text-formatted digit (e.g. 123).
   b. a text-formatted digit preceeded by " ' " (e.g. '123).
   c. a non-formatted integer < 10 (e.g. 1).
   d. some text (e.g. "text").

3. In the other spreadsheet, fill the same cells with the same values as in 
step  2.

4. In the first spreadsheet, fill the first cell of column B with the COUNTIF()
formula as follows:

        =COUNTIF('filepath of other spreadsheet'#Sheet1.A1:B4;A1)

5. Still in the first spreadsheet, fill the first cell of column D with the
following IF() formula:

        =IF('filepath of other spreadsheet'#Sheet1.A1=A1)

6. For both the first cell of column B and the first cell of column D, highlight
the cell. Click the dot at the bottom left of the border that highlights the
cell and drag it down. It should cover the first four cells. When the mouse
button is released, Calc will recalculate the formula for each corresponding
cell and display the result there.

7. A binary value now appears in the first four cells of column B, and a Boolean
value in the cells of D. 

If the values in both spreadsheets are equal (which they are, and should be),
IF() should produce TRUE in each cell, which it does.

If the values are equal (which they are), COUNTIF() should produce a 1 in each
of its respective cells. Unfortunately, for values a and b, which are
text-formatted digits, it registers a value of 0, which is incorrect.

The user could not determine a work around for this bug within the version of 
OO.

The tests I mentioned above were reproduced from scratch, and tests all confirm
that COUNTIF() works incorrectly.

It is also interesting that this bug is also apparent with digits formatted as
decimal numbers, as well as currency-formatted digits.

        

---------------------------------------------------------------------
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: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org


---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org

Reply via email to