Translating special characters

The labels of the combo boxes must be translated if a user changes the report language. Characters such as the colon (:) present a problem because the colon does not form part of the strings in the table of names and texts.

For example, in cell B6, the label, Measure is translated if the report language is changed. But if we insert a colon after Measure, the string is not translated.

An incorrect solution is to change Measure in the Table of Names and Texts to Measure:. Another is to have two versions of each string, one with and one without the colon.

Here is the correct solution:

  1. Use this syntax to insert labels for each of the combo boxes. Include a colon at the end of each string:
    =Translateuniquestring("Label")&":". For example: =Translateuniquestring("Measure")&":"
    Note: If strings do not exist, you are prompted to add them to the table of names and texts.
  2. Save the report and then create a copy called Tutorial6.