Filter by source cell colour
Thread poster: Giovanni Danielli

Giovanni Danielli  Identity Verified
Italy
Local time: 17:37
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é  Identity Verified
Israel
Local time: 18:37
Member
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.


 

Adrien Esparron
Local time: 17:37
Member (2007)
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  Identity Verified
Italy
Local time: 17:37
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  Identity Verified
Switzerland
Local time: 17:37
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  Identity Verified
India
Local time: 21:07
Member
English to Gujarati
+ ...
Transtools Oct 10, 2015

Another method is Transtools. Very helpful!
http://www.translatortools.net/excel-about.html


 

Giovanni Danielli  Identity Verified
Italy
Local time: 17:37
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:


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

Filter by source cell colour

Advanced search







BaccS – Business Accounting Software
Modern desktop project management for freelance translators

BaccS makes it easy for translators to manage their projects, schedule tasks, create invoices, and view highly customizable reports. User-friendly, ProZ.com integration, community-driven development – a few reasons BaccS is trusted by translators!

More info »
SDL Trados Studio 2017 Freelance
The leading translation software used by over 250,000 translators.

SDL Trados Studio 2017 helps translators increase translation productivity whilst ensuring quality. Combining translation memory, terminology management and machine translation in one simple and easy-to-use environment.

More info »



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