[Libreoffice-bugs] [Bug 40291] Data validity with "cell's selection" is limited to 16384 records.

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=40291

GerardF <gerard.fargeot at orange.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |gerard.fargeot at orange.fr

--- Comment #1 from GerardF <gerard.fargeot at orange.fr> 2011-08-22 10:10:56 PDT ---
Do you think a dropdown list with more than 2^14 items is useful ?

Waiting an anwser for a dev, a workarround :
name the cell range "villes" and use the formula above for source of validity :
IF(LEFT(villes;LEN(A2))=A2;villes)
check the box "sort entries ascending".

Then enter in A2 the beginning of the word (1 or more letters), press Alt+Down,
the list will shaw only the word beginning with your letters (less than 16384).

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.