Inserting Data From Spreadsheets/text/shared/guide/copytable2application.xhpSun Microsystems, Inc.charts;copying with link to source cell rangeinserting; cell ranges from spreadsheetspasting;cell ranges from spreadsheetspresentations;inserting spreadsheet cellstext documents;inserting spreadsheet cellstables in spreadsheets;copying data to other applicationsmw deleted "tables;" and added "charts;" and "tables in spreadsheets;"
Inserting Data From Spreadsheets
Use the clipboard to copy the contents of a single cell. You can also copy a formula from a cell into the clipboard (for example, from the input line of the formula bar) so that the formula can be inserted into a text.To copy a cell range into a text document, select the cell range in the sheet and then use either the clipboard or drag-and-drop to insert the cells into the text document. You will then find an OLE object in the text document, which you can edit further.If you drag cells to the normal view of a presentation document, the cells will be inserted there as an OLE object. If you drag cells into the outline view, each cell will form a line of the outline view.When you copy a cell range from $[officename] Calc to the clipboard, the drawing objects, OLE objects and charts within this range are also copied.If you insert a cell range with an enclosed chart, the chart will keep its link to the source cell range only if you copied the chart and the source cell range together.