functionaccess "offset" & "match" [closed]

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

Fede
69 ●18 ●24 ●31

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

Alex Kemp

flag of United Kingdom of Great Britain and Northern Ireland

20317 ●18 ●59 ●59 http://etmg.altervista...

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

add a comment

1 Answer

Sort by » oldest newest most voted

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

karolus

5534 ●17 ●40

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

edit flag offensive delete link

Comments

Thank you Karolus :)

Fede ( 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 ( 2017-04-10 16:41:09 +0100 )edit

add a comment

Question Tools

1 follower

Stats

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

Seen: 363 times

Last updated: Apr 07 '17

functionaccess "offset" & "match" [closed] edit

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