ParseException

[Artur]

Hi,
I try set Formula.

Listing:

using (ExcelEngine excelEngine = new ExcelEngine())
{
IWorkbook book = null;
IWorksheet sheet = null;
book = excelEngine.Excel.Workbooks.Add();
sheet = book.ActiveSheet;
IRange range;
range = sheet.Range["A1"];
range.Number = 9.0;
range = sheet.Range["A2"];
range.Number = 12.0;
range = sheet.Range["A3"];
range.Number = 12.0;
range = sheet.Range["A4"];
this --> range.Formula = "SUBTOTAL(9;B1:B3)";
}

And get:

Unexpected token.Unexpected token type: Identifier, string value: at position 11. Formula: SUBTOTAL(9;B1:B3), Position: 11


What wrong ?

[Artur]

Hmm.. i Write that:

using (ExcelEngine excelEngine = new ExcelEngine())
{
IWorkbook book = null;
IWorksheet sheet = null;
book = excelEngine.Excel.Workbooks.Add();
sheet = book.ActiveSheet;
IRange range;
range = sheet.Range["A1"];
range.Number = 9.0;
range = sheet.Range["A2"];
range.Number = 12.0;
range = sheet.Range["A3"];
range.Number = 12.0;
range = sheet.Range["A4"];
---> range.Formula = "SUBTOTAL(9,B1:B3)";
}



Unexpected token.Unexpected token type: Identifier, string value: B1:B3 at position 12. Formula: SUBTOTAL(9,B1:B3), Position: 17

[Geetha M]

Hi Artur,

This exception occurs if different regional setting is used other than English. You may need to set separator to workbook before assigning formula depending upon your current UI culture. Please refer to the following KB article which explains the same:

http://www.syncfusion.com/support/kb/1952/

Regards,
Geetha