Is there a way to keep the UI culture info when exporting a grid to Excel?
I have a date field which is displayed in the browser as dd/MM/yyyy which is how I want it. But when exported to Excel it becomes MM/dd/yyyy.
I set the UI culture in the blazor Program.Main.
var culture = new CultureInfo("en-GB");
CultureInfo.DefaultThreadCurrentCulture = culture;
CultureInfo.DefaultThreadCurrentUICulture = culture;
System.Threading.Thread.CurrentThread.CurrentCulture = culture;
System.Threading.Thread.CurrentThread.CurrentUICulture = culture;
I am using the WebAssembly version of Blazor.