Creating a Table from a Calc Spreadsheet

From Apache OpenOffice Wiki
Jump to: navigation, search



Creating a Table from a Calc Spreadsheet

You can insert a table from a Calc spreadsheet into a Writer document:

  1. Open the Calc spreadsheet containing the cell range that you want to insert.
  2. In the spreadsheet, select the cells.
  3. Choose Edit → Copy or press  Ctrl  +  C .
  4. In the Writer document, choose Edit → Paste or press  Ctrl  +  V . The cell range is pasted as an object.

Alternatively, you can open both the Calc and Writer documents and drag and drop the cells from Calc to Writer:

  1. In the spreadsheet, select the cells.
  2. Click and hold the mouse button in the selected cells.
  3. Drag the selected cells into the text document.

To edit a table created from a Calc spreadsheet, double-click on it. The table opens in Calc.

Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY).
Personal tools