1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
|
<?xml version="1.0" encoding="UTF-8"?>
<!--
* This file is part of the LibreOffice project.
*
* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
*
* This file incorporates work covered by the following license notice:
*
* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed
* with this work for additional information regarding copyright
* ownership. The ASF licenses this file to you under the Apache
* License, Version 2.0 (the "License"); you may not use this file
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
-->
<helpdocument version="1.0">
<meta>
<topic id="textscalc0105070500xml" indexer="include" status="PUBLISH">
<title id="tit" xml-lang="en-US">Sheet</title>
<filename>/text/scalc/01/05070500.xhp</filename>
</topic>
</meta>
<body>
<section id="sheet">
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/SheetPrintPage" id="bm_id3147335" localize="false"/>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/@@nowidget@@" id="bm_id3147335" localize="false"/>
<bookmark xml-lang="en-US" branch="index" id="bm_id3150542"><bookmark_value>pages; order when printing</bookmark_value>
<bookmark_value>printing; page order</bookmark_value>
</bookmark><comment>mw deletes three "printing;..." entries and copies 4 index entries to Calc guide print_details.xhp</comment><paragraph role="heading" id="hd_id3156329" xml-lang="en-US" level="1"><link href="text/scalc/01/05070500.xhp" name="Sheet">Sheet</link></paragraph>
<paragraph role="paragraph" id="par_id3151384" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sheetprintpage/SheetPrintPage">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.</ahelp></paragraph>
</section>
<section id="howtoget">
<embed href="text/scalc/00/00000405.xhp#fostel"/>
</section>
<paragraph role="heading" id="hd_id3150542" xml-lang="en-US" level="2">Print</paragraph>
<paragraph role="paragraph" id="par_id3125863" xml-lang="en-US">Defines which elements of the spreadsheet are to be printed.</paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/checkBTN_HEADER" id="bm_id3150767" localize="false"/><paragraph role="heading" id="hd_id3151041" xml-lang="en-US" level="3">Column and row headers</paragraph>
<paragraph role="paragraph" id="par_id3147228" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sheetprintpage/checkBTN_HEADER">Specifies whether you want the column and row headers to be printed.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/checkBTN_GRID" id="bm_id3154320" localize="false"/><paragraph role="heading" id="hd_id3150439" xml-lang="en-US" level="3">Grid</paragraph>
<paragraph role="paragraph" id="par_id3147436" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sheetprintpage/checkBTN_GRID">Prints out the borders of the individual cells as a grid.</ahelp> For the view on screen, make your choice under <switchinline select="sys"><caseinline select="MAC"><emph>%PRODUCTNAME - Preferences</emph></caseinline><defaultinline><emph>Tools - Options</emph></defaultinline></switchinline><emph> - %PRODUCTNAME Calc</emph> - <link href="text/shared/optionen/01060100.xhp" name="View"><emph>View</emph></link> - <emph>Grid lines</emph>.</paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/checkBTN_NOTES" id="bm_id3159153" localize="false"/><paragraph role="heading" id="hd_id3145750" xml-lang="en-US" level="3">Comments</paragraph>
<paragraph role="paragraph" id="par_id3150010" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sheetprintpage/checkBTN_NOTES">Prints the comments defined in your spreadsheet.</ahelp> They will be printed on a separate page, along with the corresponding cell reference.</paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/checkBTN_OBJECTS" id="bm_id3144764" localize="false"/><paragraph role="heading" id="hd_id3154944" xml-lang="en-US" level="3">Objects/images</paragraph>
<paragraph role="paragraph" id="par_id3149581" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sheetprintpage/checkBTN_OBJECTS">Includes all inserted objects (if printable) and graphics with the printed document.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/checkBTN_CHARTS" id="bm_id3156283" localize="false"/><paragraph role="heading" id="hd_id3149377" xml-lang="en-US" level="3">Charts</paragraph>
<paragraph role="paragraph" id="par_id3148455" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sheetprintpage/checkBTN_CHARTS">Prints the charts that have been inserted into your spreadsheet.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/checkBTN_DRAWINGS" id="bm_id3153839" localize="false"/><paragraph role="heading" id="hd_id3153418" xml-lang="en-US" level="3">Drawing Objects</paragraph>
<paragraph role="paragraph" id="par_id3149122" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sheetprintpage/checkBTN_DRAWINGS">Includes all drawing objects in the printed document.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/checkBTN_FORMULAS" id="bm_id3155765" localize="false"/><paragraph role="heading" id="hd_id3150330" xml-lang="en-US" level="3">Formulas</paragraph>
<paragraph role="paragraph" id="par_id3153715" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sheetprintpage/checkBTN_FORMULAS">Prints the formulas contained in the cells, instead of the results.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/checkBTN_NULLVALS" id="bm_id3146314" localize="false"/><paragraph role="heading" id="hd_id3156385" xml-lang="en-US" level="3">Zero Values</paragraph>
<paragraph role="paragraph" id="par_id3149258" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sheetprintpage/checkBTN_NULLVALS">Specifies that cells with a zero value are printed.</ahelp></paragraph>
<paragraph role="heading" id="hd_id3154022" xml-lang="en-US" level="2">Page Order</paragraph>
<paragraph role="paragraph" id="par_id3166423" xml-lang="en-US">Defines the order in which data in a sheet is numbered and printed when it does not fit on one printed page.</paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/radioBTN_TOPDOWN" id="bm_id3145258" localize="false"/><paragraph role="heading" id="hd_id3152580" xml-lang="en-US" level="3">Top to bottom, then right</paragraph>
<paragraph role="paragraph" id="par_id3150205" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sheetprintpage/radioBTN_TOPDOWN">Prints vertically from the left column to the bottom of the sheet.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/radioBTN_LEFTRIGHT" id="bm_id3150342" localize="false"/><paragraph role="heading" id="hd_id3150786" xml-lang="en-US" level="3">Left to right, then down</paragraph>
<paragraph role="paragraph" id="par_id3154657" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sheetprintpage/radioBTN_LEFTRIGHT">Prints horizontally from the top row of the sheet to the right column.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/checkBTN_PAGENO" id="bm_id3150367" localize="false"/><paragraph role="heading" id="hd_id3150887" xml-lang="en-US" level="3">First page number</paragraph>
<paragraph role="paragraph" id="par_id3155378" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sheetprintpage/checkBTN_PAGENO">Select this option if you want this style to restart page numbering.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/spinED_PAGENO" id="bm_id3156288" localize="false"/><paragraph role="paragraph" id="par_id3145389" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sheetprintpage/spinED_PAGENO">Enter the number you want to restart at.</ahelp></paragraph>
<paragraph role="heading" id="hd_id3146978" xml-lang="en-US" level="2">Scale</paragraph>
<paragraph role="paragraph" id="par_id3149408" xml-lang="en-US">Defines a page scale for the printed spreadsheet.</paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/comboLB_SCALEMODE" id="bm_id8574175" localize="false"/><paragraph role="heading" id="par_idN1096D" xml-lang="en-US" level="3">Scaling mode</paragraph>
<paragraph role="paragraph" id="par_idN10971" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sheetprintpage/comboLB_SCALEMODE">Select a scaling mode from the list box. Appropriate controls will be shown below the list box.</ahelp></paragraph>
<paragraph role="heading" id="hd_id3155089" xml-lang="en-US" level="4">Reduce/enlarge printout</paragraph>
<paragraph role="paragraph" id="par_id3159171" xml-lang="en-US">Specifies a scaling factor to scale all printed pages.</paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/spinED_SCALEALL" id="bm_id3153067" localize="false"/><paragraph role="heading" id="par_idN1099A" xml-lang="en-US" level="5">Scaling factor</paragraph>
<paragraph role="paragraph" id="par_id3152899" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sheetprintpage/spinED_SCALEALL">Enter a scaling factor. Factors less than 100 reduce the pages, higher factors enlarge the pages.</ahelp></paragraph>
<paragraph role="heading" id="par_idN109B2" xml-lang="en-US" level="4">Fit print range(s) to width/height</paragraph>
<paragraph role="paragraph" id="par_idN109B5" xml-lang="en-US">Specifies the maximum number of pages horizontally (width) and vertically (height) on which every sheet with the current Page Style is to be printed. </paragraph>
<list type="unordered">
<listitem>
<paragraph role="paragraph" id="par_idN109BB" xml-lang="en-US">The print ranges are always scaled proportionally, so the resulting number of pages may be less than specified.</paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_idN109BF" xml-lang="en-US">You may disable one of the boxes, then the unspecified dimension will use as many pages as necessary.</paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_idN109C3" xml-lang="en-US">If you disable both boxes, this will result in a scaling factor of 100%.</paragraph>
</listitem>
</list>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/spinED_SCALEPAGEWIDTH" id="bm_id7740714" localize="false"/><paragraph role="heading" id="par_idN109CE" xml-lang="en-US" level="5">Width in pages</paragraph>
<paragraph role="paragraph" id="par_idN109D1" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sheetprintpage/spinED_SCALEPAGEWIDTH">Enter the maximum number of pages to be printed horizontally across.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/spinED_SCALEPAGEHEIGHT" id="bm_id516983" localize="false"/><paragraph role="heading" id="par_idN109E8" xml-lang="en-US" level="5">Height in pages</paragraph>
<paragraph role="paragraph" id="par_idN109EB" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sheetprintpage/spinED_SCALEPAGEHEIGHT">Enter the maximum number of pages to be printed vertically stacked.</ahelp></paragraph>
<paragraph role="heading" id="hd_id3148868" xml-lang="en-US" level="4">Fit print range(s) on number of pages</paragraph>
<paragraph role="paragraph" id="par_id3145074" xml-lang="en-US">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.<comment>UFI: fixes #112585#</comment></paragraph>
<bookmark xml-lang="en-US" branch="hid/modules/scalc/ui/sheetprintpage/spinED_SCALEPAGENUM" id="bm_id3157983" localize="false"/><paragraph role="heading" id="par_idN10A26" xml-lang="en-US" level="5">Number of pages</paragraph>
<paragraph role="paragraph" id="par_id3144507" xml-lang="en-US"><ahelp hid="modules/scalc/ui/sheetprintpage/spinED_SCALEPAGENUM">Enter the maximum number of pages to be printed.</ahelp></paragraph>
</body>
</helpdocument>
|
