[Libreoffice-bugs] [Bug 52242] Strange behaviour when searching numbers

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=52242

--- Comment #1 from Roman Eisele <bugs at eikota.de> 2012-07-21 10:14:20 PDT ---
Created attachment 64485
  --> https://bugs.freedesktop.org/attachment.cgi?id=64485
Sample file for bug 52242



Thank you very much for your bug report!

REPRODUCIBLE with
* LibreOffice 3.5.5.3 (Build ID: 7122e39-92ed229-498d286-15e43b4-d70da21)
* LibreOffice 3.6.0.2 (Build ID: 815c576)
both with German langpack installed, on MacOS X 10.6.8 (Intel).

In the following, I refer myself to the attached .ods sample file which was
created according to reporter's original description. It contains both a cell
with a simple formula that should evaluate to 120 (A3 with formula
"=SUM(A1:A2)") and two cells with "false positive" values: 1120 (in C2) and
1200 (in C3).

We have to distinguish different cases.


(1) Searching for "120" with the "Find" toolbar, Calc finds the two
false-positive cells C2 and C3 only, but never cell A3 with the calculated
value 120.

=> IMHO this is not a bug, but a very bad default behaviour which should be
changed. There are no options for the "Find" toolbar, so it should act by
default the way most "ordinary users" would expect it to work, and I agree with
the original reporter that most or all "ordinary users" would expect the "Find"
toolbar to find the calculated value "120" in A3, because this (the calculated
value "120") is what is visible by default in that cell. So the deault search
should be done by comparing values, not by comparing strings, whenever the user
searches for a numeric value.


(2) Searching for "120" with the "Find and Replace" dialog window, the results
depend from the value of the "Search in" popup menu, which is however hidden by
default, because it is in the "More Options" bottom part of the dialog window.

(2a) With the default value for "Search in", which is "Formulas", searching
works like with the "Find" toolbar: Calc finds the two false-positive cells C2
and C3 only, but never cell A3 with the calculated value 120. [You can change
this behaviour by checking "Entire cells": then no occurence is found at all
(correct!).]

=> IMHO this is not a bug, but it is a rather bad default setting that the
"Find and Replace" dialog defaults to "Search in": "Formulas". Calc experts may
know better, but I would suggest to change the default setting to "Search in":
"Values."


(2b) When setting the "Search in" popup menu to "Values", Calc finds both the
false-positive cells C2 and C2 and the calculated value in cell A3. OK. But it
does *not* find them if I search for 120.00 or 120,00.

=> IMHO there are two real bugs here:

(i) when the user explictly selects "Search in": "Values", searching for 120.00
and/or 120,00 (depending on locale settings) MUST find cell A3 with the
calculated value 120, too.

(ii) when the user explictly selects "Search in": "Values", searching for 120,
120.0 or 120,00 should NOT find the false-positive cells with values 1120 (in
C2) and 1200 (in C3).

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.