FunctionAccess seems to be language localized

[sulliwane]

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

oFA = createUnoService( "com.sun.star.sheet.FunctionAccess" )
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 users…it does not seem to be the case.

Any ideas ?

Thank you a lot.

[Jean-BaptisteFAURE]

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

[sulliwane]

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 user…so the best would be no options checkbox to check :o)

ps : isn’t it possible to comment an answer on ask.libreoffice.org ?

[manj_k]

« ps : isn’t it possible to comment an answer on ask.libreoffice.org ? »
→ FAQ · How does karma system work?

[sulliwane]

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!

[qubit1]

@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?)

Thanks.