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

Jan Sundström  Identity Verified
Sweden
Local time: 11:05
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: 11:05
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: 11:05
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: 11:05
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







Across v6.3
Translation Toolkit and Sales Potential under One Roof

Apart from features that enable you to translate more efficiently, the new Across Translator Edition v6.3 comprises your crossMarket membership. The new online network for Across users assists you in exploring new sales potential and generating revenue.

More info »
WordFinder
The words you want Anywhere, Anytime

WordFinder is the market's fastest and easiest way of finding the right word, term, translation or synonym in one or more dictionaries. In our assortment you can choose among more than 120 dictionaries in 15 languages from leading publishers.

More info »



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