First time here? Check out the FAQ!
asked 2012-09-10 21:41:12 +0200sulliwane
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.
answered 2012-09-10 22:02:12 +0200Jean-Baptiste FAURE
Tentative answer : Try menu Tools > Options > LibreOffice Calc > Formula > check "Use English function names" and write your macro with English function names.
answered 2012-09-10 22:26:24 +0200sulliwane
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 ?
LibreOffice 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