Array constants different in greek locale

  • Thread starter Thread starter vgee
  • Start date Start date
V

vgee

When using Excel 2007 in a greek locale (greek menus) array constants'
separators for rows and columns work the other way around, i.e. ={1, 2, 3, 4}
means four rows in one column and ={1; 2; 3; 4} means four columns in one
row. It changed to the normal behaviour when I purchased and installed the
english environment.

Probably related to this is that N/A values in a greek locale are shown in
greek (Δ/Υ). This is a step too far, as I cannot share the workbook
internationally.



----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...84bf30b&dg=microsoft.public.excel.crashesgpfs
 
What character separates the integer part from the fractional part of a
floating point number? When regional settings change that separator from a
period to a comma, the separator for function arguments changes from a comma
to a semicolon, which may be related to your observation.

Jerry
 
No, this is not the cause. I have set an English locale for the same reason
(collaboration), so the saparator is the period (.). I think this should be
considered a bug, that means, an unwanted consequence of the Greek
localization.
 
Back
Top