https://bugs.documentfoundation.org/show_bug.cgi?id=151205
--- Comment #8 from Robert Lacroix <ralacr...@hydro.mb.ca> --- (In reply to Cor Nouws from comment #7) > > In the cases with Add, Substract etc, the steps are: > - copy a value from a random place > - select a range with values > - paste special with the action. > > How would you use Maximum or Minimum if added to the Paste Special options? > > Thanks, > Cor In exactly the same way. The operation between cells in the copied range (source) is performed with cells in the destination range. The dimensions of the source and destination ranges are the same, or the source range is a single cell and the destination has multiple cells. In your example, the source range has only one cell. Each cell of the destination would receive the min or max (as selected) of that cell with the source cell. If you like, you can think of this like saturating a signal in an electrical circuit. The set of destination values (the signal) would be limited on the low side by the Maximum operation with a lower limit (source) cell, and on the high end by the Minimum operation with an upper limit (source) cell. -- You are receiving this mail because: You are on the CC list for the bug.
