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

Telmo_Carlos  Identity Verified
Local time: 09:34
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: 10:34
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

Manage your TMs and Terms ... and boost your translation business

Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.

More info »
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 »

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