How can I display different toolbars on different calc worksheets?

DonLow · April 28, 2016, 3:01pm

If I change the toolbars that are displayed on a calc spreadsheet, Calc then displays those toolbars on every spreadsheet I open. I want different toolbars visible on different spreadsheets. Specifically, I want to design protected forms and have them open with no toolbars showing. But when I open Calc, I want it to open with toolbars showing.

PYS · April 28, 2016, 6:06pm

Hi

With Tools▸Customize▸ToolBars tab▸New you can create your custom toolbars and save them in the spreadsheet. They will therefore be specific to this spreadsheet.

Regards

DonLow · April 30, 2016, 5:34am

I appreciate the information, but I don’t want to create (or even modify) toolbars on these sheets. I want to remove the toolbars. For the saved sheet only. Is there a way to do that?

DonLow · April 30, 2016, 5:34am

I appreciate the information, but I don’t want to create (or even modify) toolbars on these sheets. I want to remove the toolbars. For the saved sheet only. Is there a way to do that?

PYS · April 30, 2016, 6:08am

It would be possible to hide / show the toolbars by macro but it is not 100% sure because the user may not allow the execution of macros …

Ratslinger · April 30, 2016, 4:29pm

My apologies. While I thought it was working, further testing showed if a toolbar was wanted to be shown, another opened sheet could actually turn it off! Modifications work fine, just not the on/off status.

What pierre-yves-samyn states is one direction which I can elaborate upon. Keep in mind you cannot make it foolproof.

Changes to either menus or toolbars can be made in Tools▸Customize for a specific sheet when you change Save In from LibreOffice Calc to the name of your sheet (use dropdown). So here is the approach you can use:

Go to Tools▸Customize & Toolbars tab. VERY IMPORTANT - Change Save In from LibreOffice Calc to the name of your sheet (use dropdown). Next, near the top, in the dropdown select the toolbar you want to modify/eliminate . In Toolbar Content Commands remove check marks from items not wanted. Repeat for other toolbars.
In order to stop a user from turning these on again, eliminate selections from the Menu. Go to Tools▸Customize & Menus tab. VERY IMPORTANT - Change Save In from LibreOffice Calc to the name of your sheet (use dropdown). Next, near the top, in the dropdown select View for the Menu. In Menu Content Entries scroll down to Toolbars & single left mouse click to select. Now click the Modify button to the right & select Delete. Change any other items you may also want to eliminate (ie: Tools▸Customize).
When finished select OK and save your sheet.

Now only this sheet will have specialized Toolbars and other Calc sheets will remain unaffected. The remaining problem occurs when YOU wish to make changes to this sheet and need access to the deleted items. The .ods file is a compressed archive containing many files. Open the .ods file using an archive program (I use ‘Archive Manager’ in Linux) to expose the underlying files. Double left mouse click the ‘Configurations2’ folder. Now you will see one or more folders - accelerator and if the Menu items were changed menubar and if the Toolbar items were changed toolbar. Deleting the menubar and/or toolbar folders and closing the archive manager will restore the sheet to its’ original form.

Again not foolproof (certainly anyone can see this post) but it does add a level of security and doesn’t require macros ( which can also do the same things discussed). Also remember to make backup copies before deleting folders in the archive. Then you can use the backup to restore the folders.

DonLow · May 1, 2016, 3:30am

Thank you, thank you, thank you. This is what I needed to know. Thank you so much. Security is not really the issue. These are forms I am making, based on forms already being used, for a non profit with volunteers doing the paperwork. I need the simplicity or not having the toolbars visible. Thanks again.

DonLow · May 2, 2016, 2:52pm

Well, I thought I could do this, but apparently I am too thick headed. I cannot find any way to remove the formula bar from a sheet, while leaving it displayed on Calc. And now, I’m having other sheets displaying strangely when I open them. Totally confused. It just seems like it should be simple to save a sheet the way it appears when changes have been made, and have it appear that way when it is next opened. Apparently not.

Ratslinger · May 2, 2016, 3:12pm

If other spreadsheets are displaying strangely, the probable cause is not setting ‘Change Save In from LibreOffice Calc to the name of your spreadsheet (use dropdown)’ correctly. Also you may change a toolbar/menu back to its’ original condition using the Reset button (make sure the correct toolbar/menu is selected).

DonLow · May 3, 2016, 12:03am

OK. That is probably what happened. In my frustration, I failed to make sure I had the correct “Save In” selected. BUT, I still haven’t found a way to remove the “Formula Bar” from a sheet so that it will stay removed. Any insight into this?

Ratslinger · May 3, 2016, 12:54am

I believe you have found a bug. There is no selection in Calc Customize to change Formula Bar. However, (at least in LO v5.1.1.3) turning it on/off is listed twice - once under View->Formula Bar and again under View->Toolbars->Formula Bar. To report see this page under the section ‘Bugs’.

Ratslinger · May 4, 2016, 6:26pm

After all that, the formula bar is mistakenly listed in View->Toolbars->Formula Bar. It is not a “Toolbar” as such but similar to the “Status Bar” thus no modifications - It’s either on or off from the View menu. It may still be able to be turned off from a macro but, as mentioned, user may not allow.