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.
Tentative answer : Try menu Tools > Options > LibreOffice Calc > Formula > check "Use English function names" and write your macro with English function names.
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 ?
« ps : isn't it possible to comment an answer on ask.libreoffice.org ? » → FAQ · How does karma system work?
manj_k ( 2012-09-10 23:21:18 +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?)
Thanks.
qubit ( 2013-04-28 02:16:58 +0200 )editLibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-09-10 21:41:12 +0200
Seen: 53 times
Last updated: Sep 10 '12
Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.
