Moderator: Phil Barton
Conversely, if the user typed a value into the cell thereby overriding rules, GetIsCalculated() returns false.
There is one variable type to be careful with. If the user enters data in a String property, GetIsCalculated() will return false (as expected). But if the user deletes all the characters in the field using Backspace, Delete, or Ctrl+X keys, GetIsCalculated() will still return false since you have effectively entered an empty string (string of length 0). The only way to restore the field to being calculated is to F2 the field.