I am using LO Calc 220.127.116.11 on Ubuntu 20.04. When I copy a range of cells containing formulas (ex: a column of numbers resulting from a formula) and I want to copy and paste the values transposed onto a row, it keeps pasting values as a column.
Steps to reproduce:
1 - Create a column of formulas resulting in numbers
2 - Ctrl-C to copy the cells containing the formula results
3 - Ctrl + Shift + V to open Paste Special dialog
4 - Check the "Transpose" option
5 - Click "Paste Values-Only" button at the top left corner of the dialog
Results: It paste the values, but without transposing them
Note that if I click the "Transpose" button at the top right corner of the dialog and uncheck the "Formula" option, it will still paste the transposed Formulas.
I think there is either a bug here of at least some inconsistency with this dialog box.
In any case, I cannot paste transposed values.
UPDATE: I learned the correct way to paste transposed values only. I just needed to uncheck "Formula" and check "Transpose" and then click "Ok".
Anyway, as an end user I think the dialog box could be redesigned, because those buttons at the top of the dialog are confusing. They give the impression that the options below will be applied after you click them.
If possible, I'd like to change this bug report to an Enhancement request.
Created attachment 163020 [details]
Prototype for a new Paste Special Dialog box
In addition to my previous comments, I would like to propose a new design for the Paste Special dialog box. The main highlights are:
- Redesign of the quick action buttons, with the addition of two new actions
- Addition of the Shif cels up and left options
Pls then change the 'importance' from 'normal' to 'enhancement' and change bug title accordantly.
I changed the title and the "Importance" to indicate that this is an enhancement request.
[Automated Action] NeedInfo-To-Unconfirmed
I like the proposed design of the dialog window, especially:
+ "Quick actions" title in addition to the "Custom actions" title.
+ The quick action buttons have a symbol AND text description per default. (It's always irritating to wait for a tool tip when moving the mouse cursor over the symbols in the current dialog.)
+ More "Quick actions" than now. Paste All, Values only and Formats are important options so that the user hasn't to click through all the check boxes below.
- What's with the "Operations" actions of the current dialog? They're missing in the proposal.
- Are the "Custom actions" and "Shift cells" options linked together (in opposite to the "Quick actions" above)? Then they should all be grouped so that it's visible for the user that 'Paste All', 'Text', etc. and 'Don't shift', 'Down' etc. are all part of the "Custom actions" and that they have nothing to do with the "Quick actions".
Do we have metrics which option combinations are most used by LibreOffice users?
In addition to Thomas' comment: Keep localization in mind, words are usually longer in other languages. Putting Selection and Options together is questionable.
But more quick actions are nice to have and brings me to the idea of our three-column layout. Why not have the quick actions as a (extendable) preset list on the left and we show the configuration on single click (double to execute). Right hand there could be some kind of graphics as a preview.
Created attachment 165552 [details]
ODG file with the proposed dialog
I attached the ODG file with the proposed dialog so that other people can edit it and improve the proposal.
The file has 2 pages:
1) The original proposal that was posted as a PNG file
2) A new proposal with the addition of the "Operations" section
> - What's with the "Operations" actions of the current dialog? They're
> missing in the proposal.
I had left them out in the original proposal to make the dialog look "cleaner". I added them in the new proposal that has been attached as an ODG file.
> - Are the "Custom actions" and "Shift cells" options linked together (in
> opposite to the "Quick actions" above)? Then they should all be grouped so
> that it's visible for the user that 'Paste All', 'Text', etc. and 'Don't
> shift', 'Down' etc. are all part of the "Custom actions" and that they have
> nothing to do with the "Quick actions".
I considered them as a separate block for 2 reasons:
1) Shift actions use radio buttons meaning that only one can be selected, whereas Custom actions use checkboxes because multiple actions can be selected.
2) This separation is consistent with the current design; The main change I did was combining the existing "Options" section with the "Selection" section, which all use checkboxes.
> Do we have metrics which option combinations are most used by LibreOffice
This would be useful, because I believe some actions are rarely used. I chose the buttons at the top based on my way of using Calc and also on the opinions of my students, who often use Calc and ask where some functions are.
Created attachment 167541 [details]
Example for solutions
From left to right: Current situation, Proposal with 3 columns, Proposal with 4 columns, and Presets (see comment 7) (the buttons should show Image+Text but don't out of the box; "Run Immediately" off means the button applies settings only)
(In reply to Heiko Tietze from comment #10)
> Created attachment 167541 [details]
> Example for solutions
> From left to right: Current situation, Proposal with 3 columns, Proposal
> with 4 columns, and Presets (see comment 7) (the buttons should show
> Image+Text but don't out of the box; "Run Immediately" off means the button
> applies settings only)
I like a last right variant with Presets in first column, but I dislike icons on buttons in that case. I would prefer buttons with labels there
And I would change "Selection" label to "Paste" and item label "Paste all" to simple "All" like:
I liked the last layout, with the 5 buttons stacked. However, I guess it would look nicer if the icons were followed by some text.
I understand the localization issue, however the labels for the Presets are short. Maybe it won't be a big issue. Also, don't button sizes in the dialog adjust to the label size?
Heiko Tietze committed a patch related to this issue.
It has been pushed to "master":
Resolves tdf#134802 - Improved "Paste Special" dialog box
It will be available in 7.2.0.
The patch should be included in the daily builds available at
https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
*** Bug 106852 has been marked as a duplicate of this bug. ***
It's done now. Verified in
Version: 18.104.22.168.alpha0+ / LibreOffice Community
Build ID: 1a99b4e44190e182d56a04678850d62635d74c65
CPU threads: 4; OS: Linux 5.8; UI render: default; VCL: gtk3
Locale: ro-RO (ro_RO.UTF-8); UI: en-US
Added to 7.2 release notes: