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

Samuel Murray  Identity Verified
Local time: 09:04
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?


Direct link Reply with quote

David Turnbull
United Kingdom
Local time: 08:04
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]

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 »

Excel 2007's formula cells in Trados 2009

Advanced search

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 »
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 »

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