Error occurs when applying the Clear data spreading method when a zero is present in the direction of spreading

Condition

When you attempt to use the Clear data spreading method and a zero (0) is present in any cell that is subject to data spreading in the specified direction of spreading, values are cleared only until the zero value is encountered, at which point further data spreading fails and you receive an error. The error indicates Unable to clear cells. Attempt to update a non-updateable cell.

For example, here you can see the Clear spreading method applied from the highlighted cell, with the right spreading direction indicated (C>).

The full data spreading operation fails because a zero value (Switch, Telephone) is present in the specified direction of spreading. Once the zero value is encountered, spreading ceases and you receive an error. As a result, the entire row is not cleared and a value remains in Switch, Retail.

The error occurs both when using the C data spreading syntax in conjunction with a direction indicator or when using the Data spread option and selecting the Clear method from the right-click menu on a cell.

Further, a hold is placed on the cell from which you initiate the Clear data spreading method. To clear the hold, right-click on the cell, then click Release hold.