Bug Hunting Session
Bug 118100 - VERSION: 5.3.0.3 0 Validity / List (Enhancement Request - Global Updates / Autofill specific to Data List
Summary: VERSION: 5.3.0.3 0 Validity / List (Enhancement Request - Global Updates / Au...
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All Linux (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-06-10 19:50 UTC by Mike
Modified: 2018-12-09 20:26 UTC (History)
2 users (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 Mike 2018-06-10 19:50:35 UTC
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
Comment 1 Mike 2018-06-10 19:52:38 UTC
Note:  I entered the Version using Palemoon (older) browser and it bombed EVERY time based on failure to acknowledge the VERY SPECIFIC version I entered EVERY time.

I had to re-enter all the info in Google Chrome instead.  A royal pain.

Perhaps a disclaimer as to what browsers it does and does not work with might help.
Comment 2 Buovjaga 2018-06-22 16:29:27 UTC
Skimmed through the meta for validity and none of your suggestions seem to have been filed before: https://bugs.documentfoundation.org/showdependencytree.cgi?id=108988&hide_resolved=1

We take one issue per report, but let's throw this on UX team's table and if they accept both, you can open a new report for one of them.

Would also be good to verify the behaviour is the same in an up-to-date version. If packages are a problem for you, you can try an appimage: https://www.libreoffice.org/download/appimage
Comment 3 Heiko Tietze 2018-06-25 08:42:28 UTC
(In reply to Buovjaga from comment #2)
> We take one issue per report, but let's throw this on UX team's table and if
> they accept both, you can open a new report for one of them.

I don't understand any of the requests.

(In reply to Mike from comment #0)
> 1) If I leave something out in a list, it seems, I have to update the list...
> 2) Autofill is nice. But, as it seems to apply to Validity lists...
Comment 4 Cor Nouws 2018-12-04 20:03:19 UTC
(In reply to Mike from comment #0)

> 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.
Link validity to a list in a cell range. Any change in that range will be available for validating.
Updating cells that have been filled with validity before.. Nope > Use a database for that ;)

> If there's not a global option for updating a list's data after the fact,
> that's a ROYAL pain.
See my explanation above.

==> WFM (this question)
Comment 5 Cor Nouws 2018-12-04 20:05:23 UTC
Hi Mike,

(In reply to Mike from comment #0)

> 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.

menu Tools > AutoInput allows you to turn off 'autofill'
Does that help enough in your case?
Personally I'd rather avoid using Validity in combination with AutoInput.
Comment 6 Heiko Tietze 2018-12-06 13:42:28 UTC
Cor, please handle this request. Set WFM if you think it makes no sense to change the workflow.
Comment 7 Cor Nouws 2018-12-09 20:26:52 UTC
confrom comment #4 and comment #5 wrong or no clear understanding of features. No respons on the comments nor on comment #3 - 6 months ago. => WFM