Excel Locale Issue
-
G'day folks, I'm attempting to write out a CSV file (don't ask) in a format that can be read by Excel (also don't ask) across Locales. Now, this is fine, I can format the numeric values correctly and then separate them using the locale's list separator. However, it seems that Excel only ever uses the System Locale list separator. That is, if some user overrides their separator (again, don't ask) to ',', Excel doesn't use that, but the original default setting for the locale (in the Italian locale, ';'). Is this behaviour expected? Sensible? A pain in the #$%? Thanks. ------------------------ Derek Waters derek@lj-oz.com
-
G'day folks, I'm attempting to write out a CSV file (don't ask) in a format that can be read by Excel (also don't ask) across Locales. Now, this is fine, I can format the numeric values correctly and then separate them using the locale's list separator. However, it seems that Excel only ever uses the System Locale list separator. That is, if some user overrides their separator (again, don't ask) to ',', Excel doesn't use that, but the original default setting for the locale (in the Italian locale, ';'). Is this behaviour expected? Sensible? A pain in the #$%? Thanks. ------------------------ Derek Waters derek@lj-oz.com
Are you sure that Excel is supposed to use the locale's list separator? Maybe what Excel is dealing with is not considered a list. Anyway, once you have the data in Excel, you can use the Text to Columns menu option to fix the problem.
Five birds are sitting on a fence. Three of them decide to fly off. How many are left?