Page and drucker setup in Calc – LibreOffice 6-4
- 1 Foreword
- 2 Link to the video
- 3 Working with existing table
- 4 Format the page
- 5 Define print range
- 6 Set several pressure ranges
- 7 Setting up the printer
- 8 Further Informations
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: "Page and printer setup in Calc - LibreOffice 6.4". in work
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
We open the file Liabilities.ods in Calc. The table is displayed. The print output is normally preset for DIN A4 portrait.
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
In the dialog box "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.
Define print range
Now we fix the pressure range.
To that mark we want to print the range of the table.
The dashed lines are now on the outer lines of the table, marked as before.
We check again with▸ .
It will now be the entire table displayed on DIN A4 landscape.
Set several pressure ranges
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 ▸ ▸ .
It can now four pages, according to the four ranges are displayed or printed.
In the menu▸ ▸ 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▸ } 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.
In the dialog box "Setting up the printer", we choose "properties ".
It may look very different depending on the printer.
In the printer menu, we also choose A4 Landscape and.
Documentation / Manuals
For questions on this topic go to Ask.LibreOffice