2006-05-31 21:34:01 UTC
When Visio 2003 is used with Turkish Regional Settings selected in the
Windows Control Panel, certain cells cannot be referenced in other ShapeSheet
cells. For example, using Connections.X1 in the formula of another ShapeSheet
cell causes Visio to return "error in formula". The same applies if you apply
a name to the row containing the Connections.X1 cell.
Initally I thought the problem only affected cells in rows which can be
named. It does affect cells in rows of the Connections, Actions and
Hyperlinks sections, but it does not affect cells in the Controls, User
defined cells or custom properties sections. Nor does it affect cells in the
Geometry, Shape Transform, 1-D Endpoints, Scratch, Protection, Miscellaneous,
Line Format or Fill Format sections.
If a document is created with, for example, English (United Kingdom)
regional settings, ShapeSheet formula can include Connections.X1 and work OK
when the regional settings are changed to Turkish. But with Turkish regional
settings you can't enter Connections.X1 into a formula even if the formula is
copied from another existing ShapeSheet cell.
Neither Visio 5 or Visio 2002 are affected. Therefore, it seems to be a
problem that has been introduced with Visio 2003 or one of the two Visio 2003
We have around 25 customers in Turkey who use our Visio solution and this
problem has wide ranging implications and is not one we can easily workaround
with modifications to our software. Also I'm sure others must have noticed
I'd be grateful if anyone can help with information.