We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

sheet manipulation in added methods

Thread ID:

Created:

Updated:

Platform:

Replies:

41851 Mar 13,2006 09:01 PM UTC Mar 15,2006 04:36 AM UTC WinForms 1
loading
Tags: Calculate
Brian J. Burnett
Asked On March 13, 2006 09:01 PM UTC

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)?

Administrator [Syncfusion]
Replied On 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.

CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;