Setting an input cursor Calc

Creating a macro - Writing a Script - Using the API (OpenOffice Basic, Python, BeanShell, JavaScript)
Post Reply
cyrano1960
Posts: 2
Joined: Sat Mar 31, 2018 11:02 am

Setting an input cursor Calc

Post by cyrano1960 »

Hello, I am working with C# and UNO API and I am searching for a way to set the input cursor to a specific cell. Using:

Code: Select all

sheet.getCellByPosition(15,13).setValue(222);
cursor.getCellByPosition(15, 15);
works only for programmatic inputs. The program searches for a specific "id value" in the calc file and then it hat to be activated so that the user can do some inputs there.

Does anybody has an idea?

Thanks in advanve!
OpenOffice 4.x, Windows 10
User avatar
Zizi64
Volunteer
Posts: 11353
Joined: Wed May 26, 2010 7:55 am
Location: Budapest, Hungary

Re: Setting an input cursor Calc

Post by Zizi64 »

works only for programmatic inputs. The program searches for a specific "id value" in the calc file and then it hat to be activated so that the user can do some inputs there.
tips:
- You can activate the desired cell, and - after ending the macro routine - you can fill/edit the cell manually.
http://140.211.11.67/en/forum/viewtopic ... 20&t=91883
viewtopic.php?f=20&t=38480

- Or you can use the InputBox() function to get user input during the macro running. And then you can put the string/value into the desired (but non-activated) cell by the routine.
https://wiki.openoffice.org/wiki/Docume ... e_Library)
viewtopic.php?f=20&t=22372&p=101975
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Post Reply