Didn't the "Values Only" preset used to be selected in Paste Special in Calc?

[drghughes]

I’m sure that the Paste Special window in Calc used to have the Values Only preset selected when it opened. This meant that you could easily use the cursor to select the other presets.

But for a few versions now, none of the presets have been selected, and instead the All option is selected, i.e.

Is this change by design, or is it a bug?

This is with:

Version: 24.2.3.2 (X86_64) / LibreOffice Community
Build ID: 433d9c2ded56988e8a90e6b2e771ee4e6a5ab2ba
CPU threads: 12; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: en-AU (en_AU); UI: en-GB
Calc: CL threaded

with Paste Special selected by Ctrl+Shift+V, copying a cell in Calc.

Thanks for any help!

[PKG]

@drghughes

I’m sure that the Paste Special window in Calc used to have the Values Only preset selected when it opened.

No.

_{Version: 5.4.7.2
Build ID: c838ef25c16710f8838b1faec480ebba495259d0
CPU threads: 8; OS: Windows 6.2; UI render: default;
Locale: en-CA (de_DE); Calc: CL}

[LeroyG]

@drghughes

Values Only

Try Ctrl+Alt+Shift+V.

[cwolan]

@drghughes

But for a few versions now, none of the presets have been selected, and instead the All option is selected, i.e.

I see a change starting with version 24.2 (on Windows 11).
⠀

⠀
Info:

(1)
Version: 7.6.7.2 (X86_64) / LibreOffice Community
Build ID: dd47e4b30cb7dab30588d6c79c651f218165e3c5
CPU threads: 8; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win
Locale: en-US (pl_PL); UI: en-US
Calc: threaded

(2)
Version: 24.2.3.2 (X86_64) / LibreOffice Community
Build ID: 433d9c2ded56988e8a90e6b2e771ee4e6a5ab2ba
CPU threads: 8; OS: Windows 10.0 Build 22631; UI render: Skia/Raster; VCL: win
Locale: en-US (pl_PL); UI: en-US
Calc: threaded

[cwolan]

Looks like the culprit is tdf#157891
(“Initial focus of Paste Special dialog is inconvenient (win and gen VCL)”)

[erAck]

Which is an actual fix of the problem that Values Only got preselected.

[cwolan]

Indeed.
I should have put the word culprit in quotes.
⠀

[LeroyG]

Here, As Link is in focus.

Version: 7.6.2.1 (X86_64) / LibreOffice Community
Build ID: 60(Build:1)
CPU threads: 4; OS: Linux 5.14; UI render: default; VCL: gtk3
Locale: es-MX (en_US.UTF-8); UI: en-US
Calc: threaded

[mikekaganski]

@LeroyG

Here, As Link is in focus

@caolan has explained it in the commit:

… vcl picks the “value” button and gtk picks the “link” checkbox

[drghughes]

Thanks for all your answers, especially @cwolan for showing the request for the change.

Seems to me that this has made Paste Special less usable, especially since you can’t use the cursor keys to move between the different sections of the window, just up and down each section. Is there any reason for restricting the way that the window works by making each section “independent”??

Is there any point in me asking for a change, or is this something that I’ve just got to live with?

[mikekaganski]

@drghughes

you can’t use the cursor keys to move between the different sections of the window

But Tab (and Shift+Tab ) works fine, as usual.

[erAck]

@drghughes

Seems to me that this has made Paste Special less usable

Only for you maybe… because as explained in the bug linked, having Values Only preselected and hitting Enter executed the Values Only instead of the activated options on OK. Bear in mind that the dialog remembers the last set options, so the result may absolutely not had been what one expected.

@drghughes

Is there any reason for restricting the way that the window works by making each section “independent”?

Don’t know, apparently it works that way only on Windows, on Linux with a native gtk3 environment one can travel even with cursor left/right keys from column to column.

@drghughes

Is there any point in me asking for a change

Not for another selection default, maybe for the cursor travel.

@drghughes

or is this something that I’ve just got to live with?

Switch to Linux