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

Jan Sundström  Identity Verified
Sweden
Local time: 14:25
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 Turn social sharing on.
Like 12
 

Jaroslaw Michalak  Identity Verified
Poland
Local time: 14:25
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 Turn social sharing on.
Like 17
 

Jan Sundström  Identity Verified
Sweden
Local time: 14:25
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 Turn social sharing on.
Like 13
 

Jaroslaw Michalak  Identity Verified
Poland
Local time: 14:25
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 Turn social sharing on.
Like 8
 


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







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 »
SDL Trados Studio 2017 only €495 / $595
Get the cheapest prices for SDL Trados Studio 2017 on ProZ.com

Join this translator’s group buy brought to you by ProZ.com and buy SDL Trados Studio 2017 Freelance for only €495 / $595 / £425 / ¥70,000 You will also receive FREE access to Studio 2019 when released.

More info »



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