[Libreoffice-bugs] [Bug 151205] New Paste Special Operations: Maximum, Minimum
https://bugs.documentfoundation.org/show_bug.cgi?id=151205 Telesto changed: What|Removed |Added CC||libreoffice-ux-advise@lists ||.freedesktop.org, ||tele...@surfxs.nl Keywords||needsUXEval -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 151205] New Paste Special Operations: Maximum, Minimum
https://bugs.documentfoundation.org/show_bug.cgi?id=151205 Rafael Lima changed: What|Removed |Added CC||rafael.palma.l...@gmail.com --- Comment #1 from Rafael Lima --- I'm not so sure about that. Currently we support the basic mathematical functions (Add, Subtract, Multiply, Divide). If we add others such as Maximum and Minimum, then why not also add others as Average, Round, Power and so on? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 151205] New Paste Special Operations: Maximum, Minimum
https://bugs.documentfoundation.org/show_bug.cgi?id=151205 --- Comment #2 from Roman Kuznetsov <79045_79...@mail.ru> --- I don't see user case for it, is there a real example where it would be useful? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 151205] New Paste Special Operations: Maximum, Minimum
https://bugs.documentfoundation.org/show_bug.cgi?id=151205 Heiko Tietze changed: What|Removed |Added Status|UNCONFIRMED |NEEDINFO Ever confirmed|0 |1 --- Comment #3 from Heiko Tietze --- Min/Max would be to keep this value or use the source. Kind of =IF(A1>B1;A1;B1) but at the same target cell, eg B1. Wonder as well if there is a general use case. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 151205] New Paste Special Operations: Maximum, Minimum
https://bugs.documentfoundation.org/show_bug.cgi?id=151205 --- Comment #4 from Robert Lacroix --- 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 the assignee for the bug.
[Libreoffice-bugs] [Bug 151205] New Paste Special Operations: Maximum, Minimum
https://bugs.documentfoundation.org/show_bug.cgi?id=151205 Robert Lacroix changed: What|Removed |Added Ever confirmed|1 |0 Status|NEEDINFO|UNCONFIRMED -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 151205] New Paste Special Operations: Maximum, Minimum
https://bugs.documentfoundation.org/show_bug.cgi?id=151205 Eyal Rozenberg changed: What|Removed |Added Blocks||108479 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=108479 [Bug 108479] [META] Paste special bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 151205] New Paste Special Operations: Maximum, Minimum
https://bugs.documentfoundation.org/show_bug.cgi?id=151205 --- Comment #5 from Eyal Rozenberg --- I say go for it. There's a little room left on the dialog as is, so why not? When somebody asks for more functions, we could consider reducing the number of explicit functions and adding a text box or button for function lookup etc. Also, Robert, please have a look at my bug 15 - your general sentiment of expanding functionality here may agree with its spirit. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 151205] New Paste Special Operations: Maximum, Minimum
https://bugs.documentfoundation.org/show_bug.cgi?id=151205 --- Comment #6 from Rafael Lima --- (In reply to Eyal Rozenberg from comment #5) > I say go for it. There's a little room left on the dialog as is, so why not? > > When somebody asks for more functions, we could consider reducing the number > of explicit functions and adding a text box or button for function lookup > etc. If we decide to do something like this, we could replace the existing operations by a dropdown list with all the possible functions, including MIN and MAX. Basically, all functions that have 2 arguments could be used. I just wonder if this wouldn't get too messy UX-wise. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 151205] New Paste Special Operations: Maximum, Minimum
https://bugs.documentfoundation.org/show_bug.cgi?id=151205 Cor Nouws changed: What|Removed |Added CC||c...@nouenoff.nl --- Comment #7 from Cor Nouws --- (In reply to Robert Lacroix from comment #4) > 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. 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 -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 151205] New Paste Special Operations: Maximum, Minimum
https://bugs.documentfoundation.org/show_bug.cgi?id=151205 --- Comment #8 from Robert Lacroix --- (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 the assignee for the bug.
[Libreoffice-bugs] [Bug 151205] New Paste Special Operations: Maximum, Minimum
https://bugs.documentfoundation.org/show_bug.cgi?id=151205 --- Comment #9 from Cor Nouws --- (In reply to Robert Lacroix from comment #8) > 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. So I copy a value, say 3. Then select a range with 4 cells, values 4, 6, 8, 5 Paste > Special > Max. Then? -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 151205] New Paste Special Operations: Maximum, Minimum
https://bugs.documentfoundation.org/show_bug.cgi?id=151205 Heiko Tietze changed: What|Removed |Added Resolution|--- |WONTFIX Blocks||145878 Status|UNCONFIRMED |RESOLVED --- Comment #10 from Heiko Tietze --- We discussed the topic briefly in the design meeting. What I understand is that you copy a range like A1:A5 and paste it onto the same range at B1:B5 with the expectation to either use the minimum or maximum of both. Use case is to find the minimum temperature or the highest value of a blood pressure. The terms Min/Max are a bit misleading since it is an attribute of a distribution. You rather ask for Lower/Higher, which would be unclear in itself too. Putting all comments together the concerns about too many operations predominate and the recommendation is to implement the feature via extension. Although I'm closing the ticket as WF please feel free to reopen. As a open source project any volunteer is free to submit patches - and I guess it would be accepted despite the concerns from the UX POV. Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=145878 [Bug 145878] [META] Enhancements that could be realized per extension -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 151205] New Paste Special Operations: Maximum, Minimum
https://bugs.documentfoundation.org/show_bug.cgi?id=151205 --- Comment #11 from Robert Lacroix --- (In reply to Cor Nouws from comment #9) > (In reply to Robert Lacroix from comment #8) > > > 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. > > So I copy a value, say 3. > Then select a range with 4 cells, values 4, 6, 8, 5 > Paste > Special > Max. > > Then? After the processing is done, there is no change to the destination range, they are all already more than 3. There's nothing special about this - you would get a "no change" result if the copied value is 0 and the operation is Paste > Special > Add. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 151205] New Paste Special Operations: Maximum, Minimum
https://bugs.documentfoundation.org/show_bug.cgi?id=151205 --- Comment #12 from Robert Lacroix --- (In reply to Heiko Tietze from comment #10) > We discussed the topic briefly in the design meeting. > > What I understand is that you copy a range like A1:A5 and paste it onto the > same range at B1:B5 with the expectation to either use the minimum or > maximum of both. Use case is to find the minimum temperature or the highest > value of a blood pressure. > > The terms Min/Max are a bit misleading since it is an attribute of a > distribution. You rather ask for Lower/Higher, which would be unclear in > itself too. > > Putting all comments together the concerns about too many operations > predominate and the recommendation is to implement the feature via extension. > > Although I'm closing the ticket as WF please feel free to reopen. As a open > source project any volunteer is free to submit patches - and I guess it > would be accepted despite the concerns from the UX POV. "Greater of/Lesser of" might work. But that's just English semantics. I can't imagine what it would be with other locale settings. It might be very clear in some other languages. Semantics can be very challenging when context is missing. In Tagalog there are 2 different words for the English word "we": inclusive of the person being spoken to, or exclusive; it has clarity without context. If we can make things clear without regard to the language, then we have a good UX design. -- You are receiving this mail because: You are the assignee for the bug.