Ask Your Question

LO Basic get current row [closed]

asked 2013-11-18 02:27:39 +0200

slink9 gravatar image

updated 2013-11-18 21:32:05 +0200

manj_k gravatar image

I have a VBA macro that works quite well and I thought I would convert it to work in LibreOffice just for the fun of it. The original code took less than four hours of total development time. I have put at least four time that into trying to find out how to determine the current row in LibreOffice. Can someone answer that and point me to accurate documentation of LO Basic with examples?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-14 16:09:55.724110

1 Answer

Sort by » oldest newest most voted

answered 2013-11-18 10:39:11 +0200

newOOo3 gravatar image

updated 2013-11-18 11:45:19 +0200

Hi, slink9 .

Do you want to know how to get the address of current cell with LibreOffice Basic macro ?
If so, yow use getRangeAddress() or getCellAddress() method.
You can see the sample codes the following URL;

[ Explain ]
Current Cell : A10 in Sheet2 ⇔ (0,9) / Sheet No = 1
getRangeAddress() : Current CellのAddress取得(1) ⇔ Get the address of current cell(1)
getCellAddress() : Current CellのAddress取得(2) ⇔ Get the address of current cell(2)

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2013-11-18 02:27:39 +0200

Seen: 2,952 times

Last updated: Nov 18 '13