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