This property allows you to set or retrieve the status of the context menu shown on grid columns headings. The context menu allows you to choose between hiding or showing a column, exporting data to xls/xlsx spreadsheets, copying data to the clipboard and searching text in the grid.

The possible values for this property, defined in isgui.def, are:

The above values can be combined in order to obtain the desired effect. Setting the property to the value 63 makes all the items available in the menu shown by right clicking as well as in the menu shown by clicking on the top right corner of the gird.

When the ‘Export’ option is selected, a Save As dialog is shown to allow the user to choose where to save the exported data. The fields of this dialog are preset according to the properties Export-File-Name and Export-File-Format. Font and colors are replicated in the exported file, while bitmaps and embedded controls are not. In the generated spreadsheet, the cells corresponding to Grid’s headings use a general format while the cells corresponding to the Grid’s data use a specific format (Number, Date or Text) depending on the Data-Types of the column.

When the ‘Copy to Clipboard’ option is selected, the Grid content is copied to the clipboard. If you’re using Java 7 or greater, the text style (font and colors) is copied as well. If Selection-Mode is set to a value greater than 0, then only selected cells are copied to the clipboard.

The Column-Hiding property is automatically set to 1 for the columns that the user unchecked and 0 for the other columns.

Example - Define a Grid where the list of columns is shown in the menu that appears by right clicking on the heading, while the export option appears by clicking on the top right corner of the grid, and where the ‘Copy to clipboard’ option is not available.