How to correct Err:540

English
#1

I get Err:540 when trying to link to other spreadsheets…google shows very old info about it.

When clicking on ‘Edit’ it does not show any further links…what it does show is settings for printing. Which isn’t in any way the problem.

I do not have a Menu bar and can’t find out how to get it to show up so far (new installation of Ubuntu 24.04.1 which also installed LibreOffice…the menu bar is missing) but when I right click any of the top menu icons, none of those drop down lists show ‘TOOLS’ so I can’t follow that fix as shown on Google AI.

Additionally, going to LO online help and searching shows ZERO info on any Err: code. Very strange I have to use Google to show what error definition in LibreOffice might be…unfortunately, those seldom have a date so often are too old to help.

I did find this recent fix at 'https://bugs.documentfoundation.org/show_bug.cgi?id=135108, from 2024 where I’m supposed to click on: Tools → Options → Calc → General

Unfortunately, without having a menu bar (bar with File, Tools, etc. all listed in text not icons across the top of the sheet above the simple icons), I do not have a ‘Tools’ option anywhere on any of my SSs or any drop downs on the main LibreOffice suite page. Without the Menu bar, I’m stuck.

Anyone know how to invoke the menu bar and lock it in place? That will be a starting point. Thanks.

#2

Help (F1) page for error codes (search for error code) Error Codes in LibreOffice Calc

Maybe look in Edit > Links to external files

If you are using the tabbed interface then click the menubar icon to toggle visibility of the menubar is at the very left.
MenubarIcon
.
There is a hamburger icon at the right of the tabbed interface, click on that if you want to change the User interface to Standard.

[Edit]
See also Top action bar in LibreCalc is missing. How to get it back?

#3

I don’t have anything on my SS’s that look like that. I have the Title bar, than on the next menu bar a ‘New’ icon, along with many many other icons. The 3rd menu bar has Arial font drop down. The 4th bar shows the active cell that has focus. There is no Hamburger anywhere on the page. And no way that I know of to turn it on.

What I’m missing is any menu bar that has the typed words, ‘File; Edit; View’ etc. etc… Which has the Tools, Preferences, etc. in one of the drop down menus attached to them.

Screenshot at 2025-01-01 18-03-04
Screenshot at 2025-01-01 18-03-04955×1051 172 KB

#4

We can add the menubar icon to the start of the top toolbar:

  1. Right click the top toolbar and select Customise toolbar
  2. In the dialogue that appears, select the Toolbars tab
  3. Click on the top item in the assigned commands pane to select where the new icon will go beneath.
  4. In the search field type menubar and select the command if not already selected.
  5. Click the right facing arrow to add the Menubar icon to the Assigned Commands pane
  6. click OK

Click on the new icon to toggle visibility of the menu.


You could instead create a keyboard shortcut

  1. Right click the top toolbar and select Customise toolbar
  2. In the dialogue that appears, select the Keyboard tab
  3. In the Functions field search for menubar
  4. Next to the top pane select LibreOffice option button
  5. In the top pane, select a suitable, empty shortcut combination, e.g. Alt+M
  6. Click the Assign button. Click OK

Press Alt+M to toggle visibility of the menubar

Top action bar in LibreCalc is missing. How to get it back?
#5

That’s all pretty cool, except all it does is put a new icon on the far left of the 2nd top menu bar (under the exit bar). Rgt Click on that it shows a very long list of non-alphabetized options, none of which are File, Edit, View, etc. etc. There is an Edit selection but it’s for Print Ranges.

I’ll reboot and see if that does anything but it’s late so I’ll check it tomorrow and do a keyboard shortcut.

#6

Why right click? Just click. If the menubar doesn’t appear then the installation is broken somehow.

#7

If I just click on the new icon all it does is go grey. Nothing else happens. So I did the only other thing available, right clicked on it. But it does not return the missing menu bar by clicking on it.

This AM, I remembered that I have a back up computer and it has LO Ver 24.2 on it so I’m going to see if I can copy the ‘User’ file over to my main computer. If that doesn’t work, I’ll uninstall LO and reinstall.

Edit: My backup computer’s version of LO 24.2 does display the top menu bar with File Edit View Insert…Tools…etc.

Back on this computer I did a full uninstall: “sudo apt autoremove” followed with “sudo apt purge libreoffice*”

Tested that it was gone, than did “sudo apt install libreoffice”

Opened LO and chose a Calc SS and…the missing menu bar is still missing.

What in the heck!!?? According to the purge instructions the purge should have removed everything related to LO and started fresh when I reinstalled. But doesn’t?

I guess the only thing left to do is try Open Office again. Haven’t used it for years.

EDIT: As a last test before removing LO, I rebooted into Ubuntu Gnome desktop and the menu bar is back. Then rebooted into Cinnamon desktop and again, the menu bar is there. SO…this tells me it’s specific to Mate desktop and obviously some configuration setting I set without knowing it would affect LO. I’ve checked several of my known settings (it has been a couple weeks since install of 24.04 so I can’t recall them all) and tried changing them to no avail. Anyway, I’ll keep trying to find out what it is in Mate that suppresses that top menu bar in LO. Which seems weird.

EDIT: MATE TWEAK is the culprit. I was using a custom Panel layout. Changing to Cupertino restored the missing menu bar in LO. WHY??? The blurb in MATE Tweak says “Select a panel layout to change the user interface”. It is very weird to me that a Tweak app would change the default look of a software program.

#8

It is quite clear that Mate Tweak is used to modify menubars amongst other settings,
MateTweakMenubar

see Panel Customisation | Features | Ubuntu MATE

#9

What did you expect then as “change of user interface”…
.
Anyway: If the tweak works as expected (by me) your menu should always been at the top of your screen, as Apple has only one menu, wich changes with the active window.
.
Compare the screenshot in this thread:
https://www.reddit.com/r/debian/comments/ydjgil/setting_up_the_cupertino_layout_on_debian_mate/?rdt=34029

The menu has disappeared (continued)

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.