Opening worksheets from the terminal in linux?

users
#1

Couple of questions about opening LibreOffice 3.5 worksheets from the terminal in Ubuntu 12.04

1. Can I open a specific spreadsheet from the terminal? I have tried a lot of combinations and I either get a new/untitled worksheet or an error message.

2. If I solve [1] will error messages appear in the terminal? I am working with some python macros and would like better access to python error messages. I got the impression from some messages I read on the net that the error messages would appear in the terminal if the work sheet was started from the terminal. So far when I get an new sheet to open from the terminal, it immediately reverts back to the prompt so no error message would appear.

Thanks, Jim

#2

Hi Jim,

1. Can I open a specific spreadsheet from the terminal? I have tried a lot
of combinations and I either get a new/untitled worksheet or an error message.

just a simple
[path_to]/soffice file1.ods
works fine here (4.3.1/SUSE)

What error message do you get?

2. If I solve [1] will error messages appear in the terminal?

(I suppose so - but don't know really, so someone else has to help you)

Nino

#3

Hi :slight_smile:
I think some of the parameters of the problem weren't clear.

A default spreadsheet file normally has 3 sheets. Is it possible to select
which of the 3 gets opened? I think that is what the o.p. meant.

Err, i usually delete any sheets that i'm not using so that when i open an
ancient file i don't have to faff around trying to see if i hid anything on
one of the other 2 sheets.

This might be a work-around for the o.p. because then each file would only
have 1 sheet and hopefully that would be the one opened by default - but
it'd probably be annoying. I sometimes find i have to add extra sheets,
such as 1 per month or per quarter and breaking those out into separate
files would be annoying.

Also i tend to find the i don't need to include the path to soffice but do
need the path to the file (unless i'm already in the correct folder). So
for me it's more like

soffice path-name/file-name

Regards from
Tom :slight_smile:

#4

I go one step further and change my default to only have one sheet in any
new file. I can always add more as needed, but most of the time I don't
need to add anything.

Regards,

#5

Hi Jim,

1. Can I open a specific spreadsheet from the terminal? I have tried a lot
of combinations and I either get a new/untitled worksheet or an error message.

just a simple
[path_to]/soffice file1.ods
works fine here (4.3.1/SUSE)

What error message do you get?

It was me not including the path that caused the problem.

localc [path to]/file1.ods works.

2. If I solve [1] will error messages appear in the terminal?

(I suppose so - but don't know really, so someone else has to help you)

If I use the correct path then when the file opens I do not get the prompt back. I haven't had a chance to see if error messages appear in the terminal.

Nino

Thanks, Jim

#6

Hi :slight_smile:
I think some of the parameters of the problem weren't clear.

A default spreadsheet file normally has 3 sheets. Is it possible to select
which of the 3 gets opened? I think that is what the o.p. meant.

Err, i usually delete any sheets that i'm not using so that when i open an
ancient file i don't have to faff around trying to see if i hid anything on
one of the other 2 sheets.

This might be a work-around for the o.p. because then each file would only
have 1 sheet and hopefully that would be the one opened by default - but
it'd probably be annoying. I sometimes find i have to add extra sheets,
such as 1 per month or per quarter and breaking those out into separate
files would be annoying.

Also i tend to find the i don't need to include the path to soffice but do
need the path to the file (unless i'm already in the correct folder). So
for me it's more like

soffice path-name/file-name

Regards from
Tom :slight_smile:

Yeah, my bad. I should have been taking about somefile.ods not sheets and workbooks. See my reply to Nino.

Thanks, Jim