| Table of Contents |
|---|
...
Nested hyperlinks and similar → A hyperlink cannot be nested as it cannot direct to two places at once. This always causes issues in the target file or in target generation. As you can see in the screenshot below, {2} tags are nested within {1}.
...
This is especially common in DOCX files, in which case the error below occurs when the user attempts to open the file:
...
Solution: In such a case, create a support ticket for the XTM International Support team and provide all the details needed for investigation.
Target for an Excel file does not generate at all: data validation field length exceeds 255 characters
During the attempt to generate a target Excel file, you might come across the following, rather enigmatic, error message in the XTM Cloud UI: Could not obtain data.
...
Sometimes the error message is more specific and contains a vital piece of information, but, in the context of Excel files, it mostly concerns the same thing as the previous message: Data Validation field length should not exceed 255 characters.
...
The problem stems from a poorly composed Excel source file where data validation is set up using a plain text instead of a cell range, for a dropdown list. Such a dropdown list in Excel has the limitation of 255 characters, and a target file that cannot be properly generated contains the translation that has exceeded this restriction. Unfortunately, this is the limitation pertaining to Excel itself, and XTM International cannot do anything to deregulate it.
Solution: There are two ways to handle this problem:
The first one is to shorten the translation – to keep the 255 characters limitation.
The second one (recommended) is to copy the values from the plain text into some cells, and create the data validation list using the cell range.
The screenshot below presents a list of items that are inserted incorrectly in the Source field – as a plain text.
...
The correct way is to insert them as a cell range, as shown below:
...
See an official, helpful tutorial on how to correctly set up a cell range dropdown list, here: Create a dropdown list.