Bug 166156 - The table filter can not be removed
Summary: The table filter can not be removed
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
Inherited From OOo
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Database-Tables
  Show dependency treegraph
 
Reported: 2025-04-12 19:13 UTC by Andreas Säger
Modified: 2025-09-08 14:08 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Connecting database document with 3 visible tables and 3 hidden ones. (29.40 KB, application/vnd.oasis.opendocument.database)
2025-04-12 19:13 UTC, Andreas Säger
Details
Connected spreadsheet document with 3 sheets and 3 database ranges. (33.26 KB, application/vnd.oasis.opendocument.spreadsheet)
2025-04-12 19:14 UTC, Andreas Säger
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Andreas Säger 2025-04-12 19:13:39 UTC
Created attachment 200327 [details]
Connecting database document with 3 visible tables and 3 hidden ones.

This is not about filtering data. It is about Base menu:Tools>"Table Filter..." which allows hiding database tables, which is particularly useful when the Base document is connected to a spreadsheet document.
Store the attached documents in one directory.

The spreadsheet contains 3 sheets with English names "People", "Groups", "Reservations" plus 3 database ranges with German names "Studenten", "Gruppen", "Belegung".

In the connected database document, I called menu:Tools>"Table Filter..." in order to hide away the English sheet names. These tables refer to the entire used areas of the respective sheets, which use to contain more data than the mere lists. The database ranges help to separate the lists from other sheet content.

First issue: I had to call menu:View>"Refresh Tables" to effectively hide the tables, which should not be required for GUI interactions.

Second issue: I'm not able to unhide the hidden tables because the dialog does not show them.
Comment 1 Andreas Säger 2025-04-12 19:14:23 UTC
Created attachment 200328 [details]
Connected spreadsheet document with 3 sheets and 3 database ranges.
Comment 2 Andreas Säger 2025-04-12 19:24:59 UTC
Work-around:
1. menu:Tools>"Filter Tables..." and uncheck the root element "All Tables" in the filter dialog.
2. menu:View>"Refresh Tables" 
3. menu:Tools>"Filter Tables..." and check the root element "All Tables" in the filter dialog.
4. menu:View>"Refresh Tables"
Comment 3 m_a_riosv 2025-04-13 01:18:18 UTC
Reproducible
Version: 25.8.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: ddc3cf99a47cb76e1386783df782e4852a19307a
CPU threads: 16; OS: Windows 11 X86_64 (build 26100); UI render: Skia/Vulkan; VCL: win
Locale: es-ES (es_ES); UI: en-GB
Calc: CL threaded