[Solved] Calc Equivalent Function to Excel Application.InputBox

Creating a macro - Writing a Script - Using the API (OpenOffice Basic, Python, BeanShell, JavaScript)
Post Reply
LOn00bie
Posts: 4
Joined: Fri Jan 06, 2023 2:48 pm

[Solved] Calc Equivalent Function to Excel Application.InputBox

Post by LOn00bie »

Hello,

I have the same question on the topic below "LibreCalc Equivalent Function to Excel Application.InputBox"
https://stackoverflow.com/questions/433 ... n-inputbox

"In MSExcel, the Application.InputBox function with type=8 would result in an input box appearing, and which would allow the user to enter a range of cells into the input box. With the usual Basic InputBox function, cell ranges can not be input."

How can I emulate similar functionality in OpenOffice/LibreOffice using the mouse and events (https://wiki.openoffice.org/wiki/Docume ... ide/Events) ?!

Thanks!
Last edited by Hagar Delest on Tue Feb 21, 2023 2:24 pm, edited 1 time in total.
Reason: tagged solved.
LibreOffice 7.2 & Windows 10
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Calc Equivalent Function to Excel Application.InputBox

Post by Villeroy »

Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
LOn00bie
Posts: 4
Joined: Fri Jan 06, 2023 2:48 pm

Re: Calc Equivalent Function to Excel Application.InputBox

Post by LOn00bie »

Villeroy wrote: Fri Jan 06, 2023 10:22 pm viewtopic.php?p=532222#p532222
Hello,

thanks :super: , your example helped a lot!
LibreOffice 7.2 & Windows 10
Post Reply