[Issue] Printing .xls files (Calc) from context menu fails

[fechtelm]

Dear all,

I have installed open office 3.0 on WinXP Pro SP 3. I tried to print excel sheets (Extension .xls) by right-click and selecting "Print" from the context menu, which fails. Other file types (e.g., .doc) print properly from the context menu.

Is this a bug in the current version?

Best regards
Michael

[thomasjk]

I can confirm this behavior. .XLS goes nowhere while .doc prints. Don't know if this issue existed in V2.4.1 or not. I did a quick search of issues and didn't see one. You can open a new issue here http://qa.openoffice.org/ooQAReloaded/D ... Start.html.

[Bhikkhu Pesala]

It looks like it is a bug. You're having the exact same issue as in this thread.

I checked the File Type info for xls files and found these actions:

print = "C:\Program Files\OpenOffice.org 3\program\\scalc.exe" -p "%1"
printb = "C:\Program Files\OpenOffice.org 3\program\\scalc.exe" -pt "%2" "%1"

C:\Program Files\OpenOffice.org 3\program
I wonder why it doesn't work. Maybe it is the extra backslashes?

This is the info for OpenOffice Spreadsheets:

print = "C:\Program Files\OpenOffice.org 3\program\soffice.exe" -p "%1"
printb = "C:\Program Files\OpenOffice.org 3\program\soffice.exe" -pt "%2" "%1"

[fechtelm]

Thanks Bhikkhu for your reply!

I checked the File Type info for xls files and found these actions:

print = "C:\Program Files\OpenOffice.org 3\program\\scalc.exe" -p "%1"
printb = "C:\Program Files\OpenOffice.org 3\program\\scalc.exe" -pt "%2" "%1"

C:\Program Files\OpenOffice.org 3\program
I wonder why it doesn't work. Maybe it is the extra backslashes?

The extra backslash does not matter, since it is also existent for the .doc type and swriter.exe:
here:

print = "C:\Program Files\OpenOffice.org 3\program\\swriter.exe" -p "%1"

But there it works..

Best regards
Michael

[efsq]

I encounter the same issue.
For people and webspiders:
There is a bugzilla issue for this: http://qa.openoffice.org/issues/show_bug.cgi?id=95280
and this: http://www.oooforum.org/forum/viewtopic.phtml?t=76563 is related.

[efsq]

It turns out that when opening a .xls document for printing only, no individual sheet is "selected", like it would be when opening a spreadsheet for editing. Calc then correctly observes the setting in

Tools > Options > Calc > Printing > Print only selected sheets

This option is checked by default, so Calc prints nothing.

See also: http://www.oooforum.org/forum/viewtopic ... highlight=

--
Jaap

[sa999sa]

i am having same problem with Linux soffice -p command
it is printing .doc but not the spreadsheet,
can anybody help?

Please don't double-post the same question in different areas of the forum. I have removed your other identical post. See: The Survival guide (TheGurkha, Moderator)