[Solved] Repeat Rows & Columns on same page

[mryflyguy]

How does one format a page to repeat rows & columns on the same page? In the attached example, I need to repeat columns A,B,C on. the same page. Line 34 B,C to continue online 3 F,g so my data series continues for charting data. Is this defined in the Page setup?

[RusselB]

I think what you're wanting is under Format -> Print Ranges -> Edit
In this case the 3rd set of options marked Columns to Repeat

[MrProgrammer]

… so my data series continues for charting data.

If you want to chart the data, keep it all in columns A, B, C. You will find it impractical to create a chart from data scattered across several sets of columns.

How does one format a page to repeat rows & columns on the same page? In the attached example, I need to repeat columns A,B,C on. the same page. Line 34 B,C to continue online 3 F,G …. Is this defined in the Page setup?

Even though one must keep the data in A,B,C, you can print data from a long vertical range of cells on a smaller number of physical pages than File → Page Preview shows. But you cannot do that by formatting in OpenOffice since formatting can never relocate data to different cells. Instead you control how your data appears on the printed page by using your printer driver. Most drivers support multiple logical pages on a physical page. Your printer driver is part of your operating system, not part of OpenOffice. The printer driver is often supplied by the company from which you purchased the printer, therefore different printers will have different drivers, with different methods of achieving multiple pages per sheet. This is how I do it with my printer driver. Its Layout panel lets me put two logical pages on one physical one.

Then the driver's OpenOffice panel shows me how it will look when printed. Two logical OpenOffice portrait pages print on one landscape physical page.

Also see [Tutorial] Mac FAQ Q35/A35.

If this solved your problem please go to your first post use the Edit button and add [Solved] to the start of the title. You can select the green checkmark icon at the same time.

[Tutorial] Ten concepts that every Calc user should know

[mryflyguy]

Ok, This works using one set of columns & rows modifying the the printer Layout to print 2 pages/page. Some problems, like the page header is repeated, chart size in portrait but workable. Thanks!