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

Telmo_Carlos  Identity Verified
Portugal
Local time: 11:38
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: 12:38
English
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) : http://wp.me/p2xDjK-br

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.

Regards

Paul


 


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







TM-Town
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 »
PerfectIt consistency checker
Faster Checking, Greater Accuracy

PerfectIt helps deliver error-free documents. It improves consistency, ensures quality and helps to enforce style guides. It’s a powerful tool for pro users, and comes with the assurance of a 30-day money back guarantee.

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search