Ask Your Question
0

functionaccess "offset" & "match" [closed]

asked 2017-04-07 08:42:54 +0100

Fede gravatar image

updated 2020-09-29 13:18:14 +0100

Alex Kemp gravatar image

Hi!

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

https://forum.openoffice.org/en/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

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 2020-09-29 13:18:38.957785

1 Answer

Sort by » oldest newest most voted
2

answered 2017-04-07 11:15:13 +0100

karolus gravatar image

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

edit flag offensive delete link more

Comments

Thank you Karolus :)

Fede gravatar imageFede ( 2017-04-07 11:36:13 +0100 )edit

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

Thank you

Fede

Fede gravatar imageFede ( 2017-04-10 16:41:09 +0100 )edit

Question Tools

1 follower

Stats

Asked: 2017-04-07 08:42:54 +0100

Seen: 369 times

Last updated: Apr 07 '17