AN
Anonymous
November 16, 2007 02:09 PM UTC
if comma is used to separate whole part from fractional part (Decimal symbol in regional settings), then it is obvious that you cannot use it as argument separator. So you have to provide another argument separator for XlsIO, for example, semicolon. To do this you can call
book.SetSeparators(';', ':');
or
application.ArgumentsSeparator = ';'
application.RowSeparator = ':'
And use formula SUBTOTAL(9;B2:B3)
But if comma is not decimal symbol, then it is definitely XlsIO bug
MW
Melba Winshia
Syncfusion Team
November 19, 2007 01:46 PM UTC
Hi Bert,
Thank you for your interest in Syncfusion Products.
As Ami updated, please set IApplication.ArgumentsSeparator as ';' and IApplication.RowSeparator as ':'. And also, please use formula SUBTOTAL(9;B2:B3) instead of SUBTOTAL(9,B2:B3).
Please try this and let me know if the issue still exists.
Thanks,
Melba