Bug 147110 - Search in record not shown and not Cancel button
Summary: Search in record not shown and not Cancel button
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: UI (show other bugs)
Version:
(earliest affected)
6.4 all versions
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Database
  Show dependency treegraph
 
Reported: 2022-02-01 16:23 UTC by jcsanz
Modified: 2023-10-06 05:06 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
HSQL Database with big tables to test the bug (1.63 MB, application/vnd.sun.xml.base)
2022-02-01 16:23 UTC, jcsanz
Details

Note You need to log in before you can comment on or make changes to this bug.
Description jcsanz 2022-02-01 16:23:05 UTC
Created attachment 177963 [details]
HSQL Database with big tables to test the bug

In Base, with an open table, you can search using the "Edit > Find record" command.

If you do the search in all fields, the "Status" zone shows how the records advance and the Search button caption changes to "Cancel" to be able to cancel the operation (that is ok); but if you do the search by "Single field", although the search is running, the "Record" number is not modified and the Search button continues showing the caption "Search", so the user does not know if the operation is running and, if the user realizes that it is running, he does not know how to cancel the search. Since searches sometimes take a long time to run, it may appear to the user that Base is not working.

Steps to reproduce it:
    1. With Base, open a database.
    2. Open a table (preferably one that has many records, so that you have time to see the error).
    3. In the window of the table, in the menu, select "Edit > Find record..."
    4. In the dialog, in "Search for" put anything, preferably that is not in the table (so that the search time will be longer and you can see the problem).
    5. In "Where to search" select "Single field"
    6. Click on "Search" button
    7. In "State" the record number does not change. 
    8. In Windows, the "Search" button text does not change; in Linux, the button is grayed out, as if it were not enabled, but the caption doesn't change either.

Expected effect:
    1. In step 7 above, it is expected that in "State" the "Record" number will advance as the search progresses
    2. In step 8 above, the button text is expected to change to Cancel, become enabled, and the search can be cancelled.

------------------------------
Version: 7.2.5.2 (x64) / LibreOffice Community
Build ID: 499f9727c189e6ef3471021d6132d4c694f357e5
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: en-US
Calc: CL
-------------------------------
Version: 7.1.7.2 / LibreOffice Community
Build ID: 10(Build:2)
CPU threads: 2; OS: Linux 5.11; UI render: default; VCL: kf5
Locale: es-ES (es_ES.UTF-8); UI: es-ES
Ubuntu package version: 1:7.1.7-0ubuntu0.21.04.1
Calc: threaded
--------------------------------------------
Version: 6.4.7.2 (x64)
Build ID: 639b8ac485750d5696d7590a72ef1b496725cfb5
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: default; VCL: win; 
Locale: es-ES (es_ES); UI-Language: en-US
Calc: CL
Comment 1 Robert Großkopf 2022-02-02 06:57:47 UTC
I have use the table "PAYMENT" of the attached database.

Row will always be shown as "1".

Button "Cancel" won't be activated during searching through the data of one field. 

The button will only be activated after the dialog "No row found" will appear. But after closing the dialog the "Cancel" button will disappear.

Version: 7.3.0.3 / LibreOffice Community
Build ID: 0f246aa12d0eee4a0f7adcefbf7c878fc2238db3
CPU threads: 6; OS: Linux 5.3; UI render: default; VCL: kf5 (cairo+xcb)
Locale: de-DE (de_DE.UTF-8); UI: de-DE
Calc: threaded

Note: This are two bugs. Could you please split it in the title for "record number" and "Cancel button"?
Comment 2 jcsanz 2022-02-02 09:06:26 UTC
(In reply to Robert Großkopf from comment #1)
 

> Row will always be shown as "1".
Why? If you search in all fields, the row number changes, so you can see the progress of the search, I expect the same if I search in only one field
 
> Button "Cancel" won't be activated during searching through the data of one
> field. 
Again, Why not? If you search in all fields, the button change to Cancel and is active, Why it is supposed that if I search in one field I don't need to cancel if the search is taking to much time or I realize that I have make a mistake in the word I i'm searching

> The button will only be activated after the dialog "No row found" will
> appear. But after closing the dialog the "Cancel" button will disappear.

After no row found, IMHO, the button should be Search, to try a new one. While the search is in progress it is needed a Cancel button to cancel the search if, for example, it is taking too much time.

> 
> Note: This are two bugs. Could you please split it in the title for "record
> number" and "Cancel button"?

Aren't both of them enough related? I think both are in the same action, in the same dialog...
But Ok, how can I split it without loss of reference to this one?
Comment 3 jcsanz 2022-02-02 11:20:41 UTC
I have realize that if, while it is doing a search in record, although the button show the caption Search, if I clic in it, it cancels the search. After cancel, shows the record number in which it was canceled
Comment 4 Robert Großkopf 2022-02-02 14:23:12 UTC
(In reply to jcsanz from comment #3)
> I have realize that if, while it is doing a search in record, although the
> button show the caption Search, if I clic in it, it cancels the search.

And this button seems to be deactivated, but it works as "Cancel". Might be a GUI-problem. I will switch the component to UI.
Comment 5 jcsanz 2022-02-02 15:47:22 UTC
Yes, it seems to be a UI problem. I’ve tested with some different OS and LO versions, doing the next steps:
    1. Open a database with Base
    2. Open a big table
    3. Select “Edit > Find record…” en the table window menu
    4. In the dialog, in "Search for" write something
    5. In "Where to search" select "Single field"
    6. Click on "Search" button

Expected results
    • The search button caption changes to “Cancel” and remains active
    • The “Close” button inactive
    • The “Field” number changes as the search runs
    • If Cancel button clicked the search stops

Obtained results:
--------------------------------------------------
Ubuntu Gnome
Version: 7.1.6.2 / LibreOffice Community
Build ID: 10(Build:2)
CPU threads: 2; OS: Linux 5.11; UI render: default; VCL: gtk3
Locale: es-ES (es_ES.UTF-8); UI: es-ES
Ubuntu package version: 1:7.1.6-0ubuntu0.21.04.1
Calc: threaded

The result is OK, as expected

--------------------------------------------
Windows 10
Version: 7.2.5.2 (x64) / LibreOffice Community
Build ID: 499f9727c189e6ef3471021d6132d4c694f357e5
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: es-ES (es_ES); UI: es-ES
Calc: CL

The results are
    • The search button caption does not change to “Cancel”  and remains as active
    • The “Close” button shown as active, but is inefective (don’t close the dialog)
    • The “Field” number doesn’t changes as the search runs
    • If Search button is clicked the search stops

----------------------------------------------------
Linux Mint Mate 20.01
Version: 7.1.4.2 / LibreOffice Community
Build ID: 10(Build:2)
CPU threads: 2; OS: Linux 5.4; UI render: default; VCL: gtk3
Locale: es-ES (es_ES.UTF-8); UI: es-ES
Ubuntu package version: 1:7.1.4~rc2-0ubuntu0.20.04.1~lo1
Calc: threaded

The result is OK, as expected

-------------------------------------------------------
Ubuntu 21.04 KDE
Version: 7.1.7.2 / LibreOffice Community
Build ID: 10(Build:2)
CPU threads: 2; OS: Linux 5.11; UI render: default; VCL: kf5
Locale: es-ES (es_ES.UTF-8); UI: es-ES
Ubuntu package version: 1:7.1.7-0ubuntu0.21.04.1
Calc: threaded

The results are
    • The search button caption changes to “Cancel” but is shown as inactive
    • The “Close” button shown as inactive, and don’t close the dialog if clicked
    • The “Field” number doesn’t changes as the search runs
    • If Cancel button is clicked the search stops