Create floating button to add values to cells in Calc

Creating a macro - Writing a Script - Using the API (OpenOffice Basic, Python, BeanShell, JavaScript)
M.Teich
Posts: 9
Joined: Thu Sep 02, 2021 8:13 am

Re: Create floating button to add values to cells in Calc

Post by M.Teich »

@JohnSUN-Pensioner: changing the control size worked fine for me, thanks!
LibreOffice 7.1.2.2 in Windows 10
M.Teich
Posts: 9
Joined: Thu Sep 02, 2021 8:13 am

Re: Create floating button to add values to cells in Calc

Post by M.Teich »

@JohnSUN-Pensioner: I'm having difficulties applying, i.e. copying the macro to multiple sheets in the same calc-file. I got it to work initially, but it seemed rather complicated and I can't replicate it anymore. I thought that if the formatting was the same then the macro would automatically apply, but that doesn't seem to be the case. I can't assign the macro, because there are no objects to assign it to. Any suggestions what to do?
LibreOffice 7.1.2.2 in Windows 10
User avatar
JohnSUN-Pensioner
Volunteer
Posts: 876
Joined: Fri Jan 14, 2011 1:21 pm
Location: Kyiv, Ukraine

Re: Create floating button to add values to cells in Calc

Post by JohnSUN-Pensioner »

M.Teich wrote:I can't assign the macro, because there are no objects to assign it to. Any suggestions what to do?
Event Calc Sheet.png
I may not have a lot to give but what I got I'll give to you...
Apache OpenOffice 4.1.5, LibreOffice 6.4.4.2 (x64) on Windows 7
If you think that I did not answer your question, make allowances for my imperfect English
Post Reply