Ask Your Question

Breakpoints ignored in User-defined function [closed]

asked 2013-04-10 15:49:06 +0200

dos286 gravatar image

updated 2020-08-06 20:14:27 +0200

Alex Kemp gravatar image

I'm having trouble debugging a udf. I inserted a breakpoint so that I can watch variables and step through the function. The breakpoint functions as expected if I hit "run Basic" from the LibreOffice Basic window but since it was not called by the spreadsheet, all parameters are empty. If I call the function from a spreadsheet, It returns values (not the ones I expected) but ignores the breakpoint. How can I debug a user-defined function?

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 2016-02-20 07:02:26.500561

1 Answer

Sort by » oldest newest most voted

answered 2014-03-11 23:31:10 +0200

kumiponi gravatar image

I'm not sure if I understood the question correctly, but it seems to me that the natural way would be to write another Basic procedure that would call the desired function with whatever arguments you want to test and Print the output. Then run that procedure from the Basic window.

If you need to use Calc functions in the arguments, it's easiest to first find out the calculated values of the arguments in Calc, and then use those values in the function call in Basic.

edit flag offensive delete link more

Question Tools


Asked: 2013-04-10 15:49:06 +0200

Seen: 313 times

Last updated: Mar 11 '14