Spreading to a range

When you spread data to a range, the cells in the range are filtered before the spread occurs.

Filter 1

If the range to which the data will be spread contains cells of mixed levels of consolidation, all cells are dropped except the cells at the lowest level.

Filter 2a

If the lowest level in the range are leaf cells, cells that are not updateable because of security or other constraints are dropped. Similarly, cells that have holds applied to them are dropped.

Filter 2b

If the lowest level remaining in the range are consolidated cells, all cells that have a consolidated hold are dropped.

Spreading is performed on the remaining cells in the range.