Bug 151105 - BASE-FORMS: Find function refreshes form for each record visited, making search unusable (MacOS only)
Summary: BASE-FORMS: Find function refreshes form for each record visited, making sear...
Status: UNCONFIRMED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.4.0.3 release
Hardware: x86-64 (AMD64) macOS (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2022-09-21 13:16 UTC by Andrew Richardson
Modified: 2022-12-08 03:25 UTC (History)
1 user (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 Andrew Richardson 2022-09-21 13:16:10 UTC
Using LibreOffice 7.2, 7.3, and 7.4, noticed MacOS Base application find was refreshing the UI form for each record visited.  Clearly this adds significant overhead processing to the search function, making find operation essentially unusable.

On Windows, this behavior is NOT observed.  There the UI form is only refreshed once target record has been found.
Comment 1 Alex Thurgood 2022-09-21 16:55:43 UTC
@Andrew : could you give us an example ?

For instance, does it matter which field you search in when using the Search Dialog (presumably the one displayed when clicking on the Binocular icon ?)

Does it matter what kind of database you connect to or does the problem happen with any form, irrespective of the embedded DB or DB-engine backend ?

I don't seem to be able to reproduce this with daily dev build (quite old now)
 
Version: 7.5.0.0.alpha0+ / LibreOffice Community
Build ID: 5aa3f046f934092fbfd7cc92b93d79b4f548cc13
CPU threads: 8; OS: Mac OS X 12.6; UI render: default; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: en-US
Calc: threaded


Perhaps I'm missing something ?
It would help if you provide a detailed set of instructions for reproducing the issue, and a sample database file against which we could test.
Comment 2 Alex Thurgood 2022-09-21 17:06:26 UTC
Have tried testing this in a form which has a subform, and a total of about 30 fields, connecting to a mysql database, but still couldn't reproduce.

Version: 7.4.1.2 / LibreOffice Community
Build ID: 3c58a8f3a960df8bc8fd77b461821e42c061c5f0
CPU threads: 8; OS: Mac OS X 12.6; UI render: default; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Calc: threaded

1) Opened the Search dialog (binoculars or magnifying glass icon, depending on icon set)
2) Typed a search string in the Search Text field
3) Chose to carry out the search over all fields
4) Executed the search.  

For me, the form only refreshes to display the record in which a search hit is found.
Comment 3 Andrew Richardson 2022-12-07 23:49:43 UTC
Unfortunately I have separated from the employer where the MacOS software was being used, and I do not have access to a Mac machine to create a demo.

The original issue was observed using forms with two levels of sub-forms (i.e. customer->reservations->invoices).  When using older versions of LO 6.x, the search function worked fine using the same forms on MacOS.  This issue reported seems to be new with LO 7.x.

I understand this issue may remain an open issue without a way to easily replicate.
Comment 4 QA Administrators 2022-12-08 03:25:58 UTC Comment hidden (obsolete)