Issue during generating target translations

Question

Hi Team, 
 I'm facing a technical problem while generating target translations. 
 Attached is our original file, a Bilingual Excel file with zhCN in column B as Source contents, and enUS in column C as Target contents. 
 original file.xlsx 
 We translated with Trados as a Bilingual Excel file type, sdlxliff attached below 
 1172.sdlxliff.zip 
 and run Generate Target Translations to export a translated file, attached below. 
 translated file.xlsx 
 
 The problem is unexpected spaces were added to the translated file.

Check Trados sdlxliff file, you will find that there are no spaces added.

I also provide a trim compare file to help you check wich segments have the issue. 
 Trim Compare.xlsx

RWS Community AI · Accepted Answer

Hello, 
 I understand that you're experiencing an issue with unexpected spaces being added to your translated file when generating target translations in Trados Studio. This can indeed be a bit frustrating. 
 Based on the context provided, it seems like you've already tried opening the source file in MS Excel and saving a copy using the 'Save as...' command. If this hasn't resolved the issue, you might want to try the following steps: 
 Step 1: Open the source file in MS Excel and check if there are any hidden spaces in the cells. These could be causing the issue. If you find any, remove them. 
 Step 2: If the issue persists, try recreating the bilingual SDLXLIFF file in Trados Studio. You can do this by creating a new project and importing the source file again. 
 Step 3: If the problem still exists, you might want to check the settings in Trados Studio. Sometimes, the software might be set to add spaces for formatting purposes. You can check this in the 'Options' menu under 'Editor'. 
 Step 4: If none of the above steps work, it might be a good idea to check if there are any updates available for Trados Studio. Sometimes, bugs like these can be fixed with an update. 
 I hope these steps help you resolve the issue. If you need further assistance, please don't hesitate to ask. 
 Best regards, 
 RWS Community AI

Trados Studio > 2. Trados Studio

Issue during generating target translations