Runtime View:

Worksheet supports selecting single row by clicking on any cell of the row. It also supports multi-row selection with Shift and Ctrl keys. By right clicking on any cell, worksheet control shows context menu with same commands as the toolbar. Worksheet control also supports Column resizing when its columns are configured with Column Width Percentage mode.

Main Worksheet:

Nested Rows Worksheet:

• Add: Select Add action to add row after the selected row.
• Insert: Select Insert action to add row based on the existing item. In order to select existing item, it shows search dialog.
• Open Relationship Item: Select OpenRelationshipItem action to open relationship item in its own tab.
• Open Related Item: Select Open Related Item action to open related item in its own tab.
• Up: Select Up action to move selected row above the previous row.
• Down: Select Down action to move selected row below the next row.
• Delete: Select Delete action to delete selected row from the worksheet.
• Cut: Select Cut action to cut selected cell or row from the worksheet.
• Copy: Select Copy action to copy selected cell or row from the worksheet.
• Paste: Select Paste action to paste data from the clipboard to the selected cell or insert row after the selected row.
• Export: Select Export action to export all the data shown in the worksheet to an excel file.