Options
Tags:
Related
Recommended

SDL TMS 2011 SP5 CU1 | Hotfix for defect #36361 – Legacy XLS filter does not extract some cell and text formatting

Judith de Jong

Symptoms:
While Pre-processing legacy XLS files, some formatting is lost. Reported issues:

  1. If the entire segment is formatted and the first word of the segment has an additional format, the formatting of the first word is lost.
  2. If the cell starts with formatting, then the cell formatting is lost.
  3. The space between two words with different formats is removed.

Explanation:
During the Extract TC stage for legacy XLS files, some formats are not properly interpreted by the SDL TMS XLS extract algorithm.

Resolution:
The algorithm has been modified to comply with all Microsoft Excel formatting requirements.

SDL-hosted customers should contact SDL Support to arrange for a hotfix to be deployed.

Customers who host TMS themselves should download the installer for SDLTMS2011SP5CU1 Hotfix for 36361.exe from the following FTP site: ftp://sdlpatches:5dlpatch35@ftp-emea.sdlproducts.com/SDL TMS/2011 SP5/CU1/Hotfix.

NOTE: Another issue has been identified, for example the cell formatting is lost if the cell contains at least one new line. This issue is caused by the third party tool (FlexCel) used to extract and rebuild the XLS file and it cannot be addressed from within SDL TMS.