Mobile menu

Trados counts Excel tab names only?!
Thread poster: Jan Sundström

Jan Sundström  Identity Verified
Sweden
Local time: 06:58
English to Swedish
+ ...
Apr 19, 2007

Hi all,

I have a slightly elaborate Excel file, with eight tabs. The tab names are all less than 32 characters, and neither of them contain any non-standard chars.
Each page has a dozen columns of text.

I try to analyze this in Trados 7.5, but the word count only amounts to 8 words!
Even after resetting all filter settings back to default, it's still the same.

We sent in the file to Trados support. They explained that there is a bug: Trados only counts the tab names, not the actual content, but couldn't explain why.

Did any of you come across this behaviour, and is there any workaround (short of cut/pasting the entire content into a new file)?

TIA;

Jan


Direct link Reply with quote
 

Jabberwock  Identity Verified
Poland
Local time: 06:58
Member (2004)
English to Polish
Hidden (locked) content? Apr 19, 2007

You probably did, just asking to make sure: Have you checked if the content is hidden (locked) in Excel? Trados by default does not process hidden/locked cells...

(BTW, Jan, have you received my "problematic" inx file?)

Jarek


Direct link Reply with quote
 

Jan Sundström  Identity Verified
Sweden
Local time: 06:58
English to Swedish
+ ...
TOPIC STARTER
Hidden but still visible?! Apr 20, 2007

Jabberwock wrote:

You probably did, just asking to make sure: Have you checked if the content is hidden (locked) in Excel? Trados by default does not process hidden/locked cells...

(BTW, Jan, have you received my "problematic" inx file?)

Jarek


Thanks Jarek,

I'll check, but can content be "hidden" but still appear visible and editable in front of my eyes?

I know the standard commands for hiding/unhiding columns (and applying filter settings in Trados to skip those hidden columns), but is the function you mention something else?!

I did get your mail, but I've just been so busy. I'll have a look at it again!

/Jan


Direct link Reply with quote
 

Jabberwock  Identity Verified
Poland
Local time: 06:58
Member (2004)
English to Polish
This is it... Apr 20, 2007

No new function, I thought you wouldn't miss that one...

It is just I remember that I had once problems with the combination of functions: "Format/Protection/Lock" for cells and the protection of the sheet/document itself. That is, some cells were marked as "Locked" and, although editable in Excel (as the sheet/document were not protected), there were problems with their import.

It might not be the case at all, just thought it might be worth checking.


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 »

Trados counts Excel tab names only?!

Advanced search


Translation news related to SDL Trados





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 »
Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »



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