Welcome!
Important information
-- Spectre and Meltdown vulnerabilities
-- Change in MX sources

News
-- MX Linux on social media: here
-- Mepis support still here

Current releases
-- MX-17.1 Final release info here
-- antiX-17 release info here

New users
-- Please read this first, and don't forget to add system and hardware information to posts!
-- Here are the Forum Rules

Many columns Spreadsheet - how to convert to landscape mode

This forum is intended for the discussion around the use of MEPIS in an office setting as distinct from home or indivicual usage. Examples include mail merge, database construction, hardware sharing, advertising, etc..
Message
Author
User avatar
eemaestro
Forum Guide
Forum Guide
Posts: 1010
Joined: Wed Aug 02, 2006 12:12 pm

Many columns Spreadsheet - how to convert to landscape mode

#1 Post by eemaestro » Sun Sep 20, 2015 6:26 pm

I have a big spreadsheet measuring up to column AG, with one line for each day of the month.
I keep it in Gnumeric. However, I cannot print it in landscape mode on my laserjet printer onto 8.5 x 11 inch paper.
Gnumeric and Calc both have the settings, to where I can set Landscape mode as a printer option.
But if I go ahead and print, it comes out portrait mode.

I tried exporting as PDF, and opening in okular, so I could maybe just rotate the graphical layout by 90 degrees
on the paper in okular and then print it. No such luck, as the table got divided into 3 or 4 pages when I exported it.

Any other suggestions?

User avatar
Jerry3904
Forum Veteran
Forum Veteran
Posts: 22633
Joined: Wed Jul 19, 2006 6:13 am

Re: Many columns Spreadsheet - how to convert to landscape m

#2 Post by Jerry3904 » Sun Sep 20, 2015 6:51 pm

In LO click Format > Page and select Landscape: is that what you mean?
Production: 4.15.0-1-amd64, MX-17.1, AMD FX-4130 Quad-Core, GeForce GT 630/PCIe/SSE2, 8 GB, Kingston SSD 120 GB and WesternDigital 1TB
Testing: AAO 722: 4.15.0-1-386. MX-17.1, AMD C-60 APU, 4 GB

User avatar
eemaestro
Forum Guide
Forum Guide
Posts: 1010
Joined: Wed Aug 02, 2006 12:12 pm

Re: Many columns Spreadsheet - how to convert to landscape m

#3 Post by eemaestro » Sun Sep 20, 2015 10:45 pm

Yes, I did that in LibreOffice Calc. And in "Page Preview" it showed up landscape mode. But when I printed it to paper, it came out in portrait mode.

I just did it again after you wrote your response. This time, it came out printed on the paper in landscape mode. Strange! I have no idea what might have changed. I haven't even saved it to a file yet.
Last edited by eemaestro on Sun Sep 20, 2015 11:11 pm, edited 2 times in total.

User avatar
eemaestro
Forum Guide
Forum Guide
Posts: 1010
Joined: Wed Aug 02, 2006 12:12 pm

Re: Many columns Spreadsheet - how to convert to landscape m

#4 Post by eemaestro » Sun Sep 20, 2015 10:55 pm

UPDATE: That only worked once. Subsequent tries printed onto paper in portrait mode, even though Printer Settings in LO Calc still shows landscape. I will simply assume LO Calc only prints once in landscape mode, then reverts to portrait mode on all subsequent prints.

User avatar
eemaestro
Forum Guide
Forum Guide
Posts: 1010
Joined: Wed Aug 02, 2006 12:12 pm

Re: Many columns Spreadsheet - how to convert to landscape m

#5 Post by eemaestro » Sun Sep 20, 2015 11:03 pm

No, that's not it.
It still prints in portrait mode, even though LO Calc Print Settings is set to landscape (and says so). This was when I copied the cells to another window. Then I copied the cells to another instance of LO Calc. Same results.

So LO Calc failed the first time, worked the second time, and failed on all subsequent tries. I do not understand.
Last edited by eemaestro on Sun Sep 20, 2015 11:12 pm, edited 1 time in total.

User avatar
uncle mark
Forum Veteran
Forum Veteran
Posts: 4982
Joined: Sat Nov 11, 2006 10:42 pm

Re: Many columns Spreadsheet - how to convert to landscape m

#6 Post by uncle mark » Sun Sep 20, 2015 11:07 pm

You need to set the Page format to landscape in the file itself.

In my old LO v3.4.3, that done with

Format> Page> Page tab. Tick Landscape.

Make sure you save the change to the file.
Desktop: Custom build Asus/AMD/nVidia -- MEPIS 11
Laptop: Acer Aspire 5250 -- MX-15
Assorted junk: assorted Linuxes

User avatar
Richard
Posts: 2137
Joined: Fri Dec 12, 2008 10:31 am

Re: Many columns Spreadsheet - how to convert to landscape m

#7 Post by Richard » Sun Sep 20, 2015 11:12 pm

eemaestro wrote:No, that's not it.
It still prints in portrait mode, even though LO Calc Print Settings is set to landscape (and says so). This was when I copied the cells to another window. Then I copied the cells to another instance of LO Calc. Same results.
That may be.
There is more than 1 config for landscape: LibO has some and my printer driver has some.
It is sometimes a matter of trial and error.
My new (to me) HP P1102w is great but can't remember that it is the default.

I am continually amazed that printers are so problematic.
Based on 30+ years of printing since my Commodore 64 and a Citizen dot matrix.

"Perserverance furthers", according to the I Ching.
MX171: Lenovo T430: Intel Ivy Bridge i5-3320M, 8GB RAM, 4.18.0-2-amd64, 119GB SSD
MX171: AA1/EeePC: DualCore N270, 1GB RAM, 4.9.126-antix.1-686-smp-pae, 150GB HDD
Thunar/Doublecmd, LibO613, Dropbox, Firefox, CherryTree, Vbox. LinuxCounter #208633

User avatar
eemaestro
Forum Guide
Forum Guide
Posts: 1010
Joined: Wed Aug 02, 2006 12:12 pm

Re: Many columns Spreadsheet - how to convert to landscape m

#8 Post by eemaestro » Sun Sep 20, 2015 11:15 pm

That worked, uncle mark. Let's see if it works again. I have five spreadsheets to print.

User avatar
eemaestro
Forum Guide
Forum Guide
Posts: 1010
Joined: Wed Aug 02, 2006 12:12 pm

Re: Many columns Spreadsheet - how to convert to landscape m

#9 Post by eemaestro » Mon Sep 21, 2015 12:12 am

Okay, I printed all 5 documents from LO Calc, thanks to you uncle mark.
I had to change the font size to 10 for all text so the months with 31 days wouldn't go onto more than one page.
I wrote down what you said. So now I have instructions on how to print in landscape mode. I would never have guessed there's more than one landscape/portrait mode, one for the page and for the document. Page attributes versus document attributes. All of a sudden I have plenty of scrap paper.
Thank you for your help.

User avatar
uncle mark
Forum Veteran
Forum Veteran
Posts: 4982
Joined: Sat Nov 11, 2006 10:42 pm

Re: Many columns Spreadsheet - how to convert to landscape m

#10 Post by uncle mark » Mon Sep 21, 2015 8:02 am

eemaestro wrote:Okay, I printed all 5 documents from LO Calc, thanks to you uncle mark.
Jerry told you the same thing, I just did it with slightly more detail.

But hey, if it's good for my reputation....
Desktop: Custom build Asus/AMD/nVidia -- MEPIS 11
Laptop: Acer Aspire 5250 -- MX-15
Assorted junk: assorted Linuxes

Post Reply

Return to “Office”