SUBTOTAL Function results in ParseException

[Bert Vanpeteghem]

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

[Anonymous]

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

[Melba Winshia]

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