See source line number in the output

[Proektsoftbg]

I know there was a suggestion to find the respective source line in the code if you click on a line in the output.
However, we have not managed to implement this so far. Now I have a really long worksheet and I am lost in it. So, I found a quick solution at least to see the source line number:

1. Add the following line at the bottom of your worksheet:
   '<script>$(":header,p,tr,img").each(function() {$(this).attr("title", $(this).attr("id"));});</script>
2. Re-calculate the worksheet.
3. Hover the mouse over a line in the output.
4. You will see a tooltip showing the line number in the source code. You can just scroll to it.

If you need this, you can use it until we make something better.
Another thing that can be useful is: If there are errors in the output, to display a non-scrolling summary on the top in red color with links for each error.

[snoozy2323]

I just wrote a request to that topic, but I think you have that already in mind.

Anyway, the script is super helpful!

[Proektsoftbg]

OK, thank you! No problem. I will try to do someting better about it now and will post later.

[Proektsoftbg]

OK. I think I managed to make something decent that will help developing larger worksheets.

1. Link to the source line in the output. If you hover a line in the output a small arrow appears on the left. If you click it, it finds the source line in the code. The nomber of the line is added as a tooltip to the arrow. If you have macros or modules, the arrow takes you first to the unwarped code and then, if you click the unwarped code line number, you go to the source code.

2. Summary of errors. If there are any errors in a worksheet, longer than 30 lines ( a little more than one page), a red header is displayed on top with links to the lines with errors in the output. It is fixed and does not move while scrolling. Otherwise, in longer worksheets, you will have to scroll a lot to find if there are any errors and where they are.

I have not publihed it officially, because I am still not sure that everything is working fine. For now, you can download the new version 6.1.5 from this link and try it:

https://github.com/Proektsoftbg/Calcpad/blob/main/Setup/calcpad-setup-en-x64.exe

I will also play a few days with it to see if everything is OK.

[jgagnonNT]

I was looking forward to that feature! It seems to work well, thank you!