Apache OpenOffice (AOO) Bugzilla – Issue 92528
Localization of Addin function ERFC is broken
Last modified: 2008-09-30 15:42:15 UTC
Try to access the ERFC-function with a macro, for example function MYERFC (byval z) as double DIM oFunktion as variant oFunktion = createUnoService("com.sun.star.sheet.FunctionAccess") Dim aArgumente(0) As Variant dim erfcresult as double aArgumente(0)=z erfcresult = oFunktion.callFunction( "ERFC", aArgumente() ) MYERFC=erfcresult end function This works fine in an English UI. Now open the same document in a German UI. You will get an error "comm.sun.star.container.NoSuchElementException". For the normal functions is works as expected, that the function in the statement is always English. For the Addin function 'Erfc' the statement needs the localized name. I consider this a bug, because the behavior is different and it makes it impossible to distribute such macros.
Created attachment 55607 [details] macro with German and English functions name
Andreas, please take care of this ... Thanks Kay
This is no scripting problem. Basic only catches an Excepting thrown by the callFunction method of service "css.sheet.FunctionAccess" Component scripting -> Spreadsheet ab->er: Please have a look
Duplicate. *** This issue has been marked as a duplicate of 92530 ***
Closing dup.