Inserting Data From Spreadsheets /text/shared/guide/copytable2application.xhp Sun Microsystems, Inc. converted from old format - fpe charts;copying with link to source cell range inserting; cell ranges from spreadsheets pasting;cell ranges from spreadsheets presentations;inserting spreadsheet cells text documents;inserting spreadsheet cells tables in spreadsheets;copying data to other applications mw 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.