Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to read "List Separator" settings from Regional configuration of control panel?

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.

like image 822
shahjapan Avatar asked Jul 26 '11 18:07

shahjapan


People also ask

What is regional list separator?

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.


1 Answers

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.

like image 71
floele Avatar answered Oct 05 '22 20:10

floele