[Libreoffice-ux-advise] [Bug 151205] New Paste Special Operations: Maximum, Minimum

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=151205

--- Comment #4 from Robert Lacroix <ralacroix at hydro.mb.ca> ---
Basically there's no need do any arithmetic operations with Paste Special as
it's always possible to contain those operations in another spreadsheet range
which can be copied and recorded with Paste-Special Number. It's just a
convenience, sometimes a really big convenience, and it reduces the number of
spreadsheet cells.

Example use case:
Tracking a set of measurements where there is no need to keep the history of
measurements, only the last value and the "best" value to date, where "best"
value is typically a maximum or minimum.

One such measurement is the price of a stock option (before expiry date) which
will expire worthless. Such an option will have a maximum price, and it is
desirable to sell such an option as close as possible to that price. Thus it is
necessary to keep track of the maximum price even if you don't keep the entire
price history.

It's best to automate data captures, but manual sampling must occur where
automation is not available such as when there is no API. In this case, every
convenience is a bonus to the user.

-- 
You are receiving this mail because:
You are on the CC list for the bug.