Ubuntu :: Open Office Calc Print Portrait And Landscape?
Aug 12, 2009
I have a Calc spreadsheet that has 3 sheets. The first page is set for Portrait and the remaining pages are Landscape. Currently I am printing each page as a separate print job.I would like to print the entire Calc pages as one job where the printer prints the first page as portrait and the remaining pages as landscape without user intervention.
I do not see any command in the print dialog or in open office dialogs that tell the printer to change orientation. It seems that OpenOffice fails to tell the printer the page orientation. Is there any way to accomplish this. If a macro is required how do you write it and how is it executed?
I have been trying to repeat the first two rows in a Calc document but I keep getting an error.
Here are the instructions that I used.
Printing Rows or Columns on Every Page If you have a sheet that is so large that it will be printed multiple pages, you can set up rows or columns to repeat on each printed page. As an example, If you want to print the top two rows of the sheet as well as the first column (A)on all pages, do the following:
1.Choose Format - Print Ranges - Edit. The Edit Print Ranges dialog appears.
2.Click the icon at the far right of the Rows to repeat area. The dialog shrinks so that you can see more of the sheet.
3.Select the first two rows and, for this example, click cell A1 and drag to A2. In the shrunk dialog you will see $1:$2. Rows 1 and 2 are now rows to repeat.
4.Click the icon at the far right of the Rows to repeat area. The dialog is restored again.
5.If you also want column A as a column to repeat, click the icon at the far right of the Columns to repeat area.
6.Click column A (not in the column header).
7.Click the icon again at the far right of the Columns to repeat area.
Rows to repeat are rows from the sheet. You can define headers and footers to be printed on each print page independently of this in Format - Page.
Okay so I have a file that I always save and close properly and get in my Ubuntu One folder for backup that will not open. Its called "Income.ods" and is quite important and I cannot seem to recover it. When I double click it, it shows the Libre Office Calc splash screen shows up then goes away and the nothing, no error messages, no nothing. I tried to open it on my Windows Vista machine and it said it was corrupted and could not open in Office Word. I tried a few recovery tools but to no avail.
I'm trying to change my screen orientation from landscape to portrait mode. Here's my system information. (I don't have an auto-generated xorg.conf file.)
Here's the error message I get when I try to use randr:
$ xrandr --orientation right X Error of failed request: BadMatch (invalid parameter attributes) Major opcode of failed request: 149 (RANDR) Minor opcode of failed request: 2 (RRSetScreenConfig) Serial number of failed request: 14 Current serial number in output stream: 14
I use openoffice writer 2.3.9 and when I paste a picture on a document, I can't find any option to get the portrait format. With a right mouse click I get a all lot of options (especially under "picture") but nothing about the format.
I just recently upgraded my Fedora 6 to Fedora 10 on a brand new laptop. Unfortunately, everytime I try to print the apps freeze up. For example, I was trying to print a document out from Open Office and I chose FILE->PRINT. The print dialog box pops up but it remains grey and doesnt do anything.
My setup: openSUSE 11.4. Acer Extensa 5635ZG Epson Stylus Photo PX710W, connected with WiFi
I have just discovered that I can't print text from libreoffice writer/calc if the layout is set to landscape. The letters seems to have been stretched and printed over each other. If I print the same document in kword/kspread everything is printed as it should be. I have generated a pdf of the document and printed from okular/acroread, even then it's not printed correctly. Although it looks ok in okular/acroread. What else that can be seen is that when it's wrongly printed the printout is printed in the opposite direction compared to when it's printed correctly. I.e. the tail comes first on the paper so to say. Where should I begin to search for faults?
I am trying to print a schematic from KPDF (Suse 11.2) onto an 11x17 sheet of paper. Regardless of the printer settings I use or which driver I choose it won't rotate the image and fill the page. I have the same problem with kiCAD. If I use Okular it prints part of the drawing in one corner at the 8.5x11 scale.
I want to print Landscape and I would normally use Code: lp -ddestination -olandscape However this isn't working, it could be another problem (I am passing to a windows print spooler) but I would like to know if I have got the command right.
We are running RHEL 5.1 on the 2.6.18.53 kernel. We are attempting to pass print jobs to a Lexmark printer with the lp -o landscape command. The print jobs continue to print "portrait". Is anyone aware of this issue and is there a work-around to get these print jobs to print in landscape format?
I must say I am newby using Fedora, but cannot find solution how to define print range in calc. I am using oo for almost ten years in windoze, but this is first time I have this problem. I'm using Fedora 14 L, on my lap compaq 6715b. During install, everything went just fine, only problem in last month, since I install F14 L I have find, was using oo calc. I need that rather quickly because I need to apply my tax income until end february,
I just found out about Libre Office. I am currently using Open Office on my Netbook (ubuntu 10.10), and NeoOffice on my Macbook (OS/X 10.6.7).
QUESTION: I have some backups using these formats: .sdw, and .odt. Can Libre Office read documents saved in these (StarOffice / Open Office) formats?
FWIW: I would have preferred to use OO on both machines, but unfortunately OO never fixed a problem with printing envelopes in the Macintosh version. Hence my use of NeoOffice.
I have both installed, but since LO is going to be the way Ubuntu goes for office applications, can I easily have my system setup for native LO? Native being if I double clock on a .doc file it will start up LO's Write program instead of OO.Will just removing OO achieve this or is there an easier way? I looked for file associations and didn't find it.
Sometime ago I realized my Open Office had changed, I don't remember having done anything in particular but today it isn't the regular open office but what I believe is a KDE version or idk. The theme changed and instead of regular menus I get "window" menus, in the sense that they get effects as regular windows. It's hard to explain it.
[URL]
I tried uninstalling it and installing open office and also in the soft center open office is more than once, but I tried the different versions and I still get the same problem.
I have a Canon iR3570/iR4570 PXL, and installed the driver CQue 1.0 TCP/IP Queue from Canon webpage.
The problem: - if i try to print an OpenOffice or LibreOffice Calc with an image and text, the image is not printed (the space is blank). - if i try to print an OpenOffice or LibreOffice Calc with just an image, it's printed great. - if i try to print an OpenOffice or LibreOffice Impress, the images are not printed but the text is printed great.
I don't know if I'm doing something wrong but I've been running Ubuntu or a variant for about a year now and suddenly every now and then one or two of my documents (open office or pdfs) have no information and they won't open.
I'm having sporadic issues with the openoffice.org program. Sometimes, power point presentations will crash the program and then I can't open any open office programs without rebooting the computer. The problem seems to be just with powerpoint files and I'm not sure what the issue could be.
I live in Japan and am trying to print to a network printer (Richo Ipsio C411 PS). Couldn't find the ppd in the foomatic database. At my previous school, I had no problems printing to the printers on the network once I found the ppd. A few months ago, I transfered to a new site. Unfortunately, when I send a print job on the network here, the printer just gives a Japanese message that says "command error." I've tried other printers on the network (all different models of the Ipsio).
I went to the Japanese Ricoh website and it recommended a generic printer ppd. I downloaded that, but it didn't work. Then I got the ppd off of the windows driver CD and tried that. Again, no success. I have no idea what I'm doing (obvious, but should be noted) or how to get this started. I also tried 2 versions of Ubuntu -- I'm running 8.04 and 10.04.
When I open an open office document from an NFS share it always opens as readonly. This was a problem I had on Arch linux and the fix was to change the locking options in the soffice script but I've tried that fix here and it doesn't work. I've seen a lot of discussions but they all go back to changing the locking options in soffice, has anyone got any alternative fixes or one that definitely works with locking?
I have Linux Mint installed on my wife's laptop along with Wine/Office 2003. (she wants MS Office!). Here's the issue: She pulls up a word document in MS Word that has graphics in it. When she prints to her HP 2600N laser printer, the graphics do not print out. She also has blank boxes on the 2nd page that print out solid black. If we open the same document in OpenOffice, it prints fine....but she still wants to use MS Office!
I installed Open Office 4 on Debian 8 but when I run the program I get this error message.
root@localhost:/home/paul# openoffice4 No protocol specified No protocol specified /opt/openoffice4/program/soffice.bin X11 error: Can't open display: Set DISPLAY environment variable, use -display option or check permissions of your X-Server (See "man X" resp. "man xhost" for details)
Open Office works fine when I run the command "startx" in the Konsole but so far I haven't been able to configure it.
I cant open xls files in a shared folder using open office 3.1. Its all started when i install a new open office version. when im using open office 3.0.8 i can open all the files but now i cant even open it. Its always display untitled documents.
