Hi all,

Recently, I came across a XLSX file that had some cells with Data Validation. When running a pseudo-translation test, Excel cannot properly open the target file. Excel tries to recover the content of the sheet containing this data validation, however, all the content is lost in the process.

After checking the error provided by Excel I found some non-closing <DataValidation> tags in the internal XML.

I checked the source Excel file and it seems that the elements that have this issue corresponds to self-closing <DataValidation> elements in the source file. These elements are also missing the "type" and "formula" attributes, but I'm not sure if this has anything to do with the mentioned issue. Please see some screenshots below:

Pseudo-translated file with the wrong elements:

Original file elements:

Manually closing the tags in the target fil works, however, the content belonging to the Data Validation input messages in Excel only (the ones of the elements with the explained issue) is not translated in the target file even though it is included in the SDLXLIFF:

Note: Doing Copy Source to target to the whole SDLXLIFF file instead of pseudo-translating still triggers the same error in the target file, so I assume it is not about info being "lost" due to pseudo but Studio not being able to properly handle this kind of elements.

Does anybody know about this?