Bug 82926 - scroll bar ineffective in Content field of Form Properties dialog
Summary: scroll bar ineffective in Content field of Form Properties dialog
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
(earliest affected)
Inherited From OOo
Hardware: x86-64 (AMD64) All
: low minor
Assignee: Not Assigned
Depends on:
Blocks: Scrollbars
  Show dependency treegraph
Reported: 2014-08-21 22:29 UTC by Terrence Enger
Modified: 2021-03-20 19:36 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:
Regression By:


Note You need to log in before you can comment on or make changes to this bug.
Description Terrence Enger 2014-08-21 22:29:48 UTC

(1) Download and open file "Company_Cascading_Address_38 (mod).odb"
    attached to bug 82844.  Program displays window
    "Company_Cascading_Address_38 (mod).odb" with <Forms> selected in
    the left pane; the lower right shows the names of two forms.

(2) In the lower right pane, right-click
    fCompanyAddres&Notes16-08-2014@12:16PM, and from the pop-up menu
    select Edit.  Program presents window
    "Company_Cascading_Address_38 (mod).odb :
    FCompanyAddress&Notes16-08-2014@12:16PM"; the icons in the forms
    toolbar at the left are enabled.

(3) In the right side of the form click the table control "Address"
    (not to be confused with the table controls "Bare Address" and
    "Full Address").  Program draws a box with handles around the

(4) Right click on the control and from the pop-up menu select Form.
    Program presents dialog "Form Properties".

(5) Click on tab Data.  Observe that displayed Content type is "SQL
    command" and the displayed content, at least the first line of it,
        SELECT "tAddress".*,
    and a down-arrow at the right offers you the ability to expand the

(6) Click on the down-arrow to exapnd the box.  The box expands to 5
    lines; a vertical scroll bar at the right indicates that that the
    box is showing about half the text.

(7) At the bottom of the scroll bar, click the down-arrow.

    Program action expected: The top line of contents scrolls off the
    top of the box and the next, previously unseen, line scrolls in at
    the bottom.

    Program action observed: The box collapses to the one line
    previously shown.

I am setting bug priority LOW/minor because there are at least three
simple workarounds:
(*) Use the mouse wheel to scroll through the box.
(*) Use the keyboard to scroll through the box.
(*) The <...> button to the right of the field displays the Query
    Design window for the SELECT statement.
Indeed, I think that WONTFIX would be a reasonable resolution.

This behaviour is present in bibisect-43all oldest and in my debug
build of master fetched 2014-08-13.
Comment 1 Robert Großkopf 2014-08-22 14:50:45 UTC
It's the same behavior in LO 3.3.0.beta1.
Scrollbars aren't working in any field of the form-editor and of the field-editor. You could see this behavior in the same form, when you open the listbox lbTypeOfCompany (label: Type Of Company) and have a look at Data → List Content.

... and not only by designing a form. The same when designing a report with the Report-Builder. Don't know why there isn't any existing bugreport for this.
Comment 2 Alex Thurgood 2015-01-03 17:39:38 UTC Comment hidden (no-value)
Comment 3 Terrence Enger 2015-08-08 15:20:11 UTC
First, a correction to the description of this bug: The report with
the referenced attachment is tdf#82884

The problem is still evident in daily dbgutil bibisect repository
version 2015-08-07 ...
    Build ID: 09a9234c021ad98c5adeb493b5814e97b92ee912
    Locale: en-CA (en_CA.UTF-8)
and in a daily build for Win32 ...
    Build ID: 902255645328efde34ddf62227c8278e8dd61ff0
    TinderBox: Win-x86@39, Branch:master, Time: 2015-07-30_03:52:07
    Locale: en-CA (en_CA)

I am setting O/S All.
Comment 4 Robinson Tryon (qubit) 2015-12-14 05:40:05 UTC Comment hidden (obsolete)
Comment 5 Xisco Faulí 2016-09-14 14:45:53 UTC
Only regressions should use the keyword 'preBibisect'. Removing it...
Comment 6 QA Administrators 2018-02-13 03:33:36 UTC Comment hidden (obsolete)
Comment 7 Robert Großkopf 2018-02-13 08:11:37 UTC
Nothing changed in
Build ID: 60bfb1526849283ce2491346ed2aa51c465abfe6
CPU threads: 4; OS: Linux 4.4; UI render: default; VCL: kde4; 
Locale: de-DE (de_DE.UTF-8); Calc: group

Scrollbar in properties a a form (or fields of a form) doesn't work when editing a form.
Comment 8 QA Administrators 2019-02-14 03:49:03 UTC Comment hidden (obsolete)
Comment 9 Terrence Enger 2019-02-16 01:34:15 UTC
I still see the problem in bibisect-linux-64.6.3 repository on 2019-02-15.
Comment 10 QA Administrators 2021-02-16 04:10:14 UTC Comment hidden (obsolete)
Comment 11 Terrence Enger 2021-03-20 19:36:18 UTC
In a local build of commit 005adbef built and running on
debian-buster, I see:

(*) In step (6), the program exands the box to 7 lines; this fully
    accommodates the SQL statement.

(*) If I insert newlines to spread the SQL statement beyond 7 lines,
    Libreoffice adds a vertical scrollbar.  This happens with VCL both
    gtk3 and gen.

I am setting bug status RESOLVED WORKSFORME.