I tried thisbriefly and it doesn't work as intended
Infragistics.Excel.Workbook workbook = new Workbook(); workbook.Worksheets.Add("test"); Infragistics.Excel.Worksheet sheet = workbook.Worksheets[0]; sheet.Rows[0].Cells[0].Value = 5.05; sheet.Rows[1].Cells[0].Value = "=A1+1";
when I wxport it to excel, A2 shows =A1+1, and I have to go into the cell and press enter again for it to update to 6.05, and pressing F9 doesn't update the cell. How can I do this properly? Thank you
Formula support was not added to the Excel assembly until version 7.2. You will have to upgrade to use this functionality.
HI,
I am using Version 7.1 and I want to use formula to ExcelExporter,Please send me the solution
This is a bug. I would recommend submitting it to the support group: http://es.infragistics.com/gethelp.
I have a xll library that I can call in Excel, the name of the functions are like method_funcname(B2,B3,B4,B5,B6,B7,B8,B9,B10,B11,B12,B13,B14,B15,B16,B17) but the formula parser returns me an error
The formula has extra expressions after the end of it.Portion with error: (B2,B3,B4,B5,B6,B7,B8,B9,B10,B11,B12,B13,B14,B15,B16,B17)
is there a limit as to what the functions we can use? are we limited to Excel default functions? How can we use user defined functions from xll? Thank you
Thank you very much, iti s solved now.