Dubious Experience After Reboot on MacOS. How much is configurable?

I’m running LibreOffice 26.2.0.3 on MacOS 15.5. I only use Calc; all the other components of LibreOffice came along for the ride. I recently rebooted the Mac with an unknown number of Calc spreadsheets open, possibly zero. The Mac was told to reopen any windows it had open at reboot.

I wound up with one LibreOffice window, inviting me to select from 14 document choices. Two of those on the first screen of choices have identical names, though the images are different. None of the names include the file extensions, so odds are that’s the actual difference between the two files. Many of the choices have not been opened for weeks.

This contrasts sharply with a reboot on Kubuntu, possibly with a slightly different (earlier?) version of LibreOffice. In that case I definitely had at least 3 calc spreadsheets open at the reboot, though all had been saved since I last modified them. In that case I got a suggestion that I “recover” 5 spread sheets, including the 3 I knew had been open. That was a bit weird, given that I’d saved them, but at least comprehensible.

What happened on the Mac? Is this the screen I’d have gotten if I’d launched LibreOffice manually? Does it remember what files were open on the Mac, as it seems to on Linux, or is this just a hard to understand list of “recent” documents, with their extensions unaccountably concealed? (Reading the screen itself, I’d think it was a list of all documents, much like I’d have gotten from the Finder (aka File app) or ls ~/Documents, perhaps including only files with extensions LibreOffice believes it can understand. It’s not that - if I scroll down below the image I uploaded, I get a document named “Sheet 1-Table 1” - there’s certainly no such file in ~/Documents.)

And most importantly - are there configuration options to have it (a) show file extensions (b) remember/tell me what files it had open (c) limit its idea of “recent” to match my own idea of “recent” (d) lose the images entirely, and give me a selection list similar to the Finder, where 14 choices will fit on a single screen without scrolling?

[Edited to add: as I suspected, this screen is indeed what I get if I launch LibreOffice without specifying a file to open. I’ve also discovered that you can sometimes get the full name of the file as a tooltip, if you do the right thing. This includes the file’s full path.

This solved the mystery of Sheet 1 - Table 1 Its full path is ~/Documents/Borrowed Books/Sheet 1-Table 1.csv That file does not currently exist in the file system. So what I’m looking at is a list of “recent” spreadsheets that doesn’t check whether the file still exists in the file system. Worse, perhaps, is that LibreOffice retains enough information about the deleted file to show a large Thumbnail with readable partial contents.

So now I have another question: under what conditions does LibreOffice retain information the user has deleted? Is there a way to guarantee that LibreOffice no longer retains any copy of sensitive information that may once have resided within a LibreOffice document that’s since been deleted? ]

You could clear the profile or read the following threads:

Yes, see Getting Started Guide 24.8 - Chapter 1, LibreOffice Basics
.
You can see the full name as tooltip by hovering but you will also see cross appear in the top right corner of the thumbnail, click the cross to remove the file link from recent documents.
Note that you can pin frequently used files here.
.
You might like to download the most recent versions of Getting Started Guide and the Calc Guide from English documentation | LibreOffice Documentation - LibreOffice User Guides

Click File > Recent documents. Note that the number of documents on the list can be changed, see Can I access a list of recent documents longer than 10 entries? - #11 by AScot
.
You also have a choice in the Calc, or any module, to show all Recent Documents or just that module’s recent documents.
Note that LibreOffice does not control the operating system, it can only show what it knows to be recent. A file that has been moved or deleted from outside LibreOffice will still show up.

It’s not that I want a shorter list; it’s that I want a useful list, not one artificially lengthened by the addition of thumbnails. I find that text documents look basically identical in thumbnails, so the addition of a picture is of little use identifying the document. These thumbnails are large enough to read, unlike the ones inflicted on me by Gnome, Gnome-derivatives, and KDE, so they aren’t completely useless.

But only a person with an intensely visual mind would think their presence is particularly helpful in distinguishing what are basically text files or text windows. (The developers of Gnome even expect users to distinguish terminal windows by thumbnails. They are either very very visual, or don’t use shell windows, word processor windows, browser windows, or anything else that’s basically text.)

Of course I wouldn’t be happier if the thumbnails were replaced by white space, or by advertisements, as in Duolingo, or by tips on how to better use LibreOffice - my point is that I want the useful information closer together, without the extraneous additions.

On Unix-like systems, the fstat() system call can be used to determine the presence or absence of a file, when it was last modified, and similar things. This could be used to suppress display of no-longer-existing “recent” files.

Presumably Windows has some similar mechanism.

Yes, there’d be a race if someone deleted the file between when LibreOffice launched the window, and when the user selected a file, but given that most systems were LibreOffice is used are single user, the user would probably not be surprised or confused if that happened.

That is available in the menu File > Recent documents. If you cannot see the menu, then click the menubar icon to toggle visibility
MenuBarInTabbedInterface

You can create a shortcut directly to Calc.exe and skip the opening screen entirely.

I was unable to find a separate executable for Calc on MacOS. At the least, there’s nothing named “Calc,” or “LibreOffice - Calc,” or anything similar, in the Applications folder, which is where I do find an App named “LibreOffice.”

I didn’t try very hard though, because in this situation Calc/LibreOffice is being launched by MacOS itself, probably their Desktop Management system, which remembers what you had running at the most recent crash or reboot, and offers to relaunch everything.

It should also either be telling each app it relaunches exactly what it had open, or those apps should be remembering this for this situation.

Basically what I think I’m seeing is that LibreOffice is not a fully adapted MacOS app, even when built for Mac, and does things that are unexpected and/or annoying in that environment.

This doesn’t matter to me very much. I’m only using LibreOffice on MacOS as a tool for translating spreadsheets from Numbers to Calc, as part of my move from MacOS to Kubntu Linux.

But it might be reasonably seen as a bug by anyone who did plan to routinely use Calc on MacOS.

OTOH, I’m not sure how it would be seen by the majority of LibreOffice developers and users, who probably don’t do much on MacOS.

LibreOffice is an integrated suite. Only one executable file needed. (MS-Office had times where you could buy separate packages, so they had to generate separate executables. This makes not much sense, when all parts are free…)

And as usual in this cases other users might want this information, other might not want the delay to check state of all files (they can be moved/deleted while LO is not running) etc.
.
But ok, maybe all MacUsers are of same opinion. Then filevan request for enhancement at Bugzilla
https://bugs.documentfoundation.org/enter_bug.cgi?product=LibreOffice&bug_status=UNCONFIRMED&bug_severity=enhancement

It seems odd, then, that on linux there appear to be 6 separate apps available to launch. The following screenshot comes from Kubuntu:

I assume your screenshot shows launchers. That’s the same on Windows. You may have any number of launchers (entry in menu) and they can use command-line-options like “–calc” to tell the binary the module to use.
.
You can even create a launcher DinoNerd, if you like. It will not need another binary…

It’s scalc.exe

Yes, it probably does show launchers. But that UI element is a hybrid; it can also find and launch executables that don’t create windows for themselves, and would normally be launched from a shell prompt.

Like MacOS, Kubuntu doesn’t have an executable for calc in any linux-traditional location (i.e. in the default $PATH)

I followed the symlink trail from /bin/libreoffice to /lib/libreoffice/program which is a directory, containing many subdirectories and quite a few executables. /bin/libreoffice is a link to /lib/libreoffice/program/soffice. /lib/libreoffice/program/scalc turned out to be a free-standing executable for calc.

I’m not familiar enough with kde to know how to find information on whatever launchers may have been defined, or how to create new ones. So I mostly don’t knowingly use that facility. Launching executables from the command line has been consistent on *nix systems since the 1970s, with window-using apps appearing in the 1980s.

I’m even less familiar with how to do anything on Windows. Some releases ago, they proudly announced a UI refresh which would make using Windows much the same as using a cell phone. I was already using MacOS at work, and knew its UI was better than that of any cell phone, so I decided to pay the premium to for Macs for home use.

I’m only now abandoning MacOS for linux, where at least I have a long history, though with gaps. I first used a Unix system in 1974.

At any rate, the *nix standard way to handle an executable not located in $PATH is either to include its directory in $PATH, or create a shell alias to launch it directly. (How to do that has changed since the 1970s, FWIW. But not in the current century.)

Fortunately, though, there are a couple of ways to create something like launchers (maybe real ones) in kde which I have noticed. In particular, one you succeed in launching an app, you can right click its icon in the task manager, and pin it there. This is the same UI as in MacOS, except that the similar-looking UI element on macOS has a different name, and like as not they don’t call the result a launcher.

Anyway, this is a giant tangent. I’ll probably eventually make the time to learn how my current desktop environment/window manager (kde) expects me to do routine tasks, and more of its particular jargon. At least if it doesn’t change before I get around to doing that work.

But right now I’m dealing with a lot of learning curve - and trying to be a good netizen by reporting weirdness when I see it.

Meanwhile, I think the original issue has been beaten to death. But on the good side, I’ve learned a bit more about what metaphors, UI designs, and similar feel natural to libreoffice users, at least the sort who post answers here, and what competing programs they pay attention to. Also, and rather more importantly, I’ve learned what things feel natural to me, while being incomprehensible to many frequenters of this forum.

p.s. what’s the secret to getting paragraph divisions in postings on this forum. Usually leaving a blank line between paragraphs works, but not here. Paragraphs show up in the preview on the RHS of the bottom of the screen, but not when my text is posted.

Forum software is dicourse and uses markdown.


Above division is a <BR> and below I will use <p> to show you can use some html-tags.

Lazy people like me . sometimes use other separators... (And it doesn't work in this case.)

Have a look to hidden files! I’m using „muCommander“ for those.