| Summary: | Function TRANSPOSE misses an example | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Dennis Roczek <dennisroczek> |
| Component: | Documentation | Assignee: | Joel Madero <jmadero.dev> |
| Status: | RESOLVED FIXED | ||
| Severity: | normal | CC: | heiko.tietze, jmadero.dev, mentoring |
| Priority: | medium | Keywords: | difficultyBeginner, easyHack, skillDesign |
| Version: | Inherited From OOo | ||
| Hardware: | All | ||
| OS: | All | ||
| URL: | https://help.libreoffice.org/Calc/Array_Functions#FREQUENCY | ||
| Whiteboard: | target:5.3.0 | ||
| Crash report or crash signature: | Regression By: | ||
| Bug Depends on: | |||
| Bug Blocks: | 80430 | ||
| Attachments: | Two screenshots related with transpose | ||
|
Description
Dennis Roczek
2016-10-22 00:03:43 UTC
Really easy issue to resolve: http://opengrok.libreoffice.org/xref/help/source/text/scalc/01/04060107.xhp Example can be based on any of the other examples in the same file. I'm just about done with this. Thoughts: http://imgur.com/a/oD3sU Created attachment 128288 [details]
Two screenshots related with transpose
If you're looking for input from the design team you could CC the ux-advice mailing list; only skilldesign (that I was searching for) is not effective.
My two cents anyway: It took me a while to figure out what it means. Typically I transpose per paste special dialog and expect row and col exchanged. The image looks like a 5x3 matrix transposed to 3x5 and I couldn't follow. The reason to my misunderstanding is obviously that you add column headers (A...D) and row titles (1..x). If you mark those per grey background it is much easier to understand.
Regarding design I would make the columns a little bit wider, perhaps squared or use text. And an example with before/after with the formula at the connector is perfect, IMHO. Feel free to use or modify what I attached.
Regarding the text it is not necessary to have a range selected, at least this part is unclear and wouldn't be helpful for me. Most relevant information is to press shift+enter, however. And I wonder how to not lock the range after transposing it. Looks like only via copy/paste special, which could be stated in the help. (And lead to the enhancement request to have this option with the command.)
Joel Madero committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/help/commit/?id=578e1e320daaa82b2d3b8c0eeea84bf704967939 tdf#103397 - added example for Transpose function Seems solved |