Warning: This Help page is relevant to LibreOffice up to version 6.0.
For updated Help pages, visit https://help.libreoffice.org.

Sheet

From LibreOffice Help
Jump to: navigation, search

Specifies the elements to be included in the printout of all sheets with the current Page Style. Additionally, you can set the print order, the first page number, and the page scale.

Choose Format - Page - Sheet tab

Print

Defines which elements of the spreadsheet are to be printed.

Column and row headers

Specifies whether you want the column and row headers to be printed.

Grid

Prints out the borders of the individual cells as a grid. For the view on screen, make your choice under Tools - Options' - LibreOffice Calc' - View - Grid lines.

Comments

Prints the comments defined in your spreadsheet. They will be printed on a separate page, along with the corresponding cell reference.

Objects/images

Includes all inserted objects (if printable) and graphics with the printed document.

Charts

Prints the charts that have been inserted into your spreadsheet.

Drawing Objects

Includes all drawing objects in the printed document.

Formulas

Prints the formulas contained in the cells, instead of the results.

Zero Values

Specifies that cells with a zero value are printed.

Page Order

Defines the order in which data in a sheet is numbered and printed when it does not fit on one printed page.

Top to bottom, then right

Prints vertically from the left column to the bottom of the sheet.

Left to right, then down

Prints horizontally from the top row of the sheet to the right column.

First page number

Select this option if you want the first page to start with a number other than 1.

Enter the number of the first page.

Scale

Defines a page scale for the printed spreadsheet.

Scaling mode

Select a scaling mode from the list box. Appropriate controls will be shown at the side of the list box.

Reduce/enlarge printout

Specifies a scaling factor to scale all printed pages.

Scaling factor

Fit print range(s) to width/height

Specifies the maximum number of pages horizontally (width) and vertically (height) on which every sheet with the current Page Style is to be printed.

  • The print ranges are always scaled proportionally, so the resulting number of pages may be less than specified.
  • You may clear one of the boxes, then the unspecified dimension will use as many pages as necessary.
  • If you clear both boxes, this will result in a scaling factor of 100%.
Width in pages

Enter the maximum number of pages to be printed horizontally across.

Height in pages

Enter the maximum number of pages to be printed vertically stacked.

Fit print range(s) on number of pages

Specifies the maximum number of pages on which every sheet with the current Page Style is to be printed. The scale will be reduced as necessary to fit the defined number of pages.

Number of pages

Enter the maximum number of pages to be printed.