Print with presets

Printer settings

Printer

Select a printer to print the document.

Printer properties

This option is only available in Windows. Clicking opens the printer properties dialog box. The type and contents of the dialog box options depend on the printer model selected in the box above. The settings specified in the Printer properties dialog box are automatically transferred to the appropriate boxes in the Print setup and print dialog box.

Print in grayscale

Print the color text and images contained in the document in grayscale.

Page setup

Copies

The number of copies of the document to be printed.

Collated /
Uncollated

The option is available when the number of copies is more than one. You can set the order of page grouping during the printing:

–Collated: Pages are grouped by the copies (1,2,3 1,2,3 1,2,3).

–Uncollated: Pages are grouped by the number of the pages (1,1,1 2,2,2 3,3,3).

Print area

Document print area:

–Defined area: Printing of the defined area of the document.

–Entire sheet: Printing of the sheet that is currently displayed on the screen.

–Selection: Printing of the fragment selected in the document.

Range

The box is not available when printing the selection. It contains the following items:

–All pages: Printing of all pages of the current sheet or defined print area.

–Odd pages only, Even pages only: These options are for manual double-sided printing of a document on a printer that does not support this type of printing in automatic mode. To print, you need to select odd-numbered pages first, then turn the stack of sheets backwards and select to print even-numbered pages.

Box for entering page numbers/ranges for printing

This box is used if it is necessary to print individual pages or page ranges of the selected sheet/area/fragment. The pages to be printed can be specified as follows:

–Individual page numbers. For example, 5, 10, 12.

–Page ranges separated by the hyphen. For example, 1-8, 10-11.

–Pages from the beginning of the sheet, area, fragment to the specified one in the -<No.> format. For example, if you type -3, pages 1-3 will be printed.

–Pages from the specified one to the end of the sheet, area, or fragment in the <No.>- format. For example, if you type 3- in the box and the sheet, area, or fragment has 6 pages, pages 3-6 will be printed.

Duplex printing

Duplex printing:

–None: Print on only one side of the page.

–Long-edge binding: Print on both sides of a sheet of paper where paper flips along the long edge.

–Short-edge binding: Print on both sides of a sheet of paper where paper flips along the short edge.

Page orientation

Portrait (vertical) or Landscape (horizontal) page orientation.

Paper size

The standard size of the paper used for printing.

Ignore blank pages

Pages that do not contain data cells, objects (charts, images, shapes), or cells with borders or fill are considered blank. The option is selected by default.

When you select/clear the Ignore blank pages checkbox, blank pages are hidden or displayed in the preview area and the total number of pages decreases or increases.

If you want to print individual pages or page range of the selected sheet, area, fragment, first make sure that the Ignore blank pages checkbox is selected, and then specify the necessary pages or page range to print based on the page numbering in the preview area.

Scale and page breaks

Scale

The Scale box is the setting of the print scale. The scale setting method depends on the value selected in the Print area box:

If you select Print area > Entire sheet or Defined area option, the scale can be set by entering a value or using the zoom in/out arrows.

If you select Print area > Selection option, then the following options are available for adjusting the scale:

–Actual size

–Fit to page: Place the entire selected fragment on one page.

–Fit to width: Fit all the columns of the selected fragment into one page.

–Fit to height: Fit all the rows of the selected fragment into one page.

When you change the scale, the automatic page breaks adjust to the selected scale.

When zooming in, the custom breaks may move to another page.

When zooming out, the custom breaks will not allow content from other pages to move to this page.

Print with custom page breaks

This option is available if the sheet contains custom page breaks. When the option is selected, the sheet is divided into pages according to the inserted breaks. If there are no custom page breaks on the sheet, then this option is disabled.

Print titles

Rows to repeat / Columns to repeat

Rows or columns to repeat are rows or columns that will be displayed on every page when printing a table or exporting a document to PDF. They can be used as titles, for example, when you need to pin the table header on every sheet.

Rows to repeat are pinned at the top of the table to be printed or exported, and columns to repeat are pinned on the left.

You can select rows or columns to repeat either by directly entering the range address in the box or by clicking  Select values and then selecting the range with the mouse in the document itself.

In this case, you may:

–Select only entire rows or columns. For example, when you manually enter a range, you can't enter “$A$1:$A$5”; you have to enter the address of the entire row “$1:$1” or the range of rows “$1:$5”.

–When using multiple columns or rows, only adjacent rows or columns can be selected. For example, when you enter a range manually, you cannot enter the ranges “$1:$1” and “$3:$3” without including the range “$2:$2”. You also cannot specify a range as “=$B:$C;$D:$E”. You need to specify the range as a continuous one as “=$B:$E”.

–Select only rows or columns on the current document sheet and located in the sheet's workspace.

Only visible data is printed: hidden and filtered cells are not printed.

The setting is not available if no printers are installed in the OS.

Rows and columns to repeat are not displayed in .ods files created in Excel.

Margins

Top margin

The distance between the top edge of the page and the content of the document.

Bottom margin

The distance between the bottom edge of the page and the content of the document.

Left margin

The distance between the left edge of the page and the content of the document.

Right margin

The distance between the right edge of the page and the content of the document.