Bug 101958 - "Find" toolbar field won't accept pasted text from the clipboard other than unformatted text after keyboard switch
Summary: "Find" toolbar field won't accept pasted text from the clipboard other than u...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All macOS (All)
: low trivial
Assignee: Not Assigned
Depends on:
Blocks: Find-Toolbar
  Show dependency treegraph
Reported: 2016-09-07 11:43 UTC by CTAC
Modified: 2023-12-29 16:25 UTC (History)
0 users

See Also:
Crash report or crash signature:

Shows text with formatting to be copied in clipboard (311.28 KB, image/png)
2016-09-07 14:45 UTC, CTAC

Note You need to log in before you can comment on or make changes to this bug.
Description CTAC 2016-09-07 11:43:57 UTC
Within libreoffice Calc under MacOSX, if you cut to the buffer something with formatting somewhere in 3rd party app and try to find this <Cmd+F> in Calc, it will start "import" instead of paste to find field without formating
Comment 1 Alex Thurgood 2016-09-07 12:18:19 UTC
I think that this is probably a known issue, with regard to the Find window not receiving the focus, let me check.
Comment 2 Alex Thurgood 2016-09-07 12:46:21 UTC
CTAC : Can you provide step by step detailed instructions so that I can try and reproduce ?

Setting to NEEDINFO, please set back to UNCONFIRMED once you have provided the requested information
Comment 3 Alex Thurgood 2016-09-07 12:57:24 UTC
No repro for me with 

Build ID: 066b007f5ebcc236395c7d282ba488bca6720265
CPU Threads: 2; OS Version: Mac OS X 10.11.6; UI Render: default; 
Locale: en-GB (fr.UTF-8)

If I select some text from a web page that has bold/italic formatting, and then drag and drop paste that into the Cmd-F window, the text is selected into the search field.

Please try with an updated version of LibreOffice (5.2.0) and report back. If what I've described is not what you are doing, please be more specific.
Comment 4 CTAC 2016-09-07 14:45:01 UTC
Created attachment 127197 [details]
Shows text with formatting to be copied in clipboard
Comment 5 CTAC 2016-09-07 14:46:15 UTC
Probably it is some duplicate of "find lost focus"
Steps to reproduce:
under MacOSX+russian language installed
1. Install Libreoffice
2. Install Russian Language pack LibreOffice_5.2.1_MacOS_x86-64_langpack_ru.dmg
3. open https://bugs.documentfoundation.org/show_bug.cgi?id=101958
and select some text crossing some fields (shown in attachement)
4. Copy it to the clipboards: Cmd+C
4. Start new spreadsheet in LibreOffice calc
5. Press <Cmd+F> to start "Find"
6. Press <Cmd+V> - everything is fine
7. press ESC to close find
8. switch to russian keyboard (usually - <Cmd+Space>)
9. Press <Cmd+F> to start "Find"
10. Press <Cmd+V> - PROFIT!
Comment 6 Alex Thurgood 2016-09-07 16:21:17 UTC
@CTAC : thanks for the detailed explanation, with your help I was able to reproduce the problem.

1) Open a new Calc document

2) Copy some text from a browser

3) Cmd-F to open the Find dialog

4) Cmd-V to paste the copied text - the text is inserted into the Find dialog

5) Press the Esc key to quit the Find window

6) Switch to a different keyboard in the OSX system toolbar - it doesn't seem to matter which input you choose, I chose Arabic AZERTY keyboard and reproduced the problem.

7) Now re-open the Find toolbar in Calc with Cmd-F

8) Try to Cmd-V paste the text in the clipboard back into the Find dialog

9) LO thinks that the user wants to import an outside data source and starts the corresponding wizard.
Comment 7 Alex Thurgood 2016-09-07 16:24:06 UTC
Confirmed in 

Build ID: f99d75f39f1c57ebdd7ffc5f42867c12031db97a
Threads CPU : 8; Version de l'OS :Mac OS X 10.11.6; UI Render : par défaut; 
Locale : fr-FR (fr.UTF-8)
Comment 8 eisa01 2018-03-29 20:41:49 UTC
Still present. This find toolbar is new since 3.3

Build ID: a488c7ad2763b944713997911c1ddb0315d8c93f
CPU threads: 2; OS: Mac OS X 10.12.6; UI render: default; 
TinderBox: MacOSX-x86_64@49-TDF, Branch:master, Time: 2018-03-26_00:38:29
Locale: en-US (en_US.UTF-8); Calc: group
Comment 9 QA Administrators 2019-03-30 06:12:33 UTC Comment hidden (obsolete)
Comment 10 eisa01 2019-04-20 17:52:48 UTC
Still present, however on step 9 it now pastes into the selected cell instead

Build ID: ea9c13be02ba731074fa4207944ff7df40a0fb5c
CPU threads: 2; OS: Mac OS X 10.13.6; UI render: default; VCL: osx; 
TinderBox: MacOSX-x86_64@49-TDF, Branch:master, Time: 2019-04-10_20:43:17
Locale: en-US (en_US.UTF-8); UI-Language: en-US
Calc: threaded
Comment 11 QA Administrators 2021-04-20 03:54:11 UTC Comment hidden (obsolete)
Comment 12 eisa01 2021-12-25 22:28:43 UTC
Still present

Interestingly it pops up a text import options dialog box

Version: / LibreOffice Community
Build ID: 9bfc42015acd6ae3475ab7927ccc006507cc38a2
CPU threads: 4; OS: Mac OS X 10.14.6; UI render: Skia/Raster; VCL: osx
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
Comment 13 QA Administrators 2023-12-26 03:09:12 UTC Comment hidden (obsolete)
Comment 14 eisa01 2023-12-29 16:25:01 UTC
This is still present following comment #6, but using the new "Globe" key on the keyboard to switch keyboard layout

Would be quite hard to hit this in practice, so reducing importance

Version: (AARCH64) / LibreOffice Community
Build ID: 5f390384195b7264c6e52add9e90a39790285249
CPU threads: 10; OS: macOS 14.2; UI render: Skia/Metal; VCL: osx
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded