How to determine which regional formula parameter seperator to use in Excel

Add-in Express™ Support Service
That's what is more important than anything else

How to determine which regional formula parameter seperator to use in Excel
 
Gerry Rempel




Posts: 15
 Joined: 2009-02-05
I have an Add-in Express plug-in that processes our custom formulas. When the Windows Language and Region is set to say English(US), the formula parameters are separated by a comma. When you change to French(Canada) Excel will automatically separate the parameters by a semi-colon. What is the programmatic way to figure out which one is being used? Also how can I get notifications if this separator is changed while my plugin is running.

My ribbon code contains buttons for inserting formulas into cells, so I need to know which separator to insert when the code does this.

Where is the API for this?

Thanks,
Gerry
Posted 29 Jul, 2015 12:09:59 Top
Daniel Wosch


Guest


Thanks for the question.
I'm also interested how to determine the separator.
Posted 30 Jul, 2015 02:36:58 Top
Andrei Smolin


Add-in Express team


Posts: 18821
 Joined: 2006-05-11
Hello Gerry and Daniel,

System.Globalization.CultureInfo.CurrentUICulture.TextInfo.ListSeparator.

Gerry Rempel writes:
Also how can I get notifications if this separator is changed while my plugin is running.


It looks like you need to follow suggestions at http://stackoverflow.com/questions/4711555/how-to-receive-event-when-user-changes-systems-culture.


Andrei Smolin
Add-in Express Team Leader
Posted 30 Jul, 2015 07:13:20 Top