Bug 122783 - copy to clipboard with macro assigned to button no function
Summary: copy to clipboard with macro assigned to button no function
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.1.4.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Clipboard
  Show dependency treegraph
 
Reported: 2019-01-17 12:16 UTC by Mark Butcher
Modified: 2019-12-09 06:27 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Test File (12.47 KB, application/vnd.oasis.opendocument.spreadsheet)
2019-01-17 12:24 UTC, Mark Butcher
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Mark Butcher 2019-01-17 12:16:25 UTC
Description:
I did record a simple macro to mark some cells - insert it to clipboard - select other cell - paste the clipboard there.

I put a button to the sheet and assign the macro to the action execute. 

When I press the button I see that cursor ist moving, but no copy of the clipboard to the no location (error).

When I add the macro to one menue item it works. When I call the macro by menue or I execute it in LibreOffice Basic it works.

Steps to Reproduce:
1.Create new sheet with some data and record a macro to copy some cells and paste it to new location
2.create button on sheet and assign macro to event
3.it will not copy by button but it works to start with menu

Actual Results:
no copy by starting macro with button on sheet

Expected Results:
copy of cells to new location


Reproducible: Always


User Profile Reset: Yes



Additional Info:
I tried different Basic scripts with no chance to work with button
Comment 1 Mark Butcher 2019-01-17 12:24:55 UTC
Created attachment 148395 [details]
Test File

In this test File there are some data and the macro assigned to button. When I press "Button" there is no copy to Target. If I execute it in Basic Editor it will work.
Comment 2 Oliver Brinzing 2019-01-18 15:14:41 UTC
(In reply to Mark Butcher from comment #0)
> When I press the button I see that cursor ist moving, but no copy of the
> clipboard to the no location (error).

pressing the button moves focus to the form control.
so you have to set the buttons propery "Take Focus on click" to "No"