Saving translated Excel-document from WF 2.4.0.1
Thread poster: Joern Wennerstroem

Joern Wennerstroem  Identity Verified
Local time: 13:57
English to Danish
Aug 15, 2010

I have translated an Excel (Office 2007) document of 534 segments. I need to deliver the clean Excel-document. For this I choose: File/Save translated file.
I get the following error-message:
Problem aligning document. Segment id: 357
Reason: A worksheet with the same name already exists.
============
I've checked this a gazillion times. No document of the same name exists on the machine. I do not have a solution for the problem. Any help is greatly appreciated.
--
System: Win XP Home ED. SP 3
Wordfast 2.4.0.1


Direct link Reply with quote
 

Aude Sylvain  Identity Verified
France
Local time: 13:57
English to French
+ ...
save as Aug 15, 2010

I have no idea why "save translated file" doesn't work, and hope someone will be able to help you. In the interim though (since I assume a Sunday request can be very urgent!), did you try to save the txml under a different name using the "save as" function, and then use "save translated file" from that copy to obtain a clean file?

Regards
Aude


Direct link Reply with quote
 

Joern Wennerstroem  Identity Verified
Local time: 13:57
English to Danish
TOPIC STARTER
Save as (different filename) before Saving translated document Aug 15, 2010

Thanks Aude, Unfortunately your suggestion did not work I still get this crazy error concerning segment id 357

Direct link Reply with quote
 

Joern Wennerstroem  Identity Verified
Local time: 13:57
English to Danish
TOPIC STARTER
Save translated file problem solved (sort of...) Aug 15, 2010

I solved the problem, sort of. I simply went to the apparently offending segment (id 357), deleted the text there - my translation as it were. Subsequently the file could now be saved, of course sans the offending text. It was only one word, so it can be entered manually afterwards. But I have no inkling as to the true nature of the problem. I'd deem this a workaround....

Direct link Reply with quote
 

Aude Sylvain  Identity Verified
France
Local time: 13:57
English to French
+ ...
- Aug 15, 2010

Thanks Joern for keeping me informed.

It is weird indeed. I cannot see the link between a 'corrupted' row and the message you had re an alleged preexisting file with the same name. But I am not good at all at computers/programming, a colleague might find this crystal clear.

I'm happy you found this turnaround though!


Direct link Reply with quote
 

Yasmin Moslem  Identity Verified
Egypt
Local time: 13:57
English to Arabic
worksheet Aug 15, 2010

Joern Wennerstroem wrote:

I have translated an Excel (Office 2007) document of 534 segments. I need to deliver the clean Excel-document. For this I choose: File/Save translated file.
I get the following error-message:
Problem aligning document. Segment id: 357
Reason: A worksheet with the same name already exists.


Dear Joern,

I am happy that you managed to Save Translated File.

