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
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
|
<?xml version="1.0" encoding="UTF-8"?>
<helpdocument version="1.0">
<!--
***********************************************************************
*
* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
*
* Copyright 2008 by Sun Microsystems, Inc.
*
* OpenOffice.org - a multi-platform office productivity suite
*
* $RCSfile: table_insert.xhp,v $
* $Revision: 1.9.4.1 $
*
* This file is part of OpenOffice.org.
*
* OpenOffice.org is free software: you can redistribute it and/or modify
* it under the terms of the GNU Lesser General Public License version 3
* only, as published by the Free Software Foundation.
*
* OpenOffice.org is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU Lesser General Public License version 3 for more details
* (a copy is included in the LICENSE file that accompanied this code).
*
* You should have received a copy of the GNU Lesser General Public License
* version 3 along with OpenOffice.org. If not, see
* <http://www.openoffice.org/license.html>
* for a copy of the LGPLv3 License.
*
************************************************************************
-->
<meta>
<topic id="textsimpressguidetable_insertxml" indexer="include">
<title id="tit" xml-lang="en-US">Including Spreadsheets in Slides</title>
<filename>/text/simpress/guide/table_insert.xhp</filename>
</topic>
</meta>
<body>
<bookmark xml-lang="en-US" branch="index" id="bm_id3154022"><bookmark_value>spreadsheets;in presentations</bookmark_value>
<bookmark_value>presentations;inserting spreadsheets</bookmark_value>
<bookmark_value>including spreadsheets</bookmark_value>
</bookmark>
<paragraph role="heading" id="hd_id3154022" xml-lang="en-US" level="1" l10n="U" oldref="1"><variable id="table_insert"><link href="text/simpress/guide/table_insert.xhp" name="Including Spreadsheets in Slides">Including Spreadsheets in Slides</link>
</variable></paragraph>
<paragraph role="paragraph" id="par_id4231086" xml-lang="en-US" l10n="NEW">You can apply different methods to insert spreadsheet cells into your Impress slides or Draw pages:</paragraph>
<list type="ordered">
<listitem>
<paragraph role="paragraph" id="par_id9209875" xml-lang="en-US" l10n="NEW">Insert a native table - you enter the data into the cells and apply fancy formatting using the Table Design section on the Tasks pane.</paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id3044526" xml-lang="en-US" l10n="NEW">Insert a new table as an OLE object or insert an existing file as an OLE object - you can specify the link to a file to be a live link to the latest data saved in a spreadsheet file.</paragraph>
</listitem>
</list><comment>Insert table dialog - Number of columns</comment>
<bookmark xml-lang="en-US" branch="hid/svx_NumericField_RID_SVX_NEWTABLE_DLG_NF_COLUMNS" id="bm_id0916200804233391" localize="false"/>
<paragraph role="paragraph" id="par_id137333" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Enter the number of columns for the new table.</ahelp></paragraph><comment>Insert table dialog - Number of rows</comment>
<bookmark xml-lang="en-US" branch="hid/svx_NumericField_RID_SVX_NEWTABLE_DLG_NF_ROWS" id="bm_id0916200804240464" localize="false"/>
<paragraph role="paragraph" id="par_id8626667" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Enter the number of rows for the new table.</ahelp></paragraph><comment>Contextmenu of a table in Impress and Draw</comment><comment>Cell</comment>
<bookmark xml-lang="en-US" branch="hid/.uno:CellMenu" id="bm_id0916200803192795" localize="false"/>
<paragraph role="paragraph" id="par_id0916200803551581" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Define the vertical alignment of selected or all cell contents. Split or merge cells.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/SID_TABLE_MERGE_CELLS" id="bm_id0916200803370158" localize="false"/>
<paragraph role="paragraph" id="par_id0916200803551553" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">All selected cells are merged into one cell.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/SID_TABLE_SPLIT_CELLS" id="bm_id0916200803375165" localize="false"/>
<paragraph role="paragraph" id="par_id0916200803551535" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">The selected cell is split into several cells. You see the Split Cells dialog box.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/SID_TABLE_VERT_NONE" id="bm_id0916200803224438" localize="false"/>
<paragraph role="paragraph" id="par_id0916200803551651" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">The cell contents are align at the top of the cells.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/SID_TABLE_VERT_CENTER" id="bm_id091620080323379" localize="false"/>
<paragraph role="paragraph" id="par_id0916200803551697" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">The cell contents are aligned vertically centered in the cells.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/SID_TABLE_VERT_BOTTOM" id="bm_id0916200803242358" localize="false"/>
<paragraph role="paragraph" id="par_id0916200803551632" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">The cell contents are aligned at the bottom of the cells.</ahelp></paragraph><comment>Row</comment>
<bookmark xml-lang="en-US" branch="hid/.uno:RowMenu" id="bm_id0916200803255185" localize="false"/>
<paragraph role="paragraph" id="par_id0916200803551734" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Choose commands for the selected or all rows.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/SID_TABLE_DISTRIBUTE_ROWS" id="bm_id0916200803565265" localize="false"/>
<paragraph role="paragraph" id="par_id0916200804080035" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Distributes the height of the selected or all rows to the same size. The height of the table is not changed.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/SID_TABLE_SELECT_ROW" id="bm_id0916200804004173" localize="false"/>
<paragraph role="paragraph" id="par_id0916200804080063" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">If currently no cell is selected, all rows will be selected. If currently cells are selected, all rows containing the selected cells will be selected.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/SID_TABLE_INSERT_ROW" id="bm_id0916200804032566" localize="false"/>
<paragraph role="paragraph" id="par_id091620080408008" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">If currently no cell is selected, a new row will be inserted at the bottom of the table. If currently cells are selected, as many new rows as the selection has will be inserted below the selection.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/SID_TABLE_DELETE_ROW" id="bm_id0916200804073670" localize="false"/>
<paragraph role="paragraph" id="par_id0916200804080050" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">All rows of the current selection will be deleted.</ahelp></paragraph><comment>Column</comment>
<bookmark xml-lang="en-US" branch="hid/.uno:ColumnMenu" id="bm_id0916200804101754" localize="false"/>
<paragraph role="paragraph" id="par_id0916200804163012" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Choose commands for the selected or all columns.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/SID_TABLE_DISTRIBUTE_COLUMNS" id="bm_id0916200804110358" localize="false"/>
<paragraph role="paragraph" id="par_id0916200804163092" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Distributes the width of the selected or all columns to the same size. The width of the table is not changed.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/SID_TABLE_SELECT_COL" id="bm_id0916200804114925" localize="false"/>
<paragraph role="paragraph" id="par_id0916200804163046" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">If currently no cell is selected, all columns will be selected. If currently cells are selected, all columns containing the selected cells will be selected.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/SID_TABLE_INSERT_COL" id="bm_id0916200804122650" localize="false"/>
<paragraph role="paragraph" id="par_id0916200804163128" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">If currently no cell is selected, a new column will be inserted at the right border of the table. If currently cells are selected, as many new columns as the selection has will be inserted right of the selection.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/SID_TABLE_DELETE_COL" id="bm_id091620080413440" localize="false"/>
<paragraph role="paragraph" id="par_id0916200804163127" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">All columns of the current selection will be deleted.</ahelp></paragraph>
<bookmark xml-lang="en-US" branch="hid/.uno:AlignObjetMenu" id="bm_id0916200804143882" localize="false"/><comment>sic</comment>
<paragraph role="paragraph" id="par_id0916200804163151" xml-lang="en-US" l10n="NEW"><ahelp hid="." visibility="hidden">Align the table within the page or slide.</ahelp></paragraph>
<paragraph role="heading" id="hd_id8594317" xml-lang="en-US" level="2" l10n="NEW">Inserting a native table</paragraph>
<list type="ordered">
<listitem>
<paragraph role="paragraph" id="par_id7184972" xml-lang="en-US" l10n="NEW">Go to the Impress slide or Draw page where you want to insert the table.</paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id248115" xml-lang="en-US" l10n="NEW">Choose <item type="menuitem">Insert - Table</item> or use the Table icon on the Standard toolbar to insert a table.</paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id2748496" xml-lang="en-US" l10n="NEW">Double-click the table and enter or paste the data into the cells. </paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id8270210" xml-lang="en-US" l10n="NEW">Select some cell contents and right-click to open the context menu. Choose commands to change the cell's contents, like font size and line spacing.</paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id6820276" xml-lang="en-US" l10n="NEW">Right-click the table border to open the table's context menu. Use the table's context menu to enter a name and description for the table, or to distribute the rows or columns equally, among other commands.</paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id0916200803551725" xml-lang="en-US" l10n="NEW">Select some cells and right-click to open a context menu, where you can insert or delete rows and columns, among other commands. </paragraph>
<paragraph role="paragraph" id="par_id091620080355171" xml-lang="en-US" l10n="NEW">To select a rectangular area of cells, point to a cell in one corner of the rectangle, hold down the mouse button, and drag the mouse to the opposite corner of the rectangle, then release the mouse button. </paragraph>
<paragraph role="paragraph" id="par_id0916200803551880" xml-lang="en-US" l10n="NEW">To select one cell, point to that cell, hold down the mouse button, and drag the mouse to the next cell and back, then release the mouse button.</paragraph>
</listitem>
</list>
<paragraph role="heading" id="hd_id3151075" xml-lang="en-US" level="2" l10n="CHG" oldref="2">Inserting a new spreadsheet as an OLE object</paragraph>
<paragraph role="paragraph" id="par_id3150715" xml-lang="en-US" l10n="U" oldref="7">You can add a blank $[officename] Calc spreadsheet to a slide as an OLE object.</paragraph>
<list type="ordered">
<listitem>
<paragraph role="listitem" id="par_id3150749" xml-lang="en-US" l10n="U" oldref="3">Go to the slide where you want to insert the spreadsheet.</paragraph>
</listitem>
<listitem>
<paragraph role="listitem" id="par_id3146313" xml-lang="en-US" l10n="U" oldref="18">Choose <emph>Insert - OLE- Object</emph>. Click <emph>Create new</emph> and select the %PRODUCTNAME Spreadsheet. Click OK. Click in the spreadsheet to enter your data. </paragraph>
</listitem>
<listitem>
<paragraph role="paragraph" id="par_id2466505" xml-lang="en-US" l10n="NEW">Click outside the spreadsheet to view the slide.</paragraph>
</listitem>
</list>
<paragraph role="paragraph" id="par_id3148870" xml-lang="en-US" l10n="U" oldref="9">To resize the spreadsheet without resizing the cells, double-click the spreadsheet, and then drag a corner handle. To resize the cells of the spreadsheet, click the spreadsheet, and then drag a corner handle.</paragraph>
<paragraph role="heading" id="hd_id3150215" xml-lang="en-US" level="2" l10n="CHG" oldref="11">Inserting a spreadsheet from a file</paragraph>
<paragraph role="paragraph" id="par_id3154765" xml-lang="en-US" l10n="U" oldref="19">When you insert an existing spreadsheet into your slide, changes that are made to the original spreadsheet file are not updated on your slide. You can, however, make changes to the spreadsheet in your slide.</paragraph>
<list type="ordered">
<listitem>
<paragraph role="listitem" id="par_id3145112" xml-lang="en-US" l10n="U" oldref="12">Go to the slide where you want to insert the spreadsheet.</paragraph>
</listitem>
<listitem>
<paragraph role="listitem" id="par_id3153075" xml-lang="en-US" l10n="U" oldref="13">Choose <emph>Insert - Object - OLE Object</emph>.</paragraph>
</listitem>
<listitem>
<paragraph role="listitem" id="par_id3150391" xml-lang="en-US" l10n="CHG" oldref="14">Select <emph>Create from file</emph>, and click <emph>Search</emph>.</paragraph>
</listitem>
<listitem>
<paragraph role="listitem" id="par_id3150537" xml-lang="en-US" l10n="U" oldref="20">Locate the file you want to insert, and then click<emph> OK</emph>.</paragraph>
<paragraph role="listitem" id="par_id1616565" xml-lang="en-US" l10n="NEW">Enable the <emph>Link to file</emph> checkbox to insert the file as a live link.</paragraph>
</listitem>
</list>
<paragraph role="note" id="par_id3155256" xml-lang="en-US" l10n="U" oldref="21">The entire spreadsheet is inserted into your slide. If you want to change the sheet that is displayed, double-click the spreadsheet, and then select a different sheet.</paragraph>
<embed href="text/shared/00/00000004.xhp#related"/>
<paragraph role="paragraph" id="par_id3154505" xml-lang="en-US" l10n="CHG" oldref="15"><link href="text/simpress/01/05130000.xhp" name="Format - Slide Layout">Format - Slide Layout</link></paragraph>
<paragraph role="paragraph" id="par_id3150335" xml-lang="en-US" l10n="U" oldref="16"><link href="text/shared/01/04150100.xhp" name="Insert - Object - OLE Object">Insert - Object - OLE Object</link></paragraph>
</body>
</helpdocument>
|
