Steps how to reproduce with Parallel Dev-Installation of "LibreOffice 3.5.0 Beta1 - WIN7 Home Premium (64bit) German UI [Build-ID: 7362ca8-b5a8e65-af86909-d471f98-61464c4] Windows_Release_Configuration 11-Dec-2011 06:51"
1. open a BigAddressDatabase.odb
(I have a spreadsheet based database with 1500 addresses
2. Select table with addresses
3. Click Search Icon, search for an existing string at the end of the address
list 'all fields, anywhere in the field' <find>
> Search starts
Expected: Data set will be found
Actual: Search only in first 20 records, message "not found"
Will work when you went to last record with navigation button before
This one might be related to "Bug 43921 MAILMERGE UI: Display of data sets with NEXT button limited to 10"
Worked with 3.4.4, so regression
Can confirm bug with Windows XP
Can confirm bug with Windows XP
Addition (sorry): LOdev 3.5.0beta3 (Build-ID: e40af8c-10029e3-615e522-88673a2-727f724)
Please feel free to reassign (or reset Assignee to default) if it’s not your area or if provided information is not sufficient. Please set Status to ASSIGNED if you accept this Bug.
How do I get or create a "BigAdressDatabase.odb" file for reproduction?
For me it's reproducible with Bibligraphy database:
1. open new text document
2. <f4> to show databases
> shows only No of records = 40 although 59 are available
3. select Biblio Tables
4. Search for "9782844278340" 'anywhere' (that is ISBN No in last record No 59)
> Will fin nothing
5. click end and back to first record
6. Search for "9782844278340" 'anywhere'
> Now "9782844278340" will be found
OK, reproduced. Plausibly caused by some more aggressive caching.
The German community respectively the de-discuss ML followed your efforts with regard to base with great interest. Thank you for that. Unfortunately none of us can program the source code. But there are some who are familiar with the application including macro programming very well. We would like to support you in your efforts. Please give us know how we can do this best (comments in Bugzilla, private mail, mailing list?).
We would like to ask if Bibligraphy database is an appropriate test-database for you.
Otherwise the following publicly accessible database has been proposed: list of all aircraft registered in the U.S. with their properties and owners. URL: www.faa.gov. Description: about 200 MB as an ASCII file, about 370 000 records. Look for FAA-master ...
(In reply to comment #5)
> 1. open new text document
> 2. <f4> to show databases
> > shows only No of records = 40 although 59 are available
It shows an asterisk (*) after the record count to say "there are at least that many records, but there may be more, I have not counted/loaded them all yet".
The bug was that it stopped searching at the end of the data it had already loaded, not going further and loading data till the end of the table. Fixed that in master (3.6) in commit 1234d599d4ee67bd725f0513431b2d4c56c9e09d. Patch awaits review to go into libreoffice-3-5.
Reviewed and pushed to libreoffice-3-5 by Michael Stahl in http://cgit.freedesktop.org/libreoffice/core/commit/?h=libreoffice-3-5&id=fd29a786e3e94710d1e79c0a6c510491ef461302