SUBTOTAL Function results in ParseException

An unhandled exception of type 'Syncfusion.XlsIO.Implementation.Exceptions.ParseException' occurred in Syncfusion.XlsIO.Base.dll

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

This happens when I try ',', ';', with or without '=' and on Value, Value2, Formula properties.

Can I make this work?

Thanks


2 Replies

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


Loader.
Up arrow icon