i created an excel workbook with 3 spreadsheets (inputs, calculate, outputs). There''s only one calculation - the sum of three inputs. I copied and pasted the sample code for the ExcelRWCalcWorkbook into my vb.net solution. I created a simple windows form GUI. I can see the values entered into the GUI being read into the spreadsheet correctly, but the calculations are not running, I''m not getting a calculated result. If I put in default values, the returned result is just the default total. Any ideas as to why the calculations are not being performed? There are no intermediate calcs.
ADAdministrator Syncfusion Team December 10, 2004 03:00 AM
Our CarIns sample attempts more or less the same thing. Does that sample work for you?
Here is the main code from that sample.
Private calcWB As ExceRWCalcWorkbook
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs)
calcWB = ExceRWCalcWorkbook.CreateFromXLS("..\..\CarIns.xls")
Me.calcWB.Engine.lockDependencies = False
Me.calcWB.Engine.lockDependencies = True
End Sub ''Form1_Load
Once this is done, that sample retrieves a computed value after changing inputs by indexing the sheet, calcWB("Outputs")(1, 1).
If you can upload a sample showing the problem, or if you open a Direct Trac support incident and upload a sample there. we can try to spot the problem.