Is the expected behavior of the Paste Range to ignore 0 value cells? For example, all quarters started as 1,000 in the first column and total 4K. If the second column is copied and pasted via Slice Paste Range, the top cell does not update to 0. Images below to represent examples.
If yes, is there a way to clear data other than typing in a 0? Data spread → Clear is a Perspectives option that does not appear to be available.
No change in Q1 if right column is copied and pasted using Paste Range.
For most of my use cases/business requirements, the leaf-level input is required and spreading does not work. The end user expects to be able to input in exact values in each quarter/column. The example I show is very simplistic, but the actual use-case would have values that would not be proportional.
