Videos/Page and printer setup in Calc/en

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

Link to the video


Link to the video (in German-DE):

"Seite und Drucker einrichten in Calc".

Working with existing table
Open Calc.

Analogous to the video, you can use the existing Liabilities.ods file.

The Table document can be downloaded - below -.

Format the page




Open the file Liabilities.ods in Calc.

[[Media:202006_LOENHB_The table is displayed.png|The table is displayed.]]

The print output is normally preset for DIN A4 portrait.

Check this with the selection [[Media:202006_LOENHB_Menu File Print preview.png|]].

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

You can notice that the table is on [[Media:202006_LOENHB_Print preview page 1 - 3.png|three pages]] would be printed.

Click on "Close side view".

In the normal view you now see that between [[Media:202006_LOENHB_The column B-C and F-G.png|the column  and  ]] 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 [[Media:202006_LOENHB_Menu Format Page.png|]].

In the dialog [[Media:202006_LOENHB_Dialog box Page Style Default Landscape.png|"Page style default"]] click on the tab "Page".

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

Setup scale and scaling mode
Click on the tab [[Media:202006_LOENHB_Dialog box Page Style Default - Tab Sheet.png|"Sheet"]].

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

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

Click.

Define print range
Now you fix the pressure range.

To that [[Media:202006_LOENHB_Table Liabilities marked.png|mark ]] you want to print the range of the table.

Now you choose [[Media:202006_LOENHB_Menu Format Print Ranges Define.png|]].

The dashed lines are now on the [[Media:202006_LOENHB_Table Liabilities outer lines.png| outer lines of the table]], marked as before.

Check again with.

It will now be the [[Media:202006_LOENHB_Print preview one page.png|entire table displayed on DIN A4 landscape]].

Click on.

Set several pressure ranges




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

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

The columns  bis   must be adjusted in width.

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

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

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

In the [[Media:202006_LOENHB_Print preview only Area1.png|Print preview]] still only the range_1 "Liabilities A" is displayed:

Now add the other pressure ranges.

Mark the respective one [[Media:202006_LOENHB_Print previewB set.png|(Tables -) Range]] and choose in the menu.

Once you have set the pressure ranges, you can check this again with [[Media:202006_LOENHB_Menu File Print preview.png|]].

It can now [[Media:202006_LOENHB_Print preview Area 1 - 4.png|four pages]], according to the four ranges are displayed or printed.

In the menu leave the settings.

By the given [[Media:202006_LOENHB_Dialog box Page Style Default Sheet Page order.png|Page Order]], the pages are printed out in the order A, B, C, D.

Check page break
You can check the page division by choosing } 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.

Different page headers
Different page headers require different page styles.

Page Styles

Setting up the printer
Since you have now set the page format to landscape, now setup the printer.

Choose [[Media:202006_LOENHB_Menu File Print settings.png|]].

In the [[Media:202006_LOENHB_Dialog box Drucker Setup.png|"Setting up the printer"]] dialog, you choose "properties ".

[[Media:201802_LO_HB_Dialogbox_Druckerdialog.png|The menu that opens is printer-dependent]].

It may look very different depending on the printer.

In the printer menu, you also choose A4 Landscape and.

- up -

Work files
[[Media:Liabilities.ods|Liabilities.ods]]

[[Media:Liabilities - several print ranges.ods|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:

Ask.LibreOffice

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

Get Involved

Donate
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.