Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I was wandering if this is a bug (so it will be fixed) or a feature (so I can
expect the same behavior in the following versions)... Excel uses in many cell formulas the regional settings list separator character to separate between parameters (example for GB the list separator is "," so an IF formula would look as: "=IF(bool, true, false)" but when you change the country to DE then the separator is ";" and you have to use the formula in the way: "=IF(bool; true; false)". Now this would not be a problem if Excel would not use the DEFAULT regional configuration so if any user customizes his regional settings to have a different separator than the default - Excel (tested with Excel 2003) currently ignores it - so for example: the user selected in GB the ";" as a separator - but Excel still thinks that the separator is ",". Is this a BUG or a feature? Does anyone know about this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Exel feature | Excel Discussion (Misc queries) | |||
is this a bug or feature? | Excel Programming | |||
Yes / No Feature | Excel Worksheet Functions | |||
Worksheet feature help | Excel Programming | |||
RTD Bug? or perhaps a feature? | Excel Programming |