The Syncfusion native Blazor components library offers 70+ UI and Data Viz web controls that are responsive and lightweight for building modern web apps.
.NET PDF framework is a high-performance and comprehensive library used to create, read, merge, split, secure, edit, view, and review PDF files in C#/VB.NET.
I want to write an “added method” which implements a particular optimisation algorithm and have a couple of questions.
The basic idea is that the algorithm puts values into specific cells of the sheet and reads back the “result”. By varying the values the algorithm proceeds, after a number of iterations, to determine which combination of values minimise the value in the result cell.
How do I find which sheet the calculation engine is processing when it calls my added method (so that I can determine where to put the input values)?
Also, how do I get the workbook (or preferably only the dependencies between the cells into which I write the values and the result cell) to re-calculate within my added method (which remember is being called as part of a recalculate of the workbook already)?
ADAdministrator Syncfusion Team March 15, 2006 04:36 AM UTC
Hi Brian,
I apologize for the delay in replaying.Please refer this sample C:\Program Files\Syncfusion\Essential Studio\4.1.0.x\windows\Calculate.Windows\Samples\TabbedPanelGrids\vb. Let me know if it helps.
Thanks for choosing and using Syncfusion Products.
Best Regards,
Jeba.