Including Spreadsheets in Slides /text/simpress/guide/table_insert.xhp spreadsheets;in presentations presentations;inserting spreadsheets including spreadsheets

Including Spreadsheets in Slides

You can apply different methods to insert spreadsheet cells into your Impress slides or Draw pages: Insert a native table - you enter the data into the cells and apply fancy formatting using the Table Design section on the Tasks pane. 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. Insert table dialog - Number of columns Enter the number of columns for the new table.Insert table dialog - Number of rows Enter the number of rows for the new table.Contextmenu of a table in Impress and DrawCell Define the vertical alignment of selected or all cell contents. Split or merge cells. The cell contents are align at the top of the cells. The cell contents are aligned vertically centered in the cells. The cell contents are aligned at the bottom of the cells. Selects the current table. Row Choose commands for the selected or all rows. Distributes the height of the selected or all rows to the same size. The height of the table is not changed. 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. 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. All rows of the current selection will be deleted.Column Choose commands for the selected or all columns. Distributes the width of the selected or all columns to the same size. The width of the table is not changed. 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. 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. All columns of the current selection will be deleted. sic Align the table within the page or slide.

Inserting a native table

Go to the Impress slide or Draw page where you want to insert the table. Choose Insert - Table or use the Table icon on the Standard toolbar to insert a table. Double-click the table and enter or paste the data into the cells. 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. 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. Select some cells and right-click to open a context menu, where you can insert or delete rows and columns, among other commands. 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. 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.

Inserting a new spreadsheet as an OLE object

You can add a blank $[officename] Calc spreadsheet to a slide as an OLE object. Go to the slide where you want to insert the spreadsheet. Choose Insert - OLE Object - OLE Object. Click Create new and select the %PRODUCTNAME Spreadsheet. Click OK. Click in the spreadsheet to enter your data. Click outside the spreadsheet to view the slide. 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.

Inserting a spreadsheet from a file

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. Go to the slide where you want to insert the spreadsheet. Choose Insert - OLE Object - OLE Object. Select Create from file, and click Search. Locate the file you want to insert, and then click OK. Enable the Link to file checkbox to insert the file as a live link. 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.

Format - Slide Layout Insert - OLE Object - OLE Object