autoinput is being dumb

[Wojtek]

I’m fairly certain it worked in a more sane way ages ago (sorting by the reversed order of column) and now autoinput seems to sort the values (0…9, a…z) or somesuch.

For example let’s consider following set:

12/0/0
12/0/0

12/0/0
12/0/0
12/0/0
12/0/0
12/0/0






12/0/0
12/0/0
0/0/20

0/0/20
0/0/25
0/0/25
0/0/25
0/0/25

0/0/25

0/0/25


0/0/25





0/0/25
0/0/25
0/0/25
0/0/25
0/0/25
0/0/25
0/0/25

Now, when I enter “0” it suggests… yes, of course! “0/0/20”… it doesn’t matter that recently “0/0/25” was used more often and was actually last value.

I think that either using value one-up-that-matches or using statistics (resource consuming, doesn’t make that much sense?) would be more useful… I’m aware about AutoInput - LibreOffice Help but using alt+arrow-down or ctrl+tab is not very handy (as you have to use it all the time to correct the value instead of confirm the value that’s one-up)

[mark_t]

Looks like it searches for the first match in sequence from top to bottom of the column.

Excel always seems to wait until it find a unique match before it offers a suggestion, so in your case you would have to type 0/0/25 before it found a unique match which would be no help at all.

It might be nice if LibreOffice could give a list of possible matches as you type which you could accept with mouse or down arrow and enter.

I guess you could raise an enhancement bug request over on LibreOffice Bugzilla if it bothers you, but given the size of the bug list it might be better to just let the developers concentrate on more serious problems.

[Wojtek]

That was my idea that it takes all unique values top-to-bottom, but it’s not very handy.

There is an option (linked article) which gives you a drop-down list, but… it requires you to type “0” and then press “alt+down”, then hit down one or more times and hit enter instead “0” → enter.

My first idea was to create a ticket in bugzilla, but… they migrated the accounts from old freedesktop and ‘reset your password’ doesn’t work hence my message here…