The row limit of 16,385 in data filter functions (excluding duplicates) makes using LibreOfficeCalc difficult.
FIX THIS!!!
Bug 36875 Fixed yet? Is a question you could answer for yourself by looking at the bugzilla site
FIX THIS!!! is a statement that will get you nowhere on a question and answer site like this
fdo#35875 · Status: RESOLVED WORKSFORME (LO 3.6.x) · Follow-up → Filter Row Limit Bug 36875 fixed? I noticed it is still a bug in rel 3.5.2.2