Bug 43192 - : confusing label for data validity criterion
Summary: : confusing label for data validity criterion
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
3.4.4 release
Hardware: All All
: low enhancement
Assignee: Joel Madero
URL:
Whiteboard: BSA
Keywords:
Depends on:
Blocks:
 
Reported: 2011-11-23 03:07 UTC by gamesh.g
Modified: 2012-06-19 00:39 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description gamesh.g 2011-11-23 03:07:53 UTC
Problem description: 

Under Data -> Validity -> Criteria it is possible to specify that the value entered be in a specified range.

That criteria is labelled as "between" which is confusing as it seems to imply that the minimum and maximum might not be included in the allowed range (although they are).

Steps to reproduce:
1. Click Data -> Validity
2. In the Criteria tab, look at the Data drop-down selector.
3. On of the options in "between" this would be better labelled as "range", or perhaps "allowed range".

Current behaviour:

A first-time user has a few moments of puzzlement trying to decide if the minimum and maximum values specified are included or not in the allowed range.

Expected behaviour:

The label used should make the validity check's behaviour clear to the user.

Platform (if different from the browser): 
              
Browser: Mozilla/5.0 (Ubuntu; X11; Linux i686; rv:8.0) Gecko/20100101 Firefox/8.0
Comment 1 sasha.libreoffice 2012-04-26 06:50:25 UTC
In 3.5.2 still exist. IMHO it is enhancement request, because no variant "between not including", therefore impossible to confuse with something.
In help nothing about including values. But we can easily determine this by experiment.
Comment 2 Joel Madero 2012-06-07 19:33:34 UTC
I'm taking care of this. I've changed the wording to "valid range" and "invalid range". Going to push it tonight.
Comment 3 sasha.libreoffice 2012-06-07 23:33:49 UTC
Thanks for fixing this bug
Comment 4 Joel Madero 2012-06-12 10:00:32 UTC
I've been asked to hold the push until one of the other devs push changes to the same file. As soon as he does I'll get my changes out. No guarantee they'll be accepted as "between" and "not between" have been used for so long. I'll post back when there is an update
Comment 5 Joel Madero 2012-06-18 08:55:00 UTC
Fix has been committed. Thanks for reporting the bug :)
Comment 6 gamesh.g 2012-06-19 00:39:38 UTC
Thanks, Joel :)

On 18 June 2012 16:55,  <bugzilla-daemon@freedesktop.org> wrote:
> https://bugs.freedesktop.org/show_bug.cgi?id=43192
>
> Joel Madero <jmadero@usa.com> changed:
>
>           What    |Removed                     |Added
> ----------------------------------------------------------------------------
>             Status|ASSIGNED                    |RESOLVED
>         Resolution|                            |FIXED
>
> --- Comment #5 from Joel Madero <jmadero@usa.com> 2012-06-18 08:55:00 PDT ---
> Fix has been committed. Thanks for reporting the bug :)
>
> --
> Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
> ------- You are receiving this mail because: -------
> You reported the bug.