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
the content in a1 is formula, the content in b1 is a number
the content in both cells should be a formula
User Profile Reset: No
Created attachment 147754 [details]
Screenshot - data in Test1
Created attachment 147755 [details]
screenshot - insert dialog
Created attachment 147756 [details]
screenshot - insert result cell a1 - ok
Created attachment 147757 [details]
screenshot - insert result cell b1 - failed
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
I see that the content in both the cells are formulas
not reproducible with
Version: 126.96.36.199 (x64)
CPU-Threads: 4; BS: Windows 10.0; UI-Render: Standard;
Gebietsschema: de-DE (de_DE); Calc:
don't repro in
Версия: 188.8.131.52 (x64)
ID сборки: 0412ee99e862f384c1106d0841a950c4cfaa9df1
Потоков ЦП: 4; ОС:Windows 10.0; Отрисовка ИП: GL; VCL: win;
Локаль: ru-RU (ru_RU); UI-Language: ru-RU
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.
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?
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)
I'll confirm as Enhancement for Comment 9 and change the title.
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.