Adding Tables, Spreadsheets, and Charts

From Apache OpenOffice Wiki
Jump to: navigation, search



Adding Tables, Spreadsheets, and Charts

Tables are a useful way to organize and present large amounts of information. They can often be used as an alternative to spreadsheets. Tables can also be used as a page layout tool to position text in areas of a document, as described in Chapter 4 (Formatting Pages) of the Writer Guide.

To insert a new table, position the cursor where you want the table to appear, then use any of the following methods to open the Insert Table dialog, where you can specify the properties for the new table:

  • From the main menu, choose  → Insert → Table.
  • From the main menu, choose Table → Insert → Table.
  • Press  Ctrl  +  F12  on the keyboard.
  • From the Standard toolbar, click the Table icon AOO41GS4 TableIcon.png.

You can also click the small arrow to the right of the Table icon and select the number of cells to directly insert a table with the default table properties.

You can create a table from text, or convert a table to text, using Table → Convert from the menu bar.

You can edit the contents of these tables in the same way as you edit any other text.

A possible source of confusion is the Number Recognition feature of a table. If it is turned on, numbers and dates will be automatically formatted. If this is not desired, select the table cells you want to affect, then right click and deselect Number Recognition.

Chapter 9 (Working with Tables) in the Writer Guide describes how to format tables, add or delete columns and rows, merge and split tables and cells, add and sort data, and perform basic spreadsheet functions in a table of data.

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