Apache OpenOffice (AOO) Bugzilla – Issue 21998
Incorrect number of records displayed and strange scrollbar behavior in Data Sources tables view
Last modified: 2006-05-31 14:29:06 UTC
I seem to be having unusual vertical scrollbar behavior in Data Sources when viewing a table that I believe is due to the incorrect number of records shown near the bottom of the table pane. I think this might be related to Bug #19370, which was resolved as WORKSFORME. Here is the procedure that always causes this problem for me: 1. Open OOo and View Data Sources 2. Right-click Explorer pane and choose Administrative Data Sources 3. Click New Data Source 4. Database Type -> dBase 5. Choose Data Source URL of a database containing a large number of records (in my case, 464) 6. Click OK. Browse to the table of the database just added 7. Near the bottom of the Data Sources window, Record shows "1 of 25". This is incorrect; it should read "1 of 464". The box in the vertical scroll bar is also sized as if there were only 25 records. 8. Click and hold the down arrow on the scrollbar (or the keyboard). As the scrollbar reaches bottom it suddenly jumps back up some and reduces in size. This occurs repeatedly while the window is scrolling. The number of records shown at the bottom of the pane now increases to 39, 52, 65, etc. as this happens. 9. Dragging the scrollbox up and down doesn't allow viewing more than the incorrect number of maximum records shown. 10. To see all records, the Last Record button must be pressed or the table must be scrolled with the down scrollbar arrow until all records appear. Then behavior is correct. 11. Switching views (such as to another table) causes the problem to reoccur. Expected: The maximum number of records should appear correct from the moment the table is first displayed. Actually, this occurs any time any database table with enough records is displayed. I added the extra steps at the beginning to add the database so that this could be tested by anyone else. This is the procedure I used. If no one else seems to be able to reproduce this, maybe I'll just have to play around with different things and see if I can figure out how this is happening.
Hi tgevans, This behaviour is right and intended. We only retrieve a subset of the records in a table. Not until you go to the last record we know the numbers of records in a table. If not all records are read a * is displayed after the record number. I close this issue as invalid. Bye Marc
close
change subcomponent to 'none'