Edit: Changed subject, was Disable filters Make your post understandable by others -- MrProgrammer, forum moderator |
Disable filters when protecting a sheet
Disable filters when protecting a sheet
Excel has an option to disable the filters when protecting a sheet. Does OpenOffice have the same? If no, is there any workaround to prevent users from using the filters?
Last edited by MrProgrammer on Mon Aug 28, 2023 4:58 am, edited 1 time in total.
Reason: Edited topic's subject
Reason: Edited topic's subject
LibreOffice Version: 7.2.7.2 (x64) on Windows Server 2019 Datacenter version 1809
Re: Disable filters
The 7.2.7.2 version is not OpenOffice, but that is LibreOffice. Please fix your signature.OpenOffice Version: 7.2.7.2 (x64) on Windows Server 2019 Datacenter version 1809
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: Disable filters
Thanks, glad you were able to figure that out- boy, what a tragic mistake I made. Good job- catastrophe averted. </sarcasm>
I assume you have no idea then about the answer to my question. Anyone else?
LibreOffice Version: 7.2.7.2 (x64) on Windows Server 2019 Datacenter version 1809
Re: Disable filters
The need for precision in your Forum signature is due to the difference in code bases between Open- and Libre-Office. An answer for one might not be correct for the other.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Re: Disable filters
That's obvious, but if someone is worried about version differences, they ought to be checking version # anyways. Anyhow, let's please stop cluttering up this thread with non-answers. Send me a private message if you feel the need to continue arguing about this.
LibreOffice Version: 7.2.7.2 (x64) on Windows Server 2019 Datacenter version 1809
Re: Disable filters
You're coming across as aggressive and impolite which discourages rather than encourages people from helping you.
A workaround would be to hide the menu and toolbar items
Another might be the Intercept menu commands using Basic section from Useful Macro Information For OpenOffice.org By Andrew Pitonyak
A workaround would be to hide the menu and toolbar items
Another might be the Intercept menu commands using Basic section from Useful Macro Information For OpenOffice.org By Andrew Pitonyak
Windows 10, Openoffice 4.1.11, LibreOffice 7.4.0.3 (x64)
Re: Disable filters
The user interface of the "Sheet protection" function in the LO and AOO are significantly different, but even the LibreOffice can not do directly what you want:
Try to use some tricks as a workaround - like JeJe suggested.
Try to use some tricks as a workaround - like JeJe suggested.
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.