Startup with Calc on OSX

users
#1

I would like to immediately open Calc when I start LibreOffice on OSX
since I am using this component in most cases.
Is there a way of configuring LibreOffice that way on OSX?

#2

Hi :slight_smile:

Can you create a launcher/widget/script or something that uses the
command-line? If so then i think the command-line way of opening calc is

soffice -calc

to create a new spreadsheet. Otherwise just opening an existing spreadsheet
should open Calc.
Regards from
Tom:)

#3

There is a way, Erich. I learnt it about a year ago. It's buried deep in the menu system or maybe in the preferences. I know because I applied it immediately, and now, when Open Office or Libre Office start up, they show me the splash screen and then go straight to a specific type of document, in my case a particular Writer document.

I needed to change the document recently, and asked about the method, since I had not written it down nor saved the thread, but nobody seemed to know. The only thing they could come up with was to start LibO from the command line, but I don't do that. It's the same with a lot of good ideas - you see them once and then they disappear, and no amount of searching the archives will bring them out. I suspect they are off-thread asides which makes them hard to search for.

Like the tip about using Cmd+Alt+Shift+V (I think it works with Ctrl+Alt+Shift+V in Windows and Linux) to paste directly in the format of the document you're pasting to, without going via the Paste Special dialogue. You can search the archives till you're blue in the face, but you won't find that tip which I got from here (or maybe OOo), also about a year ago.

//James

#4

"James Wilde" <james.wilde@sunde-wilde.com> wrote in message news:571EB0C9-E52F-43F8-8CD1-28F930795EB1@sunde-wilde.com...

I would like to immediately open Calc when I start LibreOffice on OSX
since I am using this component in most cases.
Is there a way of configuring LibreOffice that way on OSX?

There is a way, Erich. I learnt it about a year ago. It's buried deep in the menu system or maybe in the preferences. I know because I applied it immediately, and now, when Open Office or Libre Office start up, they show me the splash screen and then go straight to a specific type of document, in my case a particular Writer document.

I needed to change the document recently, and asked about the method, since I had not written it down nor saved the thread, but nobody seemed to know. The only thing they could come up with was to start LibO from the command line, but I don't do that. It's the same with a lot of good ideas - you see them once and then they disappear, and no amount of searching the archives will bring them out. I suspect they are off-thread asides which makes them hard to search for.

Like the tip about using Cmd+Alt+Shift+V (I think it works with Ctrl+Alt+Shift+V in Windows and Linux) to paste directly in the format of the document you're pasting to, without going via the Paste Special dialogue. You can search the archives till you're blue in the face, but you won't find that tip which I got from here (or maybe OOo), also about a year ago.

//James

I assume OSX has a facility that allows you to create a shortcut (Windows terminology) or link (Unix/Linux terminology). Simply create one, perhaps on your desktop, to the Calc program. On Windows this is "scalc.exe" and is in the "program" folder/directory within the OOo installation sub-tree. Then just run (double click?) the link/shortcut. On Windows there are several programs within OOo: soffice.exe, scalc.exe, swriter. exe etc. There's one for each type of document and then the generic "soffice.exe" which shows the menu of document types when you run it.

HTH

#5

Answering my own mail :wink:
I found out how to do it on Snow Leopard.
Open AppleScript Editor (found in /Applications/Utilities)
Create a new AppleScript with the content
do shell script "/Applications/LibreOffice.app/Contents/MacOS/soffice -calc"
Save As Application (nor as Script)
I saved it in /Applications
In Finder, use "Show Package Contents" from the context menu and navigate to
Contents/Resources
In Finder, also use "Show Package Contents" on LibreOffice.app and navigate to
Contents/Resources
of that app.
Copy (not move!) the file
calc.icns

From the LibreOffice Resources to the LibreOfficeCalc Resources.

In LibreOffice Resources, rename applet.icns to appletxxx.icns
( whatever other name you want)
Rename calc.icns to applet.icns

You are finished, you have an app icon which will start LibreOffice Calc immediately.

#6

Tom

<"Like the tip about using Cmd+Alt+Shift+V (I think it works with
Ctrl+Alt+Shift+V in Windows and Linux) to paste <directly in the format of
the document you're pasting to, without going via the Paste Special
dialogue. You can search the <archives till you're blue in the face, but
you won't find that tip which I got from here (or maybe OOo), also about a
year <ago."

