Q. What are the Smart Edit operations available?
A. Currently the main mathematical operations: Add, Subtract, Multiply and Divide. More features will be added in future releases.
Q. Can I use Smart Edit to bypass Cell Validation rules?
A. No, you cannot. Smart Edit is aware of all Cell Validation rules and will warn or prevent you as applicable when a rule is breached.
Q. Can I run a Smart Edit across multiple columns if they are all numeric?
A. No, Smart Edit can only be used on a single column at at time. This is to ensure that all Cell Validation rules are adhered to.
Q. My column contains strings in some cells and numbers in others. Can I use Smart Edit on the numeric cells?
A. No - primarily because many of the underlying grids wouldn't be able to accept the edit.
Q. Can I create custom Smart Edit rules (e.g. to move by bps or other amounts)?
A. Not at present but the forthcoming Smart Edit Toolbar will contain a range of very advanced, customisable and exciting Smart Edit features
Q. Can I use Smart Edit to perform a bulk edit?
A. No, Smart Edit only updates existing cell values. if you want to replace the existing cell value with a new one entirely, please use the Bulk Update function.