Rounding a number down to the nearest integer

[Harv1]

I need to round numbers down to the nearest integer from a macro. The int function does not appear to work and I’m not sure how to call the floor function from a macro. Any suggestions?

[w_whalley]

I think the INT function may work. What may be tripping you up is that arguments to a built-in function call from basic need to be arrays. See this link…

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!

Try this:

function tofloor(num)
svc=createUnoService("com.sun.star.sheet.FunctionAccess")
arg=array(num)
tofloor=svc.callFunction("INT",arg)
end function

You could also call the FLOOR function, but it is more involved.

[Harv1]

Sorry for the post. I just checked and int is working. I usually try everything before posting a question so again I apologize.