Look in the Edit menu> Paste Special, the short cut is shown there.

#7

Make a macro to open a calc file and asign to the start of LO

If you dont need a specific template edit a new vb macro put this in it

Dim Dummy()
Dim Url As String
Dim Doc As Object

Url = "private:factory/scalc"
Doc = StarDesktop.loadComponentFromURL(Url, "_blank", 0, Dummy())

if not replace the url for the path to the template

For me this open a calcl file after a warning to restore ¿¿??

#8

No it's not, Tinkerer. On my copy of LibO, the Paste Special shortcut is Cmd+Shift+V and brings up a dialogue where you can choose, in the case before me, between formatted and unformatted text.

Cmd+Shift+Alt+V bypasses that dialogue and pastes in the format of the receiving document, whichever that is.

//James

#9

Macs don't have separate start programs. The only executable file is LibreOffice.app.

Larry

#10

Macs don't have separate start programs. The only executable file is LibreOffice.app.

Actually they are there, just kind of hidden :wink:

LibreOffice.app is an application bundle, which is basically a directory. The difference to other directories is that you cannot open an .app directory by (double) clicking it in Finder. However, you may open LibreOffice.app via the "Show package contents" function in its context menu, the one you get when you ctrl+mouse click on LibreOffice.app. At command line level (that is, in Terminal) a, say, cd (change directory) works like for any other directory.

To help solve the original issue, here's my (quick, but hopefully not too dirty) attempt to come up with AppleScript code to start LibreOffice directly in Calc mode:

1. Start Applications/Utilities/AppleScript-Editor.

2. Copy and paste the following three lines of code (ignoring ... do ... end ...) into the AppleScript-Editor window:

ignoring application responses
  do shell script "/Applications/LibreOffice.app/Contents/MacOS/soffice -calc 2>&1 >/dev/null &"
end ignoring

3. In AppleScript-Editor click Compile, to verify that the code will run. This shouldn't trigger any error messages.

4. Save the script. In the save dialog window make sure to select Application as file format, which will change the file name extension to .app. I suggest to save the script as LibreCalc.app in /Applications.

Double clicking LibreCalc.app should now directly open a Calc sheet.

Hope that helps.

Rolf

#11

Hi Erich,

I would like to immediately open Calc when I start LibreOffice on OSX
since I am using this component in most cases.
Is there a way of configuring LibreOffice that way on OSX?

From memory, a guy called Eric Bachard actually did some work on

providing a solution to this, and made available a download and
instructions for sorting it all out. Unfortunately, I can only find them
in French at the moment, and don't know whether they work on the current
versions of OOo/LibO. It seemed to me that the introduction of the
Startup screen sort of screwed things up a bit. However, that screen can
be deactivated by installing an extension that is capable of
deactivating it.

Alex

#12

There was a launcher developed for OpenOffice.org both for the GUI (with icons) and for the command line. It is no longer maintained but someone could use it as a base for a launcher for LibreOffice.
http://stuporglue.org/openoffice-org-aqua-rocks/

Larry

#13

Erich Neuwirth <erich.neuwirth <at> univie.ac.at> writes:

open LibreOffice.app --args -calc

#14

Another way is to install an extension which gives you the same choice. The details are:

It is an extension. "DisableStartModule.oxt 0.0.1".
(available at http://qa.openoffice.org/issues/show_bug.cgi?id=90815 )

This information courtesy of Larry Gusaas of this list, with grateful thanks.

Note that it is an OpenOffice extension, but it works perfectly well on LibreOffice.

//James

#15

I first did this with a script/shortcut thingy. One for writer and one
for calc. It sort of worked but not that well.
Then I found I could just put Untitled.odt and untitled.ods in the
applications bar that pops up at the bottom of the screen and that gets
me straight into calc or writer with a blank document. I suppose I could
make them templates too.
steve

#16

I have a directory of templates in a folder.

I can click on these templates using the mouse and LO just opens a new file accordingly.

I also list the template folder in the preferences section of LO so if I create a new file from within LO I have the same templates appear.

You can have an icon to the template folder on the desktop and/or icons pointing to the templates on your desktop. Opening Calc is simply a matter of clicking on the appropriate icon.