OOo and LO nominally supported functions such as getCellByPosition() or getCellRangeByName(), but these macro functions are not listed in the Help documentation as far as I can discover. Are they still supported? Is there a way to transfer a value from within a spreadsheet into a macro variable? when I use GetCellByPosition():
z = getCellByPosition(1,0)
LibreOffice 5.1.6.2 returns: BASIC runtime error. Sub-procedure or function procedure not defined.
See my comments answering your comments to my answer in the thread:
Try reading the LibreOffice (or OpenOffice) BASIC Programmer’s Guide first and in specific the chapters therein referring to the api. I also recommended already the very valuable documents by Andrew Pitonyak.
Withou some fundamental studies you may ask 1000 questions without getting anywhere.
(I would suggest you no longer do wiki posts. It doesn’t actually supply valuable means.)