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?
Limit of 32676 items in listbox
Limit of 32676 items in listbox
LibreOffice 4.2 on Windows7
Re: limit in listbox
You have to filter this list somehow. 2^15 seems to be a fixed limit.
[Tutorial] Cascading Listboxes with macros
[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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Limit of 32676 items in listbox
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.
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.
Re: Limit of 32676 items in listbox
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.
I think this is the X Y problem once again.
Apache OpenOffice 4.1.16 on Xubuntu 24.04.4 LTS
Re: Limit of 32676 items in listbox
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
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice