Technical forums » Trados support »
Filter by source cell colour
Thread poster: Giovanni Danielli
Giovanni Danielli
Giovanni Danielli  Identity Verified
Italy
Local time: 07:46
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: 08:46
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: 07:46
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: 07:46
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: 07:46
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: 11:16
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: 07:46
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







Trados Studio 2022 Freelance
The leading translation software used by over 270,000 translators.

Designed with your feedback in mind, Trados Studio 2022 delivers an unrivalled, powerful desktop and cloud solution, empowering you to work in the most efficient and cost-effective way.

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 »