Hi, I'm trying to export to one excel document some data in a DataTable using Infragistics.Excel, and I would like to export some formulas (for example for the summaries..).

Example:

------------------------------------------------------------------------------------------------------------------------------------------------------

Workbook wb = new Infragistics.Excel.Workbook(Infragistics.Excel.WorkbookPaletteMode.CustomPalette);
Worksheet ws = wb.Worksheets.Add("WorkSheet");

int i = 0;

 for(i=0; i<10; i++) {

      ws.Rows[1].Cells[i].Value = "NIGHT";

}

Infragistics.Excel.Formula formula = Infragistics.Excel.Formula.Parse("=COUNT.IF($A12:$E12;\"NIGHT\")", CellReferenceMode.R1C1);
formula.ApplyTo(ws.Rows[1].Cells[i+1]);

----------------------------------------------------------------------------------------------------------------------------------------------

Thowing an exception when try to apply formula: "The formula has extra expressions after the end of it.Portion with error: ($A12:$E12;"NIGHT")"

 What is wrong?

 Thanks.

 Jacobo.