Ask Your Question

does LibreCalc support getCell functions

asked 2017-06-16 22:43:25 +0200

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

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 returns: BASIC runtime error. Sub-procedure or function procedure not defined.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-06-17 00:07:38 +0200

Lupp gravatar image

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.)

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-06-16 22:43:25 +0200

Seen: 269 times

Last updated: Jun 17 '17