Creating bilingual XLS files with multiple tabs
Thread poster: Jean-Christophe Duc

Jean-Christophe Duc  Identity Verified
France
Local time: 21:38
English to French
+ ...
Sep 19, 2016

I am looking for a solution to facilitate the translation of XLS files with multiple tabs.
So far the only solution I have found is to translate the file in Studio or whatever, then to copy the translation beside the English column.
This is OK when there is one or two tabs, but as soon as there more, it becomes complicated.
Any ideas?


Direct link Reply with quote
 

Ben Senior  Identity Verified
Germany
Local time: 21:38
German to English
Hide a column Sep 19, 2016

If you copy the source column into the target column and then hide the source column, you can then translate the file in your CAT tool. Afterwards just unhide the source column and you have the bilingual worksheet.

Ben


Direct link Reply with quote
 

Jean-Christophe Duc  Identity Verified
France
Local time: 21:38
English to French
+ ...
TOPIC STARTER
thanks Sep 19, 2016

Do you mean the "hide column" command in Excel?
Can it be "unhidden" afterwards?


Direct link Reply with quote
 

Jean-Christophe Duc  Identity Verified
France
Local time: 21:38
English to French
+ ...
TOPIC STARTER
Hidden columns Nov 21, 2016

For info, the command to "unmask" the Excel columns is buried into the Home tab, Cell group -> Hide / Unhide.
And yes, creating two columns and hiding one remains the easiest way to generate bilingual Excel files. It is probably possible to create a macro for this.


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 »

Creating bilingual XLS files with multiple tabs

Advanced search






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

More info »



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