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.
Greetings from Syncfusion support.
We have confirmed this as an issue and logged the defect report “Exception throws when performing Excel filtering for DateTimeoffset column” for 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”
Great thank you!
We are glad to announce that, we have included the fix for the issue “Exception throws when performing Excel filtering for DateTimeoffset column” in our release (188.8.131.52). 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.
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.