Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
The Excel union operator string is different for different locales (e.g. the
semicolon ";" in France and the comma "," in the US). I want to read out Excel Ranges using A1-style notation using the union operator, e.g. Excel.Range myRange = get_Range("A1,A2,A3", missing); Thus I have to consider locales when assembling my cell references string. Although when using VSTO 2008 the locale issue should be hidden behind wrapper objects when accessing the COM interface, this doesn't seem to be true when using the union operator inside String cell references. My operating system being Swiss German for instance does not accept "A1,A2,A3" as an input but only accepts "A1;A2;A3". Is it safe to read out System.Globalization.CultureInfo.CurrentCulture.Te xtInfo.ListSeparator to find the union operator? Or is this unsafe since another Excel Add-In might actually temporarily change the current locale? Or is there any better way to find out how to assemble my cell references String? I prefer not using the Application.Union method, because in my case this would probably result in accessing the COM interface repeatedly, whereas through building a cell references String I could save a lot of calls to this interface. Greetz Fabz |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to use union reference operator? | Excel Discussion (Misc queries) | |||
colon as an operator (used twice in a string) | Excel Discussion (Misc queries) | |||
Why doesnt union reference operator work with COUNTIF? | Excel Discussion (Misc queries) | |||
Locale issue | Excel Programming | |||
Excel's range Union operator in WORKDAY function gives #VALUE!. | Excel Programming |