For your (and other colleagues') information, a "worksheet" does not mean another file; it means a "Sheet" in the same Excel file, "a worksheet with the same name". So changing the name of one of the sheets (in the same Excel file) with the duplicate name should help.


---
Best regards,
Yasmin Moslem

Wordfast Support Team
www.wordfast.com | www.wordfast.net


Direct link Reply with quote
 

Soonthon LUPKITARO(Ph.D.)  Identity Verified
Thailand
Local time: 18:57
Member (2004)
English to Thai
+ ...
Excel error message Aug 16, 2010

Yasmin Moslem wrote:
For your (and other colleagues') information, a "worksheet" does not mean another file; it means a "Sheet" in the same Excel file, "a worksheet with the same name". So changing the name of one of the sheets (in the same Excel file) with the duplicate name should help.

This is not a WFP error but an Excel error message. Many other CAT tools cannot translate the worksheet name [I need to edit after final cleaning of files] and they prevented the error message above. WFP waring message is not easy to understand unless you know the Excel behavior deeply.

Best regards,

Soonthon Lupkitaro


Direct link Reply with quote
 

John Di Rico  Identity Verified
France
Local time: 13:57
Member (2006)
French to English
Watch out for fuzzies! Aug 16, 2010

Soonthon LUPKITARO(Ph.D.) wrote:

Yasmin Moslem wrote:
For your (and other colleagues') information, a "worksheet" does not mean another file; it means a "Sheet" in the same Excel file, "a worksheet with the same name". So changing the name of one of the sheets (in the same Excel file) with the duplicate name should help.

This is not a WFP error but an Excel error message. Many other CAT tools cannot translate the worksheet name [I need to edit after final cleaning of files] and they prevented the error message above. WFP waring message is not easy to understand unless you know the Excel behavior deeply.

Best regards,

Soonthon Lupkitaro


I think this is generally human error. When you have Sheet1, Sheet2, and Sheet3, once you've translated the first sheet name, when you come across "Sheet2", you get a fuzzy match from "Sheet1". If a user validates the segment, there will be two sheets with the same name.

Cheers,
John


Direct link Reply with quote
 

Joern Wennerstroem  Identity Verified
Local time: 13:57
English to Danish
TOPIC STARTER
Problem solved - for good this time Aug 16, 2010

Thanks to the latest posters for good and usable information about the nature of the problem. Also kudos to other colleagues out there coming to rescue me from my Sunday (as it were) woes

Direct link Reply with quote
 

Yasmin Moslem  Identity Verified
Egypt
Local time: 13:57
English to Arabic
Use Replaceables for higher TM matches Aug 16, 2010

Dear John,

This is a very good point.

Now, in WFP 2.4 (and later versions), when the only difference between two sentences is in numbers; in this case, you can check the option "Use Replaceables for higher TM matches" (Edit > Preferences > Translation Memory). This will automatically replace the numbers in such fuzzy matches instead of offering them with incorrect numbers from old translated sentences stored in the TM.

So, with this option checked: When you have Sheet1, Sheet2, and Sheet3, once you've translated the first sheet name, when you come across "Sheet2", you get an EXACT MATCH with the corrected number.

I hope this helps.

---
Best regards,
Yasmin Moslem

Wordfast Support Team
www.wordfast.com | www.wordfast.net


John Di Rico wrote:

Soonthon LUPKITARO(Ph.D.) wrote:

Yasmin Moslem wrote:
For your (and other colleagues') information, a "worksheet" does not mean another file; it means a "Sheet" in the same Excel file, "a worksheet with the same name". So changing the name of one of the sheets (in the same Excel file) with the duplicate name should help.

This is not a WFP error but an Excel error message. Many other CAT tools cannot translate the worksheet name [I need to edit after final cleaning of files] and they prevented the error message above. WFP waring message is not easy to understand unless you know the Excel behavior deeply.

Best regards,

Soonthon Lupkitaro


I think this is generally human error. When you have Sheet1, Sheet2, and Sheet3, once you've translated the first sheet name, when you come across "Sheet2", you get a fuzzy match from "Sheet1". If a user validates the segment, there will be two sheets with the same name.

Cheers,
John


[Edited at 2010-08-16 23:06 GMT]


Direct link Reply with quote
 

Soonthon LUPKITARO(Ph.D.)  Identity Verified
Thailand
Local time: 18:57
Member (2004)
English to Thai
+ ...
A very great suggestion Aug 17, 2010

Yasmin Moslem wrote:
Now, in WFP 2.4 (and later versions), when the only difference between two sentences is in numbers; in this case, you can check the option "Use Replaceables for higher TM matches" (Edit > Preferences > Translation Memory). This will automatically replace the numbers in such fuzzy matches instead of offering them with incorrect numbers from old translated sentences stored in the TM.

So, with this option checked: When you have Sheet1, Sheet2, and Sheet3, once you've translated the first sheet name, when you come across "Sheet2", you get an EXACT MATCH with the corrected number.

This is a great point many other CATs cannot provide. I believe that many of CAT users have frequent mistakes on this point. Tank again, Yasmin.

Best regards,

Soonthon Lupkitaro


Direct link Reply with quote
 

John Di Rico  Identity Verified
France
Local time: 13:57
Member (2006)
French to English
thanks Yasmin Aug 17, 2010

Thanks for the extra info Yasmin.

In WF Classic, there were "placeables" which fell into one of two categories: glossary terms or untranslatable elements (numbers, proper nouns, email addresses, etc.).

Does "replaceable" replace the term "placeable" or "untranslatable"?

Thanks!
John


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 »

Saving translated Excel-document from WF 2.4.0.1

Advanced search


Translation news related to Wordfast





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 MultiTerm 2017
Guarantee a unified, consistent and high-quality translation with terminology software by the industry leaders.

SDL MultiTerm 2017 allows translators to create one central location to store and manage multilingual terminology, and with SDL MultiTerm Extract 2017 you can automatically create term lists from your existing documentation to save time.

More info »



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