Snaking Colums

Discuss the spreadsheet application

Snaking Colums

Postby Fade » Sun Dec 23, 2007 6:06 am

Is there any way to snake columns so they run on the space available on the first page, before going to the next page?

i.e.
on the same page...

A | B | C| A | B | C| A | B | C|
x | x | x| x | x | x| x | x | x|
x | x | x| x | x | x| x | x | x|
x | x | x| x | x | x| x | x | x|
x | x | x| x | x | x| x | x | x|

page 2
A | B | C|
x | x | x|
x | x | x|
x | x | x|
end
Fade
 
Posts: 1
Joined: Sun Dec 23, 2007 5:57 am

Re: Snaking Colums

Postby acknak » Sun Dec 23, 2007 6:23 am

I don't think there's any setting to have Calc do it, but you can paste it into Writer (paste special, as formatted text) and set the page format to use as many columns as will fit. Writer will wrap the table as you asked for.
AOO4/LO5 • Linux • Fedora 23
User avatar
acknak
Moderator
 
Posts: 22756
Joined: Mon Oct 08, 2007 1:25 am
Location: USA:NJ:E3

Re: Snaking Colums

Postby Dave » Sun Dec 23, 2007 7:01 pm

Fade wrote:Is there any way to snake columns so they run on the space available on the first page, before going to the next page?


I don't think so, but if you can foresee the need, you can, having once first established your columns, whether data or formula, select certain cells and drag that selection elsewhere maintaining integrity. So, you can manually line up to suit, then have that selection fit the page for printing [the Page Brage Preview helps there.]

David.
Dave
 
Posts: 1011
Joined: Sun Dec 23, 2007 6:53 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 13 guests