I'm making multi culture plugin for MS Word,Excel where I need to identify setting value provided in Regional Settings under "List Separator" Option, how can I read using C# ?
This List separator is later on being used to construct Excel formulas, word mail merge header, etc.
By default, Excel uses the list separator defined under regional settings in Control Panel. The US English version of Excel uses a comma (,) for list separator by default, while other international versions may use a semicolon (;). This impacts how functions are entered in Excel.
Try using System.Globalization.CultureInfo.CurrentCulture.TextInfo.ListSeparator
or System.Globalization.CultureInfo.GetCultureInfo("en-US").TextInfo.ListSeparator
if you look for a specific culture's information.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With