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?
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…
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.
Sorry for the post. I just checked and int is working. I usually try everything before posting a question so again I apologize.