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
Hi,
you need to parse the formula like this (untested!):
Infragistics.Excel.Formula formula = Infragistics.Excel.Formula.Parse("=A1+1", Infragistics.Excel.CellReferenceMode.A1);
Infragistics.Excel.WorksheetRegion region = new Infragistics.Excel.WorksheetRegion(sheet, 2,2,2,2); // check the parameters, I'm not sure about those!
formula.ApplyTo(region);
Hope that helps!
H Andre, thank you, what build is this? I tried to find the Formula function in build 6.2 and 7.1 but can't find it. Thank you.
Support for adding formulas to workbooks was not added until version 7.2. That is when this class was added.
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://ko.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.