GUARD function in German Visio 2003

[Warner]

We use the GUARD function to protect Custom Properties that we send to the
ShapeSheet for a shape on the drawing. This works fine for Visio 2003
English and we tested it in Visio Spanish; however, using Visio German, we
get a setFormulas error. Does anyone know why this happens and is there
another solution that we could use - other than to eliminate the GUARD
function altogether and not have any protect against changes to the Custom
Property values?

Thanks in advance for any help.

 

[Mark Nelson [MS]]

The most common reason why code works differently in different languages is
that the code does not use universal Shapesheet syntax. When setting and
retrieving values from cells, always use the universal methods:

CellsU, CellExistsU, SetFormulasU, GetFormulasU, FormulaU, FormulaForceU

These methods work with universal syntax (which is the equivalent of
English). Keeping formulas in this syntax means that they work in all
languages. If you don't use the universal methods, you must tailor your
formulas to the current locale. German uses different punctuation for
numbers than English and Spanish so this may explain the failures.

--
Mark Nelson
Office Graphics - Visio
Microsoft Corporation

This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Warner]

Hi Mark,

Thanks for your suggestion. We will look at this.

Regards,

Warner