Description: When I try to paste only values and, at the same time, transposed, the latter has no effect (ie the cells are pasted, value only but not transposed). Steps to Reproduce: 1. Populate some cells in the 1st row, apply some formatting (e.g. bold) 2. Copy the entire row 3. Now I want to copy those rows but A) as a column and B) without formatting 4. Thus, I press CTRL+SHIFT+V to get the 'paste special' dialog 5. Enable 'Transpose' and click on 'Values only' Actual Results: The contents of the row are pasted in as a ROW, without formatting. Thus, the 'value only' option worked, but the 'transpose' did not. Expected Results: The program should respect the options it offered in the dialog: if you enable 'Transpose' and then click 'Values only' button, then BOTH things should be executed. Therefore, the expected result is the list of cells but in a column, and also unformatted. Reproducible: Always User Profile Reset: Yes Additional Info: Version: 24.2.2.2 (X86_64) / LibreOffice Community Build ID: 420(Build:2) CPU threads: 24; OS: Linux 6.5; UI render: default; VCL: qt5 (cairo+xcb) Locale: en-US (en_US.UTF-8); UI: en-US Ubuntu package version: 4:24.2.2~rc2-0ubuntu0.22.04.1~lo1 Calc: CL threaded
Created attachment 193702 [details] screencast of the sequence
The thing about this dialog is that "Values Only" is a preset of choices that do not include the "Transpose" option. The correct workflow in the dialog would be: 1) Uncheck "Run immediately" 2) Click "Values only" 3) Select the "Transpose" option 4) Click OK This will get the results that you want.
I suppose presets at left of the dialog don't take into account the rest of the checkboxes. If you just check "Transpose", it will work since by default "Formats" isn't checked.
Thanks, Rafael and Julien. I see that I was misunderstanding (or should I say, I never took the time to 'study' it). Now I understand this is the way it is intended and it makes sense. In a way, the "Run immediately" activated by default makes it a bit hard to see that the buttons are presets that change the activation boxes. But I also completely understand why the "Run immediately is there" (actually makes the process much easier). A part of me thinks that, if the UI needs too much thinking, then there's probably room to improve it. But I also like it very much that this paste dialog is super complete and flexible to do almost whatever you want when pasting. I completely understand why it is like this and I honestly can not think of a good way to make it better. Thus I conclude that It is probably fine the way it is (or in other words, I am not able to contribute to any good idea right now), and now I just learned how to do it right next time. I'm closing this one. Thanks again.