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

Telmo_Carlos  Identity Verified
Local time: 08:16
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.


SDL Community  Identity Verified
United Kingdom
Local time: 09:16
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.




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

Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »
Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for users! Save over 13% when purchasing Wordfast Pro through Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

More info »

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