Context Sensitive Menus
From within a cell, row number, or column header in TableView, right-click to display the following context menu items.
Cell Context Menu
- Cut
- Cuts unevaluated plain text and stores it to the clipboard. If another cut or copy
action is performed, this text is lost. Note: Formulas contained in a cell are lost in a cut and paste operation.
- Copy
- Copies unevaluated plain text and stores it to the clipboard. If another cut or copy action is performed, this text is lost.
- Paste
- Pastes a copied or cut text from the clipboard into a cell. You can also copy and
paste the TableView data into an Excel spreadsheet, and conversely,
copy and paste Excel data into TableView. TableView supports multiple lines of data in a single cell. To insert a line break within a
cell, press Alt + Enter.
Note: Formulas contained in a cell are lost in a cut and paste operation.
- Font
- Displays the Font Selector dialog. From here, you can change the font type, style and size of the selected cells.
- Alignment
- Select Auto, Left, Center or Right to align data within the cell. By default, cell data that contains alpha characters (strings) are aligned to the left and cells that contain only numeric (scalar) data are aligned to the right.
- Text Color
- Select a color from the palette to set the text color.
- Background Color
- Select a color from the palette to set the cell background color.
- Merge Cells by Column
- Cells can only be merged if they are adjacent to each other and in the same row;
merging columns is not possible. Note: If the selected cells are in different rows, this option is disabled.If you select a merged cell and adjacent un-merged cells, selecting the Merge Cells Across Columns option merges the un-merged cells with the merged cell. This is disabled if cells in multiple rows or non-adjacent cells in the same row are selected.
- Unmerge Cells by Column
- Merged cells can be unmerged regardless of whether or not they are adjacent or in the same row. In the case of unmerging previously-merged cells, the contents of the merged cell will automatically be placed in the first unmerged cell. For example, if cells C3-G3 have been merged, and the user unmerges them, the contents of the merged cell will all be placed into C3.
- Borders
- Displays the Border dialog. Select a border style to apply to the selected cell(s). Use the Thickness drop-down menu to change the border's line thickness. Click Apply to apply your selection immediately. Click OK to close the dialog.
Row Context Menu
- Insert Above
- Inserts a row above the selected row.
- Insert Below
- Inserts a row below the selected row.
- Cut
- Removes the selected row and stores the evaluated plain text in the clipboard. If another cut or copy action is performed, this text is lost.
- Copy
- Copies evaluated plain text from the selected row and stores it to the clipboard. If another cut or copy action is performed, this text is lost.
- Paste
- Pastes rows from the clipboard. This option is disabled if the clipboard is empty (nothing has been cut or copied).
Column Context Menu
- Insert
- Inserts a column to the left of the selected column.
- Cut
- Removes the selected column and stores the evaluated plain text in the clipboard. If another cut or copy action is performed, this text is lost.
- Copy
- Copies evaluated plain text from the selected column and stores it to the clipboard. If another cut or copy action is performed, this text is lost. If multiple cells are selected, the same number of cells need to be selected to paste them correctly.
- Paste
- Pastes columns from the clipboard. This option is disabled if the clipboard is empty (nothing has been cut or copied).
- Adjust the width
- Adjusts the column width to accommodate the text or numbers in the cell, increasing or decreasing the size as necessary.