Spreading to a single leaf cell

Spreading to a single leaf cell updates the cell unless it is not updatable because of security limitations or some other constraint, or if a hold is applied to it.

A leaf cell on hold is never updated by a spread function. It may be updated by manually changing the cell through the user interface, or by updating a single cell value with the TM1 REST API.

If one of the ancestors of the leaf cell is on consolidation hold, other leaf components of the ancestor are adjusted to keep the consolidated value constant.