Technical forums » Trados support »
Filter by source cell colour
Thread poster: Giovanni Danielli
Giovanni Danielli
Giovanni Danielli  Identity Verified
Italy
Local time: 17:54
Member (2013)
English to Italian
Oct 10, 2015

Hello

In a .xls file I have to translate only cells with a specific background colour.

Is there any chance to filter such segments in SDL2015 (or to lock non-coloured segments)?

I could set-up a .xlf file with coloured cells only, but once transalted in SDL the import process into original Excel would be very time-consuming...

Thank you
 
Shai Navé
Shai Navé  Identity Verified
Israel
Local time: 18:54
English to Hebrew
+ ...
Hide cells in the worksheet Oct 10, 2015

The easiest solution I can think of is to make a copy of the original Excel worksheet, hide all the cells that you don't need to be translated, and then import the resulting Excel file into Studio.

Once done translating, just unhide all rows/columns in the Excel document and you'll have the target file you need.
 
Platary (X)
Platary (X)
Local time: 17:54
German to French
+ ...
Sort by colors Oct 10, 2015

If you have Excel 2010 or higher, you can sort the table by colors. If not, Shai's solution is a good one.

Good luck!
 
Giovanni Danielli
Giovanni Danielli  Identity Verified
Italy
Local time: 17:54
Member (2013)
English to Italian
TOPIC STARTER
Hard to edit Excel Oct 10, 2015

Adrien Esparron wrote:

If you have Excel 2010 or higher, you can sort the table by colors. If not, Shai's solution is a good one.

Good luck!


Thank you both!
I'd prefer to work in SDL since my Excel is very comples, but I suspect is not possible...
Cheers
 
Walter Blaser
Walter Blaser  Identity Verified
Switzerland
Local time: 17:54
French to German
+ ...
Studio has such an option Oct 10, 2015

Giovanni

Studio does have an option to distinguish colours in an Excel sheet.

Go to "File - Options - File Types - Excel 2007-2013". Under "Colours", you can define the colours of the cells that Studio should skip.

Keep in mind that you need to reopen your file after you have changed this setting as it is applied during conversion from source to SDLXLIFF.

Walter
 
Umang Dholabhai
Umang Dholabhai  Identity Verified
India
Local time: 22:24
Member
English to Gujarati
+ ...
Transtools Oct 10, 2015

Another method is Transtools. Very helpful!
http://www.translatortools.net/excel-about.html
 
Giovanni Danielli
Giovanni Danielli  Identity Verified
Italy
Local time: 17:54
Member (2013)
English to Italian
TOPIC STARTER
Colours filtering Oct 10, 2015

Walter Blaser wrote:

Giovanni

Studio does have an option to distinguish colours in an Excel sheet.

Go to "File - Options - File Types - Excel 2007-2013". Under "Colours", you can define the colours of the cells that Studio should skip.

Keep in mind that you need to reopen your file after you have changed this setting as it is applied during conversion from source to SDLXLIFF.

Walter

Many thanks Walter, great aswer!
 


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

Moderator(s) of this forum
Natalie[Call to this topic]
Myron Netchypor[Call to this topic]
Marco Ramón[Call to this topic]
Maya Gorgoshidze[Call to this topic]
Prachya Mruetusatorn[Call to this topic]

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

Filter by source cell colour







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 Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

Buy now! »
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 »