Keep original .xls background/text colors in Trados 2011
Thread poster: Telmo_Carlos

Telmo_Carlos  Identity Verified
Local time: 13:50
Member (2012)
English to Portuguese
+ ...
Apr 3, 2014

Hello, is there any way do display the original cell formatting of an .xls file in Trados?
The reason for this is that I have an excel file in which the client needs me to translate only the cells in green color. In Trados everything in the source column shows up in black text. Can anyone please help?

Thank you very much.

Direct link Reply with quote

SDL Community  Identity Verified
United Kingdom
Local time: 14:50
Not possible... Apr 3, 2014

... but depending on the content of the file perhaps you can use a search and replace to change the colour of the text in all the cells apart from the ones with a green background, and then set that colour to be non-translatable. This way you will be left with only the cells you have to translate in Studio. See this post for more info (it’s the second half of the article) :

If the whole file is very colourful this probably won't be an option as it would be tricky to get the content back as it was afterwards. But again, depending on the layout perhaps you can hide the rows & columns you don’t want and then only the stuff left behind will be parsed for translation in Studio.



Direct link Reply with quote

To report site rules violations or get help, contact a site moderator:

You can also contact site staff by submitting a support request »

Keep original .xls background/text colors in Trados 2011

Advanced search

SDL MultiTerm 2017
Guarantee a unified, consistent and high-quality translation with terminology software by the industry leaders.

SDL MultiTerm 2017 allows translators to create one central location to store and manage multilingual terminology, and with SDL MultiTerm Extract 2017 you can automatically create term lists from your existing documentation to save time.

More info »
CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use SDL Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

More info »

  • All of
  • Term search
  • Jobs
  • Forums
  • Multiple search