Excel cell ordering

Former Member
Former Member

I'd like to process cells this order.

1, 2 , 3, 4, 5, 6...

But, SDL Trados Studio refuses to follow my order.

It insists this order.

1, 4 , 2, 5, 3, 6...

 

Tips, Please

 

Microsoft Office Professional Plus 2013 splash screen with logo and Korean text.

Excel spreadsheet with cells numbered 1 to 6 in a non-sequential order highlighted in green.

SDL Trados Studio New Project window showing a single Excel file added to the project.

SDL Trados Studio Project File Type Settings window with 'Cells in rows and sheets' option highlighted in red.

Comparison preview of original and translated Excel sheets with mismatched cell order, marked with red 'X' icons.

SDL Trados Studio translation editor with cells numbered 1 to 6 in a non-sequential order highlighted in green.



Generated Image Alt-Text
[edited by: Trados AI at 3:07 PM (GMT 0) on 28 Feb 2024]
emoji
Parents
  • Nagoya Kita, you should define the 'by column' setting before you prepare your Excel file.
    Also important: the SpreadsheetML v.1 file type ID on your screenshot means that Studio applied the Excel 2016 filter to your Excel 2013 file.
    You have to move up the Excel 2013 filter (where this setting is available) above the Excel 2016 filter (where this setting is not available at all) and uncheck the latter.
    In your case the file type must read "Excel 2007 v. 2.0.0.0", but I can see it is "SpreadsheetML v.1" 
    This will work.

    Another question to SDL:
    It seems SDL chose to remove this superfluous feature for newer versions.
    Is it no longer available for Excel 2016? 
    Trados Studio file type settings showing SpreadsheetML v.1 selected instead of Excel 2007 v. 2.0.0.0.

    At the same time, if you try to select Excel 2013 filter for Excel 2016 files, Studio just will drop an error when saving target:
    Error message in Trados Studio stating 'Failed to save target content: Object reference not set to an instance of an object.'

    How do I select the processing sequence for Excel 2016?

    emoji


    Generated Image Alt-Text
    [edited by: Trados AI at 3:07 PM (GMT 0) on 28 Feb 2024]
  • Former Member
    Former Member in reply to Stepan Konev
    thanks Quick reply
    I will check it out

    And your question
    sorry, I do not know
    I do not have SDL Trados Studio 2019 and MS Office 2016

    regards
Reply Children