Ask Your Question

Eastersunday() in LibreBasic calc [closed]

asked 2012-09-26 14:49:16 +0100

llam gravatar image

updated 2015-10-18 02:56:42 +0100

Alex Kemp gravatar image

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 "Å".


How should i do?

I'am using Ubuntu 12.04 and LibreOffice

Please help me!

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-10-18 02:57:24.108067

2 Answers

Sort by » oldest newest most voted

answered 2012-09-26 16:10:00 +0100

w_whalley gravatar image

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("")
end function

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

edit flag offensive delete link more

answered 2012-09-30 10:19:05 +0100

llam gravatar image

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

edit flag offensive delete link more

Question Tools


Asked: 2012-09-26 14:49:16 +0100

Seen: 1,148 times

Last updated: Sep 30 '12