Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old October 9th 08, 09:45 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2008
Posts: 1
Default Bug or feature?

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?


  #2   Report Post  
Old October 9th 08, 01:19 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: May 2007
Posts: 154
Default Bug or feature?

Leo,

I tried to duplicate your issue. By doing so I went to Control
PanelRegional and Language Settings Changed from English to German.
It did change the , to ; as you said. When I saved the application, closed,
changed my settings back to English, the ; returned to , as it should. I
could not get the program to ignore the ;. Have you ensured that your
regional settings are set to where you want them?

--
--Thomas [PBD]
Working hard to make working easy.
Answered your question? Click ''Yes'' below.


"Leo Mazzi" wrote:

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?

  #3   Report Post  
Old October 9th 08, 03:51 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2008
Posts: 7
Default Bug or feature?

As I said, the problem is visible when you go and change the defult value -
so let's say you set it to GB - you have there the default delimiter ",". Now
go and customize this by changing this value to ";". In that case Excel will
ignore your change - so Excel is (at least for any PC I went on checking)
ignoring my customization. This is a problem to me because I have to fill in
programatically some formulas and I came upon some customers having this
customized.

If you only change the country then Excel reacts promptly and changes the
delimiter also for all open onscreen documents.

So if this is a feature or a BUG is an info I would really need to react
propperly.

Is there maybe a way of detecting which is the delimiter that Excel will use
by asking Excel (so without the need of checking the regional settings)?

Best regards,
Leo

"Thomas [PBD]" wrote:

Leo,

I tried to duplicate your issue. By doing so I went to Control
PanelRegional and Language Settings Changed from English to German.
It did change the , to ; as you said. When I saved the application, closed,
changed my settings back to English, the ; returned to , as it should. I
could not get the program to ignore the ;. Have you ensured that your
regional settings are set to where you want them?

--
--Thomas [PBD]
Working hard to make working easy.
Answered your question? Click ''Yes'' below.


  #4   Report Post  
Old October 9th 08, 05:39 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 5,651
Default Bug or feature?

On Thu, 9 Oct 2008 07:51:02 -0700, Leo Mazzi
wrote:

Is there maybe a way of detecting which is the delimiter that Excel will use
by asking Excel (so without the need of checking the regional settings)?



application.International(xllistseparator)
--ron
  #5   Report Post  
Old October 9th 08, 06:13 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: May 2007
Posts: 154
Default Bug or feature?

Leo,

I guess you have to check two places to ensure that the List Separator is
enabled as a comma. First place, one that I am pretty sure you have checked:
StartSettingsControl PanelRegional and Language
OptionsCountryCustomizeNumberList Separator. The second place, inside of
Excel itself: ToolsOptionsInternationalUse System Separators Checkbox.
Thirdly, you can reference this page for additional information on setting
the computer registry.

http://geekswithblogs.net/robz/archi...delimiter.aspx

--
--Thomas [PBD]
Working hard to make working easy.
Answered your question? Click ''Yes'' below.


"Leo Mazzi" wrote:

As I said, the problem is visible when you go and change the defult value -
so let's say you set it to GB - you have there the default delimiter ",". Now
go and customize this by changing this value to ";". In that case Excel will
ignore your change - so Excel is (at least for any PC I went on checking)
ignoring my customization. This is a problem to me because I have to fill in
programatically some formulas and I came upon some customers having this
customized.

If you only change the country then Excel reacts promptly and changes the
delimiter also for all open onscreen documents.

So if this is a feature or a BUG is an info I would really need to react
propperly.

Is there maybe a way of detecting which is the delimiter that Excel will use
by asking Excel (so without the need of checking the regional settings)?

Best regards,
Leo

"Thomas [PBD]" wrote:

Leo,

I tried to duplicate your issue. By doing so I went to Control
PanelRegional and Language Settings Changed from English to German.
It did change the , to ; as you said. When I saved the application, closed,
changed my settings back to English, the ; returned to , as it should. I
could not get the program to ignore the ;. Have you ensured that your
regional settings are set to where you want them?

--
--Thomas [PBD]
Working hard to make working easy.
Answered your question? Click ''Yes'' below.




  #6   Report Post  
Old October 10th 08, 10:15 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2008
Posts: 7
Default Bug or feature?

thank you for the tip. I actually generate the output from C# code so my
solution would be:

string listSeparator = (string) Application.get_International(0x00000005);

I use the hardcoded value for xlListSeparator because seems that there is no
representation of it in the Excel.Constants enum.



"Ron Rosenfeld" wrote:

On Thu, 9 Oct 2008 07:51:02 -0700, Leo Mazzi
wrote:

Is there maybe a way of detecting which is the delimiter that Excel will use
by asking Excel (so without the need of checking the regional settings)?



application.International(xllistseparator)
--ron

  #7   Report Post  
Old October 10th 08, 10:18 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Oct 2008
Posts: 7
Default Bug or feature?

Thanks Thomas but I do the fill in programatically without the possibility to
go trough the GUI interface. Actually Ron's solution gave me a good tip how
to do it in a fast way (one line of code).

in addition OptionsCountryCustomizeNumberList Separator defines the
decimal and the thousands separators not the list separator.

best regards,
Leo

"Thomas [PBD]" wrote:

Leo,

I guess you have to check two places to ensure that the List Separator is
enabled as a comma. First place, one that I am pretty sure you have checked:
StartSettingsControl PanelRegional and Language
OptionsCountryCustomizeNumberList Separator. The second place, inside of
Excel itself: ToolsOptionsInternationalUse System Separators Checkbox.
Thirdly, you can reference this page for additional information on setting
the computer registry.

http://geekswithblogs.net/robz/archi...delimiter.aspx

--
--Thomas [PBD]
Working hard to make working easy.
Answered your question? Click ''Yes'' below.


"Leo Mazzi" wrote:

As I said, the problem is visible when you go and change the defult value -
so let's say you set it to GB - you have there the default delimiter ",". Now
go and customize this by changing this value to ";". In that case Excel will
ignore your change - so Excel is (at least for any PC I went on checking)
ignoring my customization. This is a problem to me because I have to fill in
programatically some formulas and I came upon some customers having this
customized.

If you only change the country then Excel reacts promptly and changes the
delimiter also for all open onscreen documents.

So if this is a feature or a BUG is an info I would really need to react
propperly.

Is there maybe a way of detecting which is the delimiter that Excel will use
by asking Excel (so without the need of checking the regional settings)?

Best regards,
Leo

"Thomas [PBD]" wrote:

Leo,

I tried to duplicate your issue. By doing so I went to Control
PanelRegional and Language Settings Changed from English to German.
It did change the , to ; as you said. When I saved the application, closed,
changed my settings back to English, the ; returned to , as it should. I
could not get the program to ignore the ;. Have you ensured that your
regional settings are set to where you want them?

--
--Thomas [PBD]
Working hard to make working easy.
Answered your question? Click ''Yes'' below.


  #8   Report Post  
Old October 10th 08, 11:23 AM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 5,651
Default Bug or feature?

On Fri, 10 Oct 2008 02:15:01 -0700, Leo Mazzi
wrote:

thank you for the tip. I actually generate the output from C# code so my
solution would be:

string listSeparator = (string) Application.get_International(0x00000005);

I use the hardcoded value for xlListSeparator because seems that there is no
representation of it in the Excel.Constants enum.


Glad to help.

Thanks for the feedback.
--ron


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Exel feature confused&lost Excel Discussion (Misc queries) 3 October 26th 09 04:38 PM
is this a bug or feature? Gary Keramidas Excel Programming 1 March 16th 06 04:36 AM
Yes / No Feature DCSwearingen Excel Worksheet Functions 1 August 5th 05 05:04 PM
Worksheet feature help Josh22 Excel Programming 0 June 7th 05 05:44 PM
RTD Bug? or perhaps a feature? Another frustrated developer Excel Programming 6 March 4th 05 12:13 PM


All times are GMT +1. The time now is 03:51 PM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017