Smart Edit Module

The Smart Edit Module provides a way to update multiple, contiguous numeric cells with a single mathematical operation (e.g. Multiply).

Rather than users needing to change multiple columns individually, Smart Edit enables the selection of a group of cells in one numeric column, and for a single operation to be applied on all the cells (based on each cell value).


If the proposed Smart Edit breaks a Prevent Edit Alert Rule then the operation will not be allowed

Smart Edit Operations

The following mathematical operations are available:

  • Addition
  • Subraction
  • Multiplication
  • Division

There is currently no provision for users to add their own Smart Edit operations via custom functions but this will be added in a forthcoming release.

UI Elements

Smart Edit includes the following UI Elements:

  • Popup - Allows Smart Edit operation to be performed on selected cells. Shows what the new value for each selected cell will be and also whether any Prevent Edit Alerts will be broken as a result of the Smart Edit.

  • Toolbar - Enables Smart Edit to be performed and to choose the Operation to use.

  • Tool Panel - Same as Toolbar above.

  • Context Menu - Apply Smart Edit Menu Item opens the Smart Edit popup (only visible if selected cells are editable, numeric and from on a single column).

UI Entitlements

UI Entitlements behaviour is as expected for Full and Hidden Access Levels.

The ReadOnly Entitlement behaviour is the same as if the Access Level was Hidden.

Smart Edit API

applySmartEdit(gridCells)Applies a Smart Edit to given Cells
getSmartEditOperation()Gets current Smart Edit Operation ('Add','Subtract','Multiply','Divide' or 'Replace')
getSmartEditValue()Returns current Smart Edit Value
setSmartEditOperation(operation)Sets operation to use in Smart Edit
setSmartEditValue(smartEditValue)Sets Smart Edit Value (e.g. to multiply by 10 then smartEditValue is 10)
showSmartEditPopup()Opens Smart Edit popup screen


What are the Smart Edit operations available?

Currently the main mathematical operations: Add, Subtract, Multiply and Divide. More features will be added in future releases.

Can I use Smart Edit to bypass Prevent Edit Alerts?

No, you cannot. Smart Edit is aware of all Prevent Edit Alert rules and will warn or prevent you as applicable when a rule is breached.

Can I run a Smart Edit across multiple columns if they are all numeric?

No, Smart Edit can only be used on a single column at at time. This is to ensure that all Prevent Edit Alert rules are adhered to.

My column contains strings in some cells and numbers in others. Can I use Smart Edit on the numeric cells?

No - primarily because many of the underlying grids wouldn't be able to accept the edit.

Can I create custom Smart Edit rules (e.g. to move by bps or other amounts)?

Not at present but the Smart Edit Toolbar will soon contain a range of very advanced, customisable and exciting Smart Edit features

Can I use Smart Edit to perform a bulk edit?

No, Smart Edit only updates existing cell values. Use the Bulk Update Module to replace an existing cell value with a new one entirely

More Information