Bug 61949 - EDITING: Form designer should make available property fetchSize
Summary: EDITING: Form designer should make available property fetchSize
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
4.0.0.3 release
Hardware: x86 (IA32) Windows (All)
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Database-Forms
  Show dependency tree / graph
 
Reported: 2013-03-07 08:59 UTC by Juetho
Modified: 2022-11-06 15:13 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Juetho 2013-03-07 08:59:49 UTC 
When opening a form at runtime and using a small data table (between 50 and 300 rows), it's not possible to see all rows at once. Either the user has to move to the last row (and wait some seconds - see bug 52170); or the designer has to link a macro to the form where the fetchsize property is set to an appropriate value.

It would be more useful to set the fetchsize property in the form's properties within the form designer. A more general way would be to set the default fetchsize in the menu Tools / Options / Base.

Robert Grosskopf wrote in a German forum that a Linux version of LO 3.6 loads nearly 100 rows. My Win7 version is loading only 40 rows: Version 4.0.0.3 (Build ID: 7545bee9c2a0782548772a21bc84a9dcc583b89) as well as Version 3.6.3.2 (Build ID: 58f22d5).

Juergen
Comment 1 Joel Madero 2013-03-07 17:32:57 UTC 
Lionel - can you comment on this one? I'm not sure about the technical details here. Thanks!
Comment 2 Lionel Elie Mamane 2013-03-11 09:43:43 UTC 
That's a valid enhancement request, that amounts to "please give some UI to set the default value of fetchSize, which can be changed programatically but not by the user through thui UI".
Comment 3 Alex Thurgood 2015-01-03 17:40:14 UTC Comment hidden (no-value)