Eastersunday() in LibreBasic calc

In a spreedsheetCell the formula EASTERSUNDAY(2012) works when replaced with the Swedish equivalent word for eastersunday => PÅSKDAGEN(2012)

But when i try to use this function i a LibreBasic macro neither works!

In Swedish the error is (i think) the letter “Å”.

EASTERSUNDAY(2012) gives PROCEDURE NOT DEFINED.

How should i do?

I’am using Ubuntu 12.04 and LibreOffice 3.5.4.2

Please help me!

Built in functions in LibreOffice can be called from a basic macro, but the argument to the function needs to be passed as an array. I found that tip here.

Here is a function that calls the built in EASTERSUNDAY function

function esunday(year)
svc = createUnoService("com.sun.star.sheet.FunctionAccess")
arg=array(year)
esunday=svc.callFunction("EASTERSUNDAY",arg)
end function

I can’t speak to any problem with Å, but maybe you can work it out and let us know.

Thank for your answer it works perfectly !

I did a workaround in my macro by placing the formula for eastersunday() in a cell and then read the result, it worked but your solution is better!

Also thanks for your tip-link it will be handy in the future!

Regards
llam