https://bugs.documentfoundation.org/show_bug.cgi?id=157541
Bug ID: 157541
Summary: UI: The Calc Find tool bar functionality is not
natural in its search for numbers since if entering
11, then the search also finds 111, 1111, etc.
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: larryg.ki...@gmail.com
Description:
This is a feature modification request.
1. Preferred implementation:
a. Make the Find tool default to search for the user entered character string
as Whole Number when the character string is entirely made up of numeric digits
with optional sign <-> or <+> for negative or positive number.
i. Examples: user enters -123 or +123, where in the case of the prefix <->
only -123 is found, and for the prefix <+>, the search finds the digits 123
whether they are prefixed with <+> or not.
Note: for the remainder of the implementation details, it is assumed any
number, whether whole, or decimal can be entered with sign such that the sign
is handled as discussed for whole number.
b. If the user enters a digit string with periods or commas without space
characters and no fractional part (they have entered an integer whole number),
then the non-digit delimiters are ignored in the search if not the decimal
point.
i. Whole number (integer) example: 123.456 where <.> is a thousands
delimiter, or 123,456 where <,> is the thousands delimiter.
c. If the user enters a decimal number 123.456,23 where <.> is the thousands
delimiter and <,> divides the whole number from its fractional part, then the
search should be equivalent to Whole Cell.
d. If the user enters a decimal number 123.456,78+ where <.> is the thousands
delimiter and <,> divides the whole number from its fractional part, then the
search will find all strings 123.456,78, including 123.456,789, 123.456,7891,
and so on. If the suffix <+> seems unnatural, then <*> for wild card search
might be more intuitive to the greater user body.
e. The suffix <?> should be reserved for an "any digit" (or "do not care")
ending digit, <??> for an any pair of ending digits, and so forth. This suffix
character <?> can follow a whole number if the ones digit is any, or but using
<??> the ones and tens are any, and so forth. These suffixes can immediately
follow the decimal for an any fractional part of specified number of digits.
Justification: Calc is primarily for working with data as numbers, not strings.
2. Second choice (simpler) implementation: add a new check box, or replace the
Match Case check box in the Find tool bar with one for Whole Cell.
Justification: Calc is primarily for working with numbers, so a check box for
Match Case in the Find tool bar instead of the more (but not entirely)
intuitive Whole Cell seems a missed opportunity for a very simple ease of use
improvement.
Overall Justification: to search for a given number requires one to click on
the not so obvious Find and Replace Icon in the Find tool bar to bring up the
Fiend and Replace window. One then needs understand that the check box for
Entire Cell is what is needed to find a specified number. The work around in
the Find tool bar is to remember ^51$ will do the same thing, but this is
intended for processing strings not numbers. Nonetheless, there are several
features given the preferred implementation section that are near impossible to
perform in the current implementation of Find in Calc.
Steps to Reproduce:
1. Open Find tool bar.
2. Enter number to search for in text search box such as 11.
3. Press either the up or down buttons.
Actual Results:
Cells are found with 11, 111, 1111, etc.
Expected Results:
Only cells with 11 are found.
Reproducible: Always
User Profile Reset: No
Additional Info:
I am using version 7.6.2.1, build 56f7684011345957bbf33a7ee678afaf4d2ba333.
--
You are receiving this mail because:
You are the assignee for the bug.
