Context Menus

Developers can customize the context menu.

Here are actions available in all SaveToDB products:

The SaveToDB add-in additionally supports:

See more details at Handler Types.

To add menu items, use records with the ContextMenu event type in the xls.handlers table.

For example:

TABLE_SCHEMA	TABLE_NAME	EVENT_NAME	HANDLER_SCHEMA	HANDLER_NAME	HANDLER_TYPE	HANDLER_CODE	TARGET_WORKSHEET	MENU_ORDER	EDIT_PARAMETERS
s04	usp_order_form	ContextMenu	s04	Google Search	HTTP	https://www.google.com/search?as_q={name}		11
s04	usp_order_form	ContextMenu	s04	MenuSeparator40	MENUSEPARATOR			40
s04	usp_order_form	ContextMenu	s04	xl_actions_items_insert_item	PROCEDURE		_Reload	41	1
s04	usp_order_form	ContextMenu	s04	xl_actions_items_delete_item	PROCEDURE		_Reload	47	1
s04	usp_order_form	ContextMenu	s04	xl_actions_items_rename_item	PROCEDURE		_Reload	49	1

This sample has two item sections separated by a menu separator.

Menu separators must have names, as the table has a unique index that includes columns from TABLE_SCHEMA to HANDLER_NAME.

You can use the translation features to define business names for menu items. See Translating Object Names.

Use integer values in the MENU_ORDER column to order items.

Pay attention to the _Reload value in the TARGET_WORKSHEET column.

You can use it to reload data after executing the handler. See more options at Target Worksheet Values.

Pay attention to 1 in the EDIT_PARAMETERS column. You can use this to run the dialog box used to edit parameters.

Context Parameters

Context menu handlers can use values from the active row, values of the active query parameters, and the following context parameters:

Parameter Name	Value
@ColumnName or @column_name	The active column name
@CellValue or @cell_value	The active cell text value
@CellNumberValue or @cell_number_value	The active cell number value
@CellDateTimeValue or @cell_datetime_value	The active cell datetime value
@DataLanguage or @data_language	A data language code selected using the Options dialog box
@TableName or @table_name	A qualified name of the active query object like [s02].[usp_cashbook]
@WindowsUserName or @windows_user_name	The Windows login of the current user