Ask Your Question
0

autoinput is being dumb

asked 2016-10-26 22:16:29 +0200

Wojtek gravatar image

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 https://help.libreoffice.org/Calc/Aut... 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)

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2016-10-26 23:43:38 +0200

mark_t gravatar image

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.

edit flag offensive delete link more

Comments

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

Wojtek gravatar imageWojtek ( 2016-10-28 11:02:27 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2016-10-26 22:16:29 +0200

Seen: 46 times

Last updated: Oct 26 '16