Bug 145191 - Hidden tables shouldn't set automatically write protected
Summary: Hidden tables shouldn't set automatically write protected
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Base (show other bugs)
Version:
(earliest affected)
7.2.1.2 release
Hardware: All All
: medium enhancement
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-10-18 05:49 UTC by Robert Großkopf
Modified: 2021-10-19 11:09 UTC (History)
0 users

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 Robert Großkopf 2021-10-18 05:49:36 UTC 
Download https://bugs.documentfoundation.org/attachment.cgi?id=175795
Open the database.
Start in pane "Queries" the query "Query_Starter". 
Content of the query will be shown. 
Query is write protected.
SQL here: SELECT * FROM "starter"

Close query.
Go to Tolls → Table Filter… and set "starter" visible.
Go to pane "Tables".
Set View → Refresh Tables.

Back to pane "Query" and start "Query_Starter".
Query is now writable.

There is no reason to set a hidden table only readable. Setting tables unvisible is only for getting a better overview. Every user of the database could set it back to show all tables.
Comment 1 Alex Thurgood 2021-10-19 11:08:31 UTC 
Confirming with

Version: 7.2.1.2 / LibreOffice Community
Build ID: 87b77fad49947c1441b67c559c339af8f3517e22
CPU threads: 8; OS: Mac OS X 10.16; UI render: default; VCL: osx
Locale: fr-FR (fr_FR.UTF-8); UI: fr-FR
Calc: threaded