Limit of 32676 items in listbox

Discuss the database features
Post Reply
mihmih
Posts: 111
Joined: Wed Feb 18, 2015 9:21 pm

Limit of 32676 items in listbox

Post by mihmih »

Hi,

I have a problem with the contents of listbox in base. I want to display data from one table (40k rows), but the list is limited to 32676 (smalint) items. Can it be changed somehow?
LibreOffice 4.2 on Windows7
User avatar
Villeroy
Volunteer
Posts: 31365
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: limit in listbox

Post by Villeroy »

You have to filter this list somehow. 2^15 seems to be a fixed limit.
[Tutorial] Cascading Listboxes with macros
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
John_Ha
Volunteer
Posts: 9604
Joined: Fri Sep 18, 2009 5:51 pm
Location: UK

Re: Limit of 32676 items in listbox

Post by John_Ha »

Put two listboxes in ...
LO 6.4.4.2, Windows 10 Home 64 bit

See the Writer Guide, the Writer FAQ, the Writer Tutorials and Writer for students.

Remember: Always save your Writer files as .odt files. - see here for the many reasons why.
User avatar
RoryOF
Moderator
Posts: 35223
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Limit of 32676 items in listbox

Post by RoryOF »

With 40,000 items, two sequential listboxes suggests 200 in each. Three linked listboxes would be 34 in each (supposing in both cases that the filtration was regular)

I think this is the X Y problem once again.
Apache OpenOffice 4.1.16 on Xubuntu 24.04.4 LTS
User avatar
Villeroy
Volunteer
Posts: 31365
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Limit of 32676 items in listbox

Post by Villeroy »

Small example splitting Item IDs into 4 categories. The form has 4 listboxes linked to the same ItemID field.
Attachments
Listbox_per_Category.odb
Splitting a list box into four
(13.44 KiB) Downloaded 204 times
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply