Date: prev next · Thread: first prev next last
2015 Archives by date, by thread · List index

Hi :)
If the folder contains some spreadsheets and some other things and you only
want to open the spreadsheets then the fastest way i can think of is to use
the file-browser to arrange/sort the files "by type" rather than by name or
date.  That might make it easier to select them all.

I think other people have had better suggestions already though.  I was
wondering if it might be possible to "script it" but kinda assumed it
probably wouldn't be at all easy = so i like Gary's suggestion! :)
Regards from
Tom :)

On 27 May 2015 at 14:15, Gary Dale <> wrote:

On 27/05/15 02:05 AM, Brian Barker wrote:

At 10:22 27/05/2015 +0900, Thomas Noname wrote:

Is there a trick to tell LibreOffice, in particular Calc, to open files

Not that I know of. (Perhaps someone knows better.)

 Lotus 123 allows to specify a folder and then opens the files therein
automatically whenever the software is started. For those administrative
tasks, a set of 2-3 files, this is VERY convenient. I would like to convert
those 123-files into Calc format and have Calc open them *automatically*
whenever I start Calc.

It's worth mentioning that you cannot "start Calc": that's not how
LibreOffice works. You can do either of two different things: either start
LibreOffice or start LibreOffice with a new, empty spreadsheet. And that
tells you something about your problem: if you could do what you wanted,
there would be no way to prevent your spreadsheet documents being opened if
you wanted to start LibreOffice to edit a text file (or, as you would say,
"start Writer") or presentation or whatever instead.

I have no problem starting Calc nor opening several spreadsheets
"automatically". I select the sheets I open in Dolphin (or any other file
manager) and right-click on the selection then select "Open with". Calc is
the default program to open .ods documents so they all open.

Since the OP wants a job to run at startup, simply use the command-line to
do the job:
   libreoffice --calc -o <file1> -o <file2> ...

Put that into a script or a link to a script in your "Autostart" folder
(.kde/Autostart on my KDE system).

To open all the files in a folder, just use a loop like this:
  for f in *; do; libreoffice --calc -o $f; done

We don't need no stinking features when we've got a real command line.  :)

There are many workarounds, which depend on your operating system - which
you have kept a secret. (You appear to be using Windows XP.)

o Your operating system will probably offer a way to start programs at
start-up - when you log in, that is. You could put your document files (or
possibly shortcuts to them?) in the appropriate folder.

o You could put your documents or shortcuts to them somewhere convenient,
such as on the desktop or in the start menu, and then click on these when
you need the documents open.

o (Probably best) Put the documents in a convenient folder. (You've done
that already.) Create a shortcut to this on the desktop or in the start
menu. When you need to open the documents, (1) click or double-click the
shortcut to open the folder, (2) select all the document files together
(using Edit | Select All or Ctrl+A?), and (3) press Enter to open all the
documents (whether or not LibreOffice is already running).

I trust this helps.

Brian Barker

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be

To unsubscribe e-mail to:
Posting guidelines + more:
List archive:
All messages sent to this list will be publicly archived and cannot be deleted


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.