How can I configure studio to retain the formats of imported excel file?

Question

Hi everyone, 
 
 I'd like to ask a question and hope you could kindly give me an answer. 
 Sometimes I use Trados Studio to translate manuscripts which are excel files containing 2 columns: A & B. Column A is the original for translation, normally with various formats such as text color, bolt, and Column B is for translated text. While I import the excel file into Trados when creating a project for translation, I always find that the original text's formats (as shown in the fig) are lost and therefore the translated text which are exported can only be plain text without any format. 
 
 I wanna know if there are some settings in Studio to retain all formats, tags in an original excel file when importing it to the creation of a project so that the translated file can be as is in formats, tags as possible. 
 
 Thanks.

Jesús Prieto · Accepted Answer

It's formatting regarding the whole cell, so it's skipped by Trados Studio. Same thing in Word documents where a full paragraph is formatted as bold, for example. 
 In your case, I'd open the translated spread-sheet in Excel, use the Format Painter tool to copy the formatting of column A and then paste it in column B.

BORA Al · Answer

Thank you, Juesus.

BORA Al · Answer

Thank you Paul. 
 How are you? Long time no see. 
 This will be a good way for all blank cells in Column B. In many cases Column B will have filled cells which need to be remained unchanged, as shown in the fig below. I forgot to mention this in the question. 
 
 Thanks again...

Jesús Prieto · Answer

Maybe 2 seconds?

BORA Al · Answer

I applied the brush to cells one by one... 
 Thank you very much, a friend from Spain...

Trados Studio > 1. Trados Studio

How can I configure studio to retain the formats of imported excel file?

Top Replies