Due to essential maintenance, access to Trados cloud will be unavailable on Saturday 30 August from 00:00 to 12:00 UTC.
  • State Verified Answer
  • Replies 6 replies
  • Subscribers 435 subscribers
  • Views 5084 views
  • Users 0 members are here
Options
Related

Translated text from excel restricted to 31 characters

Louise Taylor

In Studio 2014 I have this error message when I am trying to print or view the output file.

In the options for the file I have switched the Excel file option to - "Do not translate file names" but the problem persist.  

Can anyone help please?

Louise 
Rate translation
×
Suggest better translation
×
Moderator UI
×
  • Get AI Suggestion
Parents
  • 0
    Hi Louise,

    If you've already translated the worksheet name/s and it is the Target translation/s causing the issue, find and shorten it/them in the sdlxliff.
    Ticking 'Do not translate sheet names' after project setup won't change anything.

    If you ticked 'Do not translate sheet names' as part of project setup, that should eliminate the influence of worksheet name/s.
    However, the original source worksheet name/s should not be over 31 characters in any event*.

    If the original file/s' worksheet names are over 31 chars, I'd suggest you open the source file/s and reduce the length of those names.
    Then...
    - create a new TM (based on the old TM if it has customised settings),
    - update that new TM with the translated file/s

    Then, using using ONLY the new TM and the new source spreadsheet you've changed the worksheet name/s in...
    - create a new project (based on the old project if needed but with just the new TM)
    NB: this should be with 'Do not translate sheet names' ticked if you don't want to translate worksheet name/s
    OR with 'Translate sheet names' and 'Shorten the worksheet name in the translated file to 31 characters' ticked if you do.
    - allow that project setup to pretranslate the spreadsheet, which should give you a 100% translation that doesn't trigger the error.

    *It is Microsoft Excel who have imposed this rule so it is best practice to keep worksheet names under 31 characters as standard in any context.

    Hope this is what you were looking for,

    Ali :)
Reply
  • 0
    Hi Louise,

    If you've already translated the worksheet name/s and it is the Target translation/s causing the issue, find and shorten it/them in the sdlxliff.
    Ticking 'Do not translate sheet names' after project setup won't change anything.

    If you ticked 'Do not translate sheet names' as part of project setup, that should eliminate the influence of worksheet name/s.
    However, the original source worksheet name/s should not be over 31 characters in any event*.

    If the original file/s' worksheet names are over 31 chars, I'd suggest you open the source file/s and reduce the length of those names.
    Then...
    - create a new TM (based on the old TM if it has customised settings),
    - update that new TM with the translated file/s

    Then, using using ONLY the new TM and the new source spreadsheet you've changed the worksheet name/s in...
    - create a new project (based on the old project if needed but with just the new TM)
    NB: this should be with 'Do not translate sheet names' ticked if you don't want to translate worksheet name/s
    OR with 'Translate sheet names' and 'Shorten the worksheet name in the translated file to 31 characters' ticked if you do.
    - allow that project setup to pretranslate the spreadsheet, which should give you a 100% translation that doesn't trigger the error.

    *It is Microsoft Excel who have imposed this rule so it is best practice to keep worksheet names under 31 characters as standard in any context.

    Hope this is what you were looking for,

    Ali :)
Children