Updating the value of a cell results in the updating of other dependent properties, such as FORMATTED_VALUE.
It is provider specific whether dependent properties can be updated. If they can be updated, then it is provider-specific what happens to the determining property (such as VALUE) when a dependent property (such as FORMATTED_VALUE) is updated. For cleaner semantics, providers are encouraged to make dependent properties read-only. This specification does not mandate which properties are dependent on which other properties.
Updating a cell (in other words, the corresponding row in the range rowset) that has an atomic value results in changes to all aggregates based on that cell.