Bug Hunting Session
Bug 122265 - If Link option is selected in Paste Special window "OK" button should be in focus for repeated paste to another file, not first button "Values only" - comment 9
Summary: If Link option is selected in Paste Special window "OK" button should be in f...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: low enhancement
Assignee: Not Assigned
Keywords: easyHack, implementationError
Depends on:
Blocks: Paste
  Show dependency treegraph
Reported: 2018-12-21 14:56 UTC by rtaube
Modified: 2019-01-09 03:43 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Screenshot - data in Test1 (19.66 KB, image/jpeg)
2018-12-21 14:56 UTC, rtaube
screenshot - insert dialog (36.25 KB, image/jpeg)
2018-12-21 14:57 UTC, rtaube
screenshot - insert result cell a1 - ok (46.60 KB, image/jpeg)
2018-12-21 14:57 UTC, rtaube
screenshot - insert result cell b1 - failed (27.33 KB, image/jpeg)
2018-12-21 14:58 UTC, rtaube
screenshot - insert dialog is opened again (34.73 KB, image/jpeg)
2019-01-02 16:18 UTC, rtaube

Note You need to log in before you can comment on or make changes to this bug.
Description rtaube 2018-12-21 14:56:09 UTC
The insert function works only once

Steps to Reproduce:
1. create new file (test1) and add a number in a1 and b1
2. create another new file (test2)
3. select cell a1 in test1 and copy (Ctrl-C)
4. in test2, selct a1, use "ins" shortcut ("Inhalte einfügen" in German) and select link ("Verknüpfen" in German)
5. repeat 3. and 4. for cell b1
see attached screenshots

Actual Results:
the content in a1 is formula, the content in b1 is a number

Expected Results:
the content in both cells should be a formula

Reproducible: Always

User Profile Reset: No

Additional Info:
Comment 1 rtaube 2018-12-21 14:56:51 UTC
Created attachment 147754 [details]
Screenshot - data in Test1
Comment 2 rtaube 2018-12-21 14:57:20 UTC
Created attachment 147755 [details]
screenshot - insert dialog
Comment 3 rtaube 2018-12-21 14:57:51 UTC
Created attachment 147756 [details]
screenshot - insert result cell a1 - ok
Comment 4 rtaube 2018-12-21 14:58:27 UTC
Created attachment 147757 [details]
screenshot - insert result cell b1 - failed
Comment 5 Durgapriyanka 2018-12-21 16:10:45 UTC
Thank you for reporting the bug. I can not reproduce the bug in

Build ID: 3c964980da07892a02d5ac721d80558c459532d0
CPU threads: 2; OS: Windows 6.1; UI render: default; VCL: win; 
TinderBox: Win-x86@42, Branch:master, Time: 2018-12-12_02:07:45
Locale: en-US (en_US); UI-Language: en-US
Calc: threaded

I see that the content in both the cells are formulas
Comment 6 Oliver Brinzing 2018-12-21 17:13:54 UTC
not reproducible with

Version: (x64)
Build-ID: 9d0f32d1f0b509096fd65e0d4bec26ddd1938fd3
CPU-Threads: 4; BS: Windows 10.0; UI-Render: Standard; 
Gebietsschema: de-DE (de_DE); Calc:
Comment 7 Roman Kuznetsov 2018-12-22 19:54:24 UTC
don't repro in

Версия: (x64)
ID сборки: 0412ee99e862f384c1106d0841a950c4cfaa9df1
Потоков ЦП: 4; ОС:Windows 10.0; Отрисовка ИП: GL; VCL: win; 
Локаль: ru-RU (ru_RU); UI-Language: ru-RU
Calc: threaded
Comment 8 Timur 2018-12-24 16:17:34 UTC
Sorry for not testing. But if 3 testers couldn't reproduce, please find specifics when exactly this happens (clipboard?). And then set back to Unconfirmed.
Comment 9 rtaube 2019-01-02 16:15:36 UTC
ok, you're right. It works. But not for me.
After some testing, the new error report is:
- if the insert dialog opens first, the first checkbox (insert all "Alles einfügen") has the focus.
- I select link ("Verknüpfen")
- when the dialogs appears again, the first button (see screenshot) has the focus. I usually use shortcuts and that's why I press Enter and hope the "OK" button is the default one. Unfortunately the "Nur Werte" (only values) button has the focus
Could you change the focus handling please?
Comment 10 rtaube 2019-01-02 16:18:26 UTC
Created attachment 147946 [details]
screenshot - insert dialog is opened again

Screenshot for default button in insert dialog after it opens for second time (the first time the checkbox left bottom was selected)
Comment 11 Timur 2019-01-08 12:14:19 UTC
I'll confirm as Enhancement for Comment 9 and change the title.
Comment 12 Timur 2019-01-08 12:40:52 UTC
Since new Paste Special dialog. Repro 4.4 and 6.3+. 
Note: if this seems to work in the same file, test Paste Special to another file.