This section describes various ways to change the column properties of a table.To change a column name, double-click the column header and enter the desired text. To change the position of a column, click on the column header cell, and drag the column to the desired location in the table.
A green bar shows the place where the column will be inserted. To change the visibility of a column (show or hide), click the 'visibility' button next to the column name in the column header cell.
By default, all manually created columns in an embedded table are of type 'String'. To change the type of an embedded table column, follow these steps:
1. Right-click the column header, and select 'Column Type' from the context menu. This opens the 'Column Type' dialog box.
2. Select the desired data type from the 'Type' menu, and click 'OK'.
In the following example, we will change the data type of an embedded table column from 'String' to 'Integer':
1. Create a new Worksheet.
2. Create a new embedded table with four rows and four columns.
3. Right-click a header cell and select 'Column Type' from the context menu. This opens the 'Column Type' dialog box.
4. Select 'Integer' from the 'Type' menu and click 'OK'.
To change the formula of an expression column, follow these steps:
1. Click the column header to select it.
2. Click the 'Formula' button in the column header. This opens the Formula Editor.
3. Make the desired changes to the formula, and click 'OK' to close the Formula Editor.
To edit a date range column or numeric range column, follow these steps:
1. Select the column header.
2. Click the Date Range or Numeric Range icon in the header.