Is there a way to initiate the step calculation (F11) at a specific place in the worksheet?

When ever I try to use it, it always goes to the begining.

Is there a way to go backwards a step or two?

I am trying to debug a for-next loop and it takes a LONG time to get to the place I need to be doing it step at a time.

Is there a doc or page that describes this sort of thing? I have not been able to find anything yet.

Thanks in advance
Dennis

Wrote

Is there a way to initiate the step calculation (F11) at a specific place in the worksheet?

When ever I try to use it, it always goes to the begining.

Once the document is working, you can set "Auto-calc".
That may have no effect for debugging a for loop.
If you want to calculate sin(30) at the end of a greedy work sheet,
and "Auto-calc" ON, it will just calculate sin(45)=

You can attach your document for doctoring

Jean

As for now I think the only way it's to insert a dummy operation in the point you want the debug starts (f.e. you can define test:1 and everything will be recalculated from that point onwards)

Wrote

As for now I think the only way it's to insert a dummy operation in the point you want the debug starts (f.e. you can define test:1 and everything will be recalculated from that point onwards)

More simply: copy/paste on new page what belongs to debugging,
or disable all stuff that does not belong to debugging.
Modular programs are easier to debug piece wise.

Wrote

As for now I think the only way it's to insert a dummy operation in the point
you want the debug starts (f.e. you can define test:1 and everything will be recalculated from that
point onwards)

Davide-

I am trying to understand how to do this. Here are some screens- there are a bunch of linked pages.
Even though we are a bit of a 'family' here and we freely share things, one of the pages uses data and
equations from an ANSI/model code that I am not supposed to redistribute so I don't want to toe that line.
There are some of those proprietary equations in here too, but I will try to move them out later.
But MY top level page is attached.

I want to inspect the sections/lines below the arrows I inserted.

As I understand it, in order to get there, I have to step-wise evaluate to that point. When I want to make
an edit, I have to interrupt the processing and restart it from the beginning. In this case, the processing
jumps around a LOT because of the way i set it all up.

If I put test:1 in there, I am not sure how to jump to that point. I use the Step Into (F11) button and the
Continue button to get to where I want to get to.

Whole page-
Wind Loads-COC.sm (121 КиБ) скачан 102 раз(а).

Screen at a time-

Step 1 is to evaluate the whole worksheet

Step 2 is to set the breakpoint

Step 3 is to trigger the evaluation of the block, by defining something before that block


Once you find something wrong, edit it and set the breakpoint, then define again something before the block


(and repeat... anything above the yellow variables is kept from the first evaluation)