Startup with Calc on OSX

classic Classic list List threaded Threaded
16 messages Options
Erich Neuwirth Erich Neuwirth
Reply | Threaded
Open this post in threaded view
|

Startup with Calc on OSX

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?

--
Unsubscribe instructions: E-mail to [hidden email]
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Tom Tom
Reply | Threaded
Open this post in threaded view
|

Re: Startup with Calc on OSX

Hi :)

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:)




________________________________
From: Erich Neuwirth <[hidden email]>
To: [hidden email]
Sent: Mon, 7 February, 2011 7:55:06
Subject: [libreoffice-users] Startup with Calc on OSX

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?

--
Unsubscribe instructions: E-mail to [hidden email]
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***


     
--
Unsubscribe instructions: E-mail to [hidden email]
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***
James Wilde James Wilde
Reply | Threaded
Open this post in threaded view
|

Re: Startup with Calc on OSX

In reply to this post by Erich Neuwirth

On Feb 7, 2011, at 08:55 , Erich Neuwirth wrote:

> 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
--
Unsubscribe instructions: E-mail to [hidden email]
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Harold Fuchs Harold Fuchs
Reply | Threaded
Open this post in threaded view
|

Re: Startup with Calc on OSX


"James Wilde" <[hidden email]> wrote in message
news:[hidden email]...

>
> On Feb 7, 2011, at 08:55 , Erich Neuwirth wrote:
>
>> 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

--
Harold Fuchs
London, England



--
Unsubscribe instructions: E-mail to [hidden email]
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Erich Neuwirth Erich Neuwirth
Reply | Threaded
Open this post in threaded view
|

Re: Startup with Calc on OSX

In reply to this post by Erich Neuwirth
Answering my own mail ;-)
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.


On Feb 7, 2011, at 8:55 AM, Erich Neuwirth wrote:

> 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?
>
> --
> Unsubscribe instructions: E-mail to [hidden email]
> List archive: http://listarchives.libreoffice.org/www/users/
> *** All posts to this list are publicly archived for eternity ***
>
>


--
Unsubscribe instructions: E-mail to [hidden email]
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Tinkerer Tinkerer
Reply | Threaded
Open this post in threaded view
|

Re: Startup with Calc on OSX

In reply to this post by Harold Fuchs
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.
besr2010-prg besr2010-prg
Reply | Threaded
Open this post in threaded view
|

Re: Startup with Calc on OSX

In reply to this post by Erich Neuwirth
El 07/02/2011 04:55 a.m., Erich Neuwirth escribió:
> 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?
>
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 ¿¿??

--
Unsubscribe instructions: E-mail to [hidden email]
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

James Wilde James Wilde
Reply | Threaded
Open this post in threaded view
|

Re: Startup with Calc on OSX

In reply to this post by Tinkerer

On Feb 7, 2011, at 16:07 , Tinkerer wrote:

>
> 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.

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
--
Unsubscribe instructions: E-mail to [hidden email]
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Larry Gusaas Larry Gusaas
Reply | Threaded
Open this post in threaded view
|

Re: Startup with Calc on OSX

In reply to this post by Harold Fuchs
On 2011/02/07 4:47 AM  Harold Fuchs wrote:
> 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.
Macs don't have separate start programs. The only executable file is LibreOffice.app.

Larry
--
_________________________________
Larry I. Gusaas
Moose Jaw, Saskatchewan Canada
Website: http://larry-gusaas.com
"An artist is never ahead of his time but most people are far behind theirs." - Edgard Varese



--
Unsubscribe instructions: E-mail to [hidden email]
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***
Rolf Lochbühler Rolf Lochbühler
Reply | Threaded
Open this post in threaded view
|

Re: Startup with Calc on OSX

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

Actually they are there, just kind of hidden ;-)

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
--
Unsubscribe instructions: E-mail to [hidden email]
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Alex Thurgood Alex Thurgood
Reply | Threaded
Open this post in threaded view
|

Re: Startup with Calc on OSX

In reply to this post by Erich Neuwirth
Le 07/02/11 08:55, Erich Neuwirth a écrit :

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


--
Unsubscribe instructions: E-mail to [hidden email]
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***

Larry Gusaas Larry Gusaas
Reply | Threaded
Open this post in threaded view
|

Re: Startup with Calc on OSX

In reply to this post by Rolf Lochbühler
On 2011/02/08 3:07 AM  Rolf Lochbühler wrote:

>> Macs don't have separate start programs. The only executable file is LibreOffice.app.
> Actually they are there, just kind of hidden ;-)
>
> 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
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
--
_________________________________
Larry I. Gusaas
Moose Jaw, Saskatchewan Canada
Website: http://larry-gusaas.com
"An artist is never ahead of his time but most people are far behind theirs." - Edgard Varese




--
Unsubscribe instructions: E-mail to [hidden email]
List archive: http://listarchives.libreoffice.org/www/users/
*** All posts to this list are publicly archived for eternity ***
Badbugs Badbugs
Reply | Threaded
Open this post in threaded view
|

Re: Startup with Calc on OSX

In reply to this post by Erich Neuwirth
Erich Neuwirth <erich.neuwirth <at> univie.ac.at> writes:

open LibreOffice.app --args -calc

>
> 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?
>





--
Unsubscribe instructions: E-mail to [hidden email]
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted

James Wilde James Wilde
Reply | Threaded
Open this post in threaded view
|

Re: Startup with Calc on OSX

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

On May 11, 2011, at 19:20 , Badbugs wrote:

> Erich Neuwirth <erich.neuwirth <at> univie.ac.at> writes:
>
> open LibreOffice.app --args -calc
>
>>
>> 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?
>>
>
>
>
>
>
> --
> Unsubscribe instructions: E-mail to [hidden email]
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/www/users/
> All messages sent to this list will be publicly archived and cannot be deleted
>


--
Unsubscribe instructions: E-mail to [hidden email]
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted

steveedmonds steveedmonds
Reply | Threaded
Open this post in threaded view
|

Re: Startup with Calc on OSX

In reply to this post by Badbugs
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

On 2011-05-12 05:20, Badbugs wrote:

> Erich Neuwirth <erich.neuwirth <at> univie.ac.at> writes:
>
> open LibreOffice.app --args -calc
>
>  
>> 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?
>>
>>    
>
>
>
>
>  

--
Unsubscribe instructions: E-mail to [hidden email]
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted

Simon Cropper (The foss Workflow Guides) Simon Cropper (The foss Workflow Guides)
Reply | Threaded
Open this post in threaded view
|

Re: Startup with Calc on OSX

On 12/05/11 13:13, Steve Edmonds wrote:
> 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

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.

--
Cheers Simon

    Simon Cropper
    Website Administrator
    http://www.fossworkflowguides.com
    The fossWorkflow Guides

--
Unsubscribe instructions: E-mail to [hidden email]
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/www/users/
All messages sent to this list will be publicly archived and cannot be deleted