Excel 2007's formula cells in Trados 2009
Thread poster: Samuel Murray

Samuel Murray  Identity Verified
Local time: 10:43
Member (2006)
English to Afrikaans
+ ...
Sep 29, 2010

G'day everyone

I have an Excel 2007 file that I want to translate in Trados 2009. Some of the contents is not displayed in Trados at all. These cells are usually formula cells with text content. For example:

One cell contains this text visibly:

Tax for the year ended 28 February 2009

but in the cell itself, you find this:

="Tax for the year ended "& PROPER(TEXT(YearEndDate, "d mmmm yyyy"))

and a search for "Tax for the year ended" in Trados yields no results. This means that this text will not be translated in the Excel file when I'm done with my translation in Trados.

In another cell, the visible text is:

Annual Financial Statements

but the cell itself contains this:

=IF(Cons=1,"Consolidated ","")&IF(AccPeriod=12, "Annual Financial", "Financial")&" Statements"

and again, I can't find "Annual Financial Statements" in the file in Trados. Obviously this must be translated, either as a formula intact or as text content (overwriting the formula, in other words).

Can Trados do this?



David Turnbull
United Kingdom
Local time: 09:43
Italian to English
If you want to get rid of the formulae Sep 29, 2010

If you want to get rid of the formulae and just translate their results as plain text.

Select everything in the sheet (Ctrl + A)

Copy (Crtl + C)

Then go to Paste Special (in 2007 it's in the Home ribbon on the left hand side under the Paste drop down menu).

Select "Values" and click ok.

The text shown in the cells will now just be plain text and will run normally through Trados.

Should make things rather simpler - I don't know if it's possible to translate underlying formulae and unless they need to use this Excel sheet with all its functions in tact in the target language, I'd say it's not necessary to do so.

[Edited at 2010-09-29 10:38 GMT]


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

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

Excel 2007's formula cells in Trados 2009

Advanced search

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 »
memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »

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