newbie: not calculating functions

[Dina Li]

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.

Thanks!

[Administrator]

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.CalculateAll()
     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.