[Libreoffice-bugs] [Bug 118100] New: VERSION: 5.3.0.3 0 Validity / List (Enhancement Request - Global Updates / Autofill specific to Data List

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 118100
           Summary: VERSION: 5.3.0.3 0 Validity / List (Enhancement
                    Request - Global Updates / Autofill specific to Data
                    List
           Product: LibreOffice
           Version: 5.3.0.3 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: unkerjay at centurylink.net

Description:
VERSION: 5.3.0.3

I really like, whether excel or LibreCalc the ability to expedite data entry.

And, I've noticed two problems with Validity / List that I haven't found any
answers for in looking (maybe I missed them).

1) If I leave something out in a list, it seems, I have to update the list, and
then update all the cells that that list applies to, then I have to update the
data in those cells after having updated the list.

If there's not a global option for updating a list's data after the fact,
that's a ROYAL pain.  Once it works - GREAT.  Having to go through the list
EACH time a change is made and update all the associated cells to reflect the
updated data in the list so that they're all current seems to me REALLY gets in
the way of using Validity / List as an option.  

I would think the ability to apply changes to the list globally to all cells
affected by the data in that list would be REALLY nice.

I'm a pretty good typer and the lists haven't been too long, but, imagine a LOT
of data in a LOT of cells and I'm not sure "frustration" is the most accurate
word for it (although likely one of the more polite words for it).

2) Autofill is nice. But, as it seems to apply to Validity lists, (or in
general) you get autofill AFTER having entered in information either manually
or from the list.

Say for exmaple I have the words "Candies" vs "Candies (Assorted)" in a list.

I can't get to "Candies (Assorted)" without having typed it in first even
though it's in the list.

Perhaps an option to use default Autofill or Autofill from the list (or some
way to make a distinction between the two)



Steps to Reproduce:
In Original Comment

Actual Results:  
In Original Comment

Expected Results:
In Original Comment


Reproducible: Always


User Profile Reset: No



Additional Info:
1) Globally Updated List

2) Autofill based on List rather than default Autofill


User-Agent: Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like
Gecko) Chrome/64.0.3282.140 Safari/537.36

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180610/79f0da69/attachment.html>