The Syncfusion native Blazor components library offers 70+ UI and Data Viz web controls that are responsive and lightweight for building modern web apps.
.NET PDF framework is a high-performance and comprehensive library used to create, read, merge, split, secure, edit, view, and review PDF files in C#/VB.NET.
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
MWMelba 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.