Ask Your Question

Autocomplete after 100 rows in Calc

asked 2019-02-22 09:26:49 +0200

Giorgi gravatar image

updated 2020-07-19 19:33:24 +0200

Alex Kemp gravatar image

I had a problem I was struggling with for the few days, and finally I've identified and narrowed down this problem to the particular question. I have some tabular data (let's say, dictionary, or some listing or whatever..) in LibreOffice Calc. As this document has hundreds of records, I can't check for duplicates for particular column entries manually, when I'm entering the new entry (row). I.e. if data has 5 columns, and I want the first column to be unique, when I'm entering the word there, MS WORD automatically highlights autocomplete if that word was already entered somewhere above. LibreOffice does that as well, BUT ONLY in the case if current column is NO MORE THAN 100 rows is far from the possible duplicate value. E.g. if 4th row's first column value is "String", and if I start typing "str.." in any row <=104, autocomplete highlight would work, if I'll try that in row 105, autocomplete won't work, thus I can't be able to know whether the data I'm entering is already filled in somewhere above.

Sorry for a long question, but I wanted it to be as clear as possible. I really need your help, as I'm the one who tries to move from MS to LibreOffice. Prove yourself, please :)

Thank you!

edit retag flag offensive close merge delete


It could be a bug. At Bugzilla you can check if there is already a bug for this problem.

And please read the guidline. Which OS and LO-Version do you use? Which file types do you use? Please send more details.

ebot gravatar imageebot ( 2019-02-22 10:18:04 +0200 )edit

I use Windows, LibreOffice 6.2.0 Calc. Problem is in .ods file.

Giorgi gravatar imageGiorgi ( 2019-02-22 10:34:45 +0200 )edit

Can you anonymize the file and upload it here? To upload please edit your question.

ebot gravatar imageebot ( 2019-02-22 11:16:01 +0200 )edit

No, I can't. It contains some data.. but you don't need that. You can just reproduce what I've said: For instance, create dictionary, with two columns [Eng] and [Spanish]. At some point you'll have more than 100 rows.. so if on the 101st row you are entering a new word, Calc won't highlight with autocompletion whether that word has already been used somewhere above or not.. but it you enter the same word before the distance of 100 rows, than it will.

Giorgi gravatar imageGiorgi ( 2019-02-22 11:26:51 +0200 )edit

I can confirm that a limit does exist; however, for me (using on Win10), it's 202 rows.

Mike Kaganski gravatar imageMike Kaganski ( 2019-02-22 12:26:10 +0200 )edit

But anyhow.. even 5000 is not good to have as limit. I don't want to have this limit.. I want Calc to highlight me the possible duplication even after 5000 rows.. what's that? why's that? it's so saddening and disappointing.. :/

Giorgi gravatar imageGiorgi ( 2019-02-22 12:42:08 +0200 )edit

one's feelings are irrelevant on Ask site. What's relevant is if you filed an enhancement request, so that developers evaluate and implement what you need.

Mike Kaganski gravatar imageMike Kaganski ( 2019-02-22 12:48:20 +0200 )edit

@Mike Kaganski, are all Russians that impolite and rude like you are? I hope not.

Giorgi gravatar imageGiorgi ( 2019-02-22 19:20:38 +0200 )edit

If you cannot see two good advises here handed to you - one being to avoid expressing one's feelings in public resources, because that may hurt others, and cause unnecessary problems; and the other being to file a request to let developers know what you need - and take that as offence, then I cannot help.

Mike Kaganski gravatar imageMike Kaganski ( 2019-02-22 19:29:09 +0200 )edit

Google for some online courses on how to communicate and behave in public, how not to respond in comments and etc. I can't help more as well. Ciao.

Giorgi gravatar imageGiorgi ( 2019-02-22 19:30:56 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2019-02-22 17:08:56 +0200

erAck gravatar image

There is some limit (whether it's 100 or 200 or 500 I don't recall), for a reason, because in a populated column you don't want to wait for a list box of a million entries for each cell you enter.

edit flag offensive delete link more


a list box? the suggestions are presented as pre-filled and pre-selected text to the right (LTR) of cursor iiuc. I suppose that simply finding a first value matching the entry (no matter how far) is enough?

Mike Kaganski gravatar imageMike Kaganski ( 2019-02-22 17:12:32 +0200 )edit

What List box? I think you didn't get the problem erAck. Why shall I have millions of entries in one column even if there really are similar records in say millions rows? the aim here is to just autofill the box IFF there is at least one row which has the same value in the same column.

Giorgi gravatar imageGiorgi ( 2019-02-22 19:22:28 +0200 )edit

I confused that with Alt+Down which lists all previous entries. Might even be those two use the same code. However, to suggest/autocomplete a pending input still all rows of the column would have to be searched with each key input until there is no match.

erAck gravatar imageerAck ( 2019-02-22 20:09:49 +0200 )edit

Lol. Now I'm trying to register a new account and submit a bug-report. It says my email will go public to all the registered members.. seriously? what if strange thing happens and I don't love the idea to spread my email to everyone around? :) quite strange, really.

Giorgi gravatar imageGiorgi ( 2019-02-23 10:14:24 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-02-22 09:26:49 +0200

Seen: 203 times

Last updated: Feb 22 '19