We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. Image for the cookie policy date
close icon

Grid Excel Filtering DateTimeOffset exception


I am receiving an exception when filtering a column with DateTimeOffset data type and with excel filter type.

  Unhandled exception rendering component: Specified cast is not valid.
System.InvalidCastException: Specified cast is not valid.

I have attached a sample.

Thank you

Attachment: BlazorWASMApp_2_991bc818.zip

3 Replies 1 reply marked as answer

MS Monisha Saravanan Syncfusion Team January 9, 2023 02:11 PM UTC

Hi Pavel,

Greetings from Syncfusion support.

We have confirmed this as an issue and logged the defect report “Exception throws when performing Excel filtering for DateTimeoffset columnfor the same. Thank you for taking time to report this issue and helping us to improve our product. At Syncfusion, we are committed to fix all validated defects (subject to technological feasibility and Product Development Life Cycle) and this fix will be included in any of our upcoming patch release.


Disclaimer: “Inclusion of this solution in the weekly release may change due to other factors including but not limited to QA checks and works reprioritization”



PA Pavel January 10, 2023 12:57 PM UTC

Great thank you!

MS Monisha Saravanan Syncfusion Team February 21, 2023 03:48 AM UTC

Hi Pavel,

We are glad to announce that, we have included the fix for the issue “Exception throws when performing Excel filtering for DateTimeoffset columnin our release (  So please upgrade to our latest version of Syncfusion NuGet package to resolve the reported issue. Please find the Nuget package for latest fixes and features from below.

Nuget : https://www.nuget.org/packages/Syncfusion.Blazor.Grid

We thank you for your support and appreciate your patience in waiting for this release. Please get in touch with us if you would require any further assistance. 

Please let us know if you have any concerns.

Marked as answer
Live Chat Icon For mobile
Up arrow icon