Functionaccess "offset" & "match"

[Fede1]

Hi!

I would like to use the function “OFFSET” and “MATCH” in libreoffice macro,
I had found this topic, but it is not clear:

Using Calc built in functions in macros (View topic) • Apache OpenOffice Community Forum

Can You help me?

Thank you in advanced

Have a Nice Day!

Fede

LO: 5.2.6 e 5.3.1
SO: Win 7 - 10

[karolus]

No, you don’t need offset, because the native API-Methods …getCellByPosition( … , … ) and …getCellRangeByPosition( … , … , … , … ) exists!!

[Fede1]

Thank you Karolus

[Fede1]

Hello @Karolus!
Is it possible determinate the position of a number in a range data
with starbasic in libreoffice calc?

Thank you

Fede