Including Spreadsheets in Slides/text/simpress/guide/table_insert.xhpspreadsheets;in presentationspresentations;inserting spreadsheetsincluding spreadsheetsIncluding 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 paneInsert 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 fileInsert table dialog - Number of columnsEnter the number of columns for the new table.Insert table dialog - Number of rowsEnter the number of rows for the new table.Inserting a native tableGo 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. Right-click a cell to open the context menu and choose additional commands regarding the cell's contents.Right-double-click the table border to open the table's context menu. Use the context menu to insert or delete rows and columns, among other commands.Inserting a new spreadsheet as an OLE objectYou 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. 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 fileWhen 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 - 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 LayoutInsert - Object - OLE Object