[Libreoffice-ux-advise] [Bug 157657] Make data validity case sensitive

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=157657

Stéphane Guillou (stragu) <stephane.guillou at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |libreoffice-ux-advise at lists
                   |                            |.freedesktop.org,
                   |                            |stephane.guillou at libreoffic
                   |                            |e.org
           Keywords|                            |needsUXEval
     Ever confirmed|0                           |1
             Status|UNCONFIRMED                 |NEW
           Severity|normal                      |enhancement

--- Comment #4 from Stéphane Guillou (stragu) <stephane.guillou at libreoffice.org> ---
Thank you all for your input.

So "Tools > Options > Calc > Calculate > Case sensitive" is a compatibility
setting for formulas' comparison operators, see also corresponding help:
https://help.libreoffice.org/24.2/en-US/text/shared/optionen/01060500.html#bm_id3151205
... so I understand we shouldn't mix "pure GUI" string data validity in it.

Workaround in Comment 1 is useful, but I think the feature suggested here would
be welcome: an extra setting in the Validity dialog (which I think should be
limited to the Cell Range and List options).
However, I want to hear the UX/Design team's opinion as well.

---

As a side note, I've noticed a slight UI discrepancy (at least with the gtk3
VCL plugin):

The lowercase version is accepted when entered, but when clicking the dropdown
to see available values, the uppercase version listed in it is not highlighted
(which might give the impression to users that it shouldn't be accepted).

-- 
You are receiving this mail because:
You are on the CC list for the bug.