[Solved] Automatic loading of files when opening Calc

Discuss the spreadsheet application
Post Reply
dalepubs
Posts: 1
Joined: Wed Jul 15, 2020 12:12 pm

[Solved] Automatic loading of files when opening Calc

Post by dalepubs »

Is it possible to open a set of files (in their own directory) automatically when opening Calc?
Last edited by dalepubs on Wed Jul 15, 2020 10:12 pm, edited 1 time in total.
OpenOffice 4.1.7 on Windows 10
User avatar
Zizi64
Volunteer
Posts: 11362
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Automatic loading of files when opening Calc

Post by Zizi64 »

It is possible.

- by a custom macro assigned to the apropriate event.
- and maybe there are more solutions and workarouds.
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.
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Automatic loading of files when opening Calc

Post by Villeroy »

First of all, it is important to understand that you never open Calc. You open the office suite with this or that type of document. It is one program for all types of documents. When you click some Calc icon, you open the office suite with a new spreadsheet document.
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Zizi64
Volunteer
Posts: 11362
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Automatic loading of files when opening Calc

Post by Zizi64 »

What about a batch file in the Windows?
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.
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Automatic loading of files when opening Calc

Post by Villeroy »

Zizi64 wrote:What about a batch file in the Windows?
Too easy :roll:
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
User avatar
Zizi64
Volunteer
Posts: 11362
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Automatic loading of files when opening Calc

Post by Zizi64 »

Villeroy wrote:Too easy :roll:
Oooops, I'm sorry! :D :bravo: :super:
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.
User avatar
RoryOF
Moderator
Posts: 34618
Joined: Sat Jan 31, 2009 9:30 pm
Location: Ireland

Re: Automatic loading of files when opening Calc

Post by RoryOF »

Or a desktop shortcut to soffice with a series of file names.
Apache OpenOffice 4.1.15 on Xubuntu 22.04.4 LTS
Post Reply