Ask Your Question
0

functionaccess "offset" & "match"

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

Fede 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 close merge delete

1 Answer

Sort by » oldest newest most voted
2

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

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 +0200 )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 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 214 times

Last updated: Apr 07 '17