Videos/Page and printer setup in Calc

From The Document Foundation Wiki
Jump to navigation Jump to search

Template:TopMenu/en Template:Menu/en

Other languages:


The video "Page and printer setup in Calc - LibreOffice 6.4" links to this page here, which contains further informations.

Link to the video

Print preview single table - DIN A4 landscape

Link to the video (in German-DE):

"Seite und Drucker einrichten in Calc".

Working with existing table

Open Calc. For this video we use the existing Liabilities.ods file.

The table can be downloaded - below -.

Format the page

Next page icon
Close Preview

We open the file Liabilities.ods in Calc.

The table is displayed.

The print output is normally preset for DIN A4 portrait.

We check this with the selection File ▸ Print preview.

The print preview is displayed and we can use the icon "Next page" click to the other pages.

We can notice that the table is on three pages would be printed.

We click on "Close side view".

In the normal view we now see that between the column B/C and F/G a vertical dashed line runs.

This corresponds to the division into three sides.

Since the table is wider than high, it is useful to print the table in A4 landscape format.

Set page to A4 landscape

To set the page to A4 landscape, choose Format ▸ Page….

In the dialog "Page style default" we click on the tab "Page".

For "Paper Size" we leave "A4" and select "Landscape" for "Orientation".

Setup scale and scaling mode

We click on the tab "Sheet".

For "Scale>Scale Mode:" we select "Fit Print Range(s) to Page Number".

The page number is left at "1", which forces the table to one page.

We click OK.

Define print range

Now we fix the pressure range.

To that mark we want to print the range of the table.

Now we choose Format ▸ Print Ranges ▸ Define.

The dashed lines are now on the outer lines of the table, marked as before.

We check again with File ▸ Print Preview.

It will now be the entire table displayed on DIN A4 landscape.

We click on "Close side view".

Set several pressure ranges

Table with four printranges
Display of the individual pages as they are printed

To explain the procedure for several print areas, the area that we have already defined as the print area is copied multiple times in the worksheet.

For this we mark the range to be copied and paste it in three places again.

The columns ″J″ bis ″Q″ must be adjusted in width.

In the respective heading "Liabilities" we add the capital letters A to D to distinguish them.

The color-coded column "I" and row "31" serve only for optical separation and are not absolutely necessary.

The four-pane table should now look like this, see right.

In the Print preview still only the range_1 "Liabilities A" is displayed:

We now add the other pressure ranges B – D.

We mark the respective one (Tables -) Range and choose in the menu Format ▸ Print Ranges ▸ Add.

Once we have set the pressure ranges, we can check this again with File ▸ Print preview.

It can now four pages, according to the four ranges are displayed or printed.

In the menu Format ▸ Page ▸ Table we leave the settings.

By the given Page Order, the pages are printed out in the order A, B, C, D.

Check page break

We can check the page division by choosing View ▸ Page Break} from the menu.

The individual pages are displayed with a dark blue border and in the background there is the page designation in light grey letters.

Setting up the printer

Since we have now set the page format to landscape, we now setup the printer.

We choose File ▸ Print Settings….

In the dialog "Setting up the printer", we choose "properties ".

The menu that opens is printer-dependent.

It may look very different depending on the printer.

In the printer menu, we also choose A4 Landscape and OK.

- up -

Further Informations

Work files


Liabilities - several print ranges.ods

Documentation / Manuals

Here you will find the Documentation / Manuals:

Documentation / Manuals

Any questions?

For questions on this topic go to:


Get Involved

Join us today and help us to make it even better!

Get Involved

LibreOffice is Free Software and is made available free of charge.

Your donation, which is purely optional, supports our worldwide community.

If you like the software, please consider a Donation.