Ask Your Question

FunctionAccess seems to be language localized [closed]

asked 2012-09-10 21:41:12 +0200

sulliwane gravatar image

updated 2014-03-19 22:21:31 +0200

manj_k gravatar image

I coded a macro in calc using the french equivalent FunctionAccess of "EOMONTH", which is :

oFA = createUnoService( "" )
vEndOfMonth = oFA.callFunction("FIN.MOIS",Array(sCDate,0))

My problem is that If I send my macro to someone who's set calc language to whatever language other than french, my macro won't work ! it's annoying, and I thought that the english name of FunctionAccess would work for any does not seem to be the case.

Any ideas ?

Thank you a lot.

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-10-18 01:54:29.032138

2 Answers

Sort by » oldest newest most voted

answered 2012-09-10 22:02:12 +0200

Jean-Baptiste FAURE gravatar image

Tentative answer : Try menu Tools > Options > LibreOffice Calc > Formula > check "Use English function names" and write your macro with English function names.

edit flag offensive delete link more

answered 2012-09-10 22:26:24 +0200

sulliwane gravatar image

Thank you for your anwser, but it didn't work for me. I checked the option, but still only FIN.MOIS works if my language is set to french. Is it the case for you ?

Moreover, I wish to find a hassle free solution for the end the best would be no options checkbox to check :o)

ps : isn't it possible to comment an answer on ?

edit flag offensive delete link more


« ps : isn't it possible to comment an answer on ? »FAQ · How does karma system work?

manj_k gravatar imagemanj_k ( 2012-09-10 23:21:18 +0200 )edit

okay, thanks! ...Despite the fact that there is no "karma" bridge between ask.ubuntu (or stackoverflow network) and ask.libreoffice, it has the credit to be totally run by an opensource engine which is great!

sulliwane gravatar imagesulliwane ( 2012-09-11 18:41:19 +0200 )edit

@sulliwane -- Still looking for an answer here?

I think that J-B Faure's suggestion works for technical reasons, but if you want to use "FIN.MOIS" itself, you'll need to do something different (perhaps file an Enhancement Bug for that?)


qubit gravatar imagequbit ( 2013-04-28 02:16:58 +0200 )edit

Question Tools

1 follower


Asked: 2012-09-10 21:41:12 +0200

Seen: 371 times

Last updated: Sep 10 '12