Bug 71275 - Other: Enhancement - Number of all records should be shown in a form, not only 41*
Summary: Other: Enhancement - Number of all records should be shown in a form, not onl...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
4.1.2.3 release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords:
: 107434 118415 118885 (view as bug list)
Depends on:
Blocks: Database-Forms
  Show dependency treegraph
 
Reported: 2013-11-05 17:39 UTC by nelson
Modified: 2018-07-30 14:00 UTC (History)
6 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description nelson 2013-11-05 17:39:41 UTC
Problem description: 
When opening a form for data entry, the record number shows 
 1 0f 41, but going to last record shows there are 104 records - and onn return to first record 1 of 104 is (correctly) shown


Operating System: Windows 7
Version: 4.1.2.3 release
Comment 1 Robert Großkopf 2013-11-08 17:08:55 UTC
The form doesn't load the whole table, only the first 41 rows. It is shown by 41*. If you jump to the end of the table you have loaded the whole table and get the exact rows - without '*'.
This is implemented to make work faster and hold only a little bit of the table in the cache.
It is the same behavior in tables. There is shown something like 82* ...
When you will load only a table with 104 records you would say: It doesn't matter. But when there are tables with more than 10000 rows it will last some times, before the form would be ready for input.
Some people solve this by opening a form, let start a macro to "last row" and then to "first row". Others would add a field to the form and let the form start from a query. The field shows the result of "SELECT COUNT("ID") FROM "Table"".

If you wish another behavior, you have to change the Importance to "enhancement".
Comment 2 Robert Großkopf 2013-11-12 19:42:12 UTC
I will change this bug to an enhancement. It works like expected, but could be a good idea to show the number of all records in a navigationbar of a form.
Comment 3 Alex Thurgood 2015-01-03 17:38:45 UTC Comment hidden (no-value)
Comment 4 Alex Thurgood 2017-04-26 12:59:48 UTC
*** Bug 107434 has been marked as a duplicate of this bug. ***
Comment 5 Alex Thurgood 2018-06-27 15:21:34 UTC
*** Bug 118415 has been marked as a duplicate of this bug. ***
Comment 6 Robert Großkopf 2018-07-30 14:00:29 UTC
*** Bug 118885 has been marked as a duplicate of this bug. ***