AdapTable Version:

Framework:

Smart Edit

Summary

Smart Edit applies a single mathematical edit to numerous, numeric cells
The Operation can be either:
- one of the 4 System Smart Edit Operations provided by Adaptable
- a Custom Smart Edit Operation supplied by a developer at design time

Smart Editing enables multiple, contiguous numeric cells to be updated with a single mathematical operation.

The System Smart Edit Operations - supplied by AdapTable - are:

Addition
Subtraction
Multiplication
Division

For example a Smart Edit value of 10 with an operation of Multiply, will multiply all selected cells by 10.

Applying Smart Edit

Smart Edits can be applied in 3 places in AdapTable:

Smart Edit Toolbar
Smart Edit Tool Panel
Smart Edit Popup

Hint
The Smart Edit Popup can also be accessed by selecting Apply Smart Edit in the Context Menu

UI Step by Step Guide

Applying a Smart Edit

Smart Edit

Fork Fork

This example shows how to use Smart Edit

Try It Out

Click the Green tick in the Smart Edit toolbar to multiply the selected values by 10

Custom Smart Edit Operations

Developers can provide Custom Smart Edit Operations in addition to those shipped by AdapTable.

This is done via the smartEditCustomOperations property in Edit Options.

smartEditCustomOperations

SmartEditCustomOperation[]

Custom Operations to use in Smart Edit Module

SmartEditCustomOperation[]

Custom Smart Edit Operations to be provided by Developers in addition to those shipped by AdapTable.

Each Custom Operation has 2 properties:

name - how the Operation is referenced in the Smart Edit dropdown
operation - function invoked by AdapTable when Smart Edit is run, and which returns the new numeric cell value

The operation function receives SmartEditOperationContext defined as follows:

Property	Description
currentCell	Current selected grid cell - contains column, row and cell value information
smartEditValue	Smart Edit value
adaptableContext	Custom application Context provided in `AdaptableOptions.adaptableContext`

editOptions: {
  smartEditCustomOperations: [
    {
      name: 'Power',
      operation: (context: SmartEditOperationContext) => {
        return Math.pow(context.currentCell.rawValue, context.smartEditValue);
      },
    },
  ],
},

Smart Edit Custom Operations

Fork Fork

This example includes 2 Custom Smart Edit Operations:
- Power - which pows the selected cell by the Smart Edit Value
- bps - which adds the Smart Edit Value as Basis Points
Note: we have used methods in Smart Edit API to set the Smart Edit Operation to Power

Expand to see the Custom Smart Edit Operations

editOptions: {
  smartEditCustomOperations: [
    {
      name: 'Power',
      operation: (context: SmartEditOperationContext) => {
        return Math.pow(context.currentCell.rawValue, context.smartEditValue);
      },
    },
    {
      name: 'bps',
      operation: (context: SmartEditOperationContext) => {
        const initialValue = context.currentCell.rawValue;
        const bpChange = context.smartEditValue / 100 / 100;
        return initialValue + initialValue * bpChange;
      },
    },
  ],
},

Deep Dive

Smart Edit and Data Validation

AdapTable will prevent you from applying a Smart Edit which breaks a Data Validation Rule

The new values table will indicate - and provide details - if a Smart Edit will break a Validation Rule.

In addition AdapTable does the following:

Validation	Apply Smart Edit Button Behaviour
All Valid	Has a success colour (default is green)
Some are Invalid	Has a warning colour (default is amber) and only valid edits will be applied
All are Invalid	Has an error colour (default is red) and is disabled and the operation is not accessible

Custom Smart Edit Operations

(Recorded with AdapTable v16.0)

FAQ

Can I use Smart Edit to bypass Prevent Edit Alerts? No, Smart Edit is aware of Data Validation rules and will warn or prevent you as applicable if one 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, to ensure that Data Validation 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, Smart Edit only works where the entire Column is identified as Numeric.

Can I create custom Smart Edit rules (e.g. to move by bps or other amounts)? Yes, this was introduced in Adaptable 12

I don't want to use a formula to update the cell, I just want to replace the current value with a new one? You can use Bulk Update to replace the cell value with a new one entirely.

PreviousData Entry NextTechnical Reference

Smart Edit

Summary

Applying Smart Edit

Hint

UI Step by Step Guide

Applying a Smart Edit

Note

Hint

Custom Smart Edit Operations

smartEditCustomOperations

Expand to see the Custom Smart Edit Operations

Deep Dive

Smart Edit and Data Validation

Custom Smart Edit Operations

FAQ