Summary

It is possible to create an Excel application that will work on every installation of Excel in the world and support all 180-plus Office languages, but it is unlikely to be economically viable.

If you have a limited set of users and you are able to dictate their language and Windows Regional Settings, you can create your application without worrying about international issues. Even if this is the case, you should get into the habit of creating locale-independent code. The requirement for locale-independence should be included in your analysis, design, and coding standards. It is much, much easier and cheaper to write locale-independent code at the onset than to rework an existing application.

At a minimum, your application should work regardless of the users' choice of Windows Regional Settings or Windows or Office UI Language, or whether they have set non-standard thousands and decimal separators using Office Menu O Excel Options O Advanced. You should be able to achieve this by following the rules listed in this chapter.

The following Excel features don't play by the rules and have to be treated very carefully:

OpenText

SaveAs to a text file

ShowDataForm

Pasting text from other applications

The .Formula property in all its guises

<range>.Value

<range>.FormulaArray

<range>.AutoFilter

<range>.AdvancedFilter

The =TEXT() worksheet function

Application.Evaluate

Application.ConvertFormula

Application.ExecuteExcel4Macro

Web Queries

You may have to avoid some features in Excel completely:

□ Using True and False in imported text files

0 0

Post a comment