UserSpace.clear_cells#
- UserSpace.clear_cells(clear_input=False, recursive=True)#
Clear values from cells with flexible control over scope.
Provides fine-grained control over which cell values to clear:
Calculated values: Always cleared (computed by formulas)
Input values: Optionally cleared (set programmatically)
Scope: Can be limited to this space or include all nested spaces
Unlike
clear_all(), this method does not deleteItemSpaceinstances, only clears values within cells.- Parameters:
clear_input (bool, optional) – If
True, input values are also cleared. IfFalse, only calculated values are cleared. Defaults toFalse.recursive (bool, optional) – If
True, cells in all nested child spaces are also cleared. IfFalse, only direct child cells of this space are cleared. Defaults toTrue.
Example
>>> # Clear only calculated values in all nested spaces >>> space.clear_cells() >>> # Clear both input and calculated values, only in this space >>> space.clear_cells(clear_input=True, recursive=False) >>> # Clear only calculated values in this space >>> space.clear_cells(clear_input=False, recursive=False)
See also
clear_all(): Clear cells and delete ItemSpacesCells.clear: Clear specific cellsCells.clear_at: Clear specific cell value
Added in version 0.16.0.