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