What's the right method to write a formula to Excel, being Excel the ActiveX server?

[adrian629]

I can write any data to Excel and modify the properties of the worksheet. However,every time I try to assign a cell a simple function as:
=AVERAGE(A1:A20)
the Excel worksheet shows the error message "#NAME?" in that cell, meanning it doesn't recognize the function. However, when I manually select the function (F2) for editing and press ENTER, Excel exceutes it. I'm using the ExcelRangeSetItem function to assign values to a cell.

[jbao@via-telecom.com]

I think you can use ExcelRpt_SetCellRangeAttribute(), a function in ExcelReport driver. The fp file for the drive is in dirctory "\MeasuresurementStudio\cvi\samples\activex\excel" if you cvi version is 6.0. Using this function, you can set a lot of properties for a cell or a range of cell(cellrange). Good luck.