Hi Maria Rosaria Venosa ,

Maria Rosaria Venosa said:

I'm following Paul's suggestion as per the following link

Which one? The Glossary Converter or the Bilingual Excel file type both mentioned in the link?

Maria Rosaria Venosa said:

I'm getting the ST and the TT in a vertical sequence - both on the left and on the right hand-side (exactly the same, repeated).

This result may be due to the Bilingual Excel file type not being ticked or below the default Excel file type in your Project Settings:

Check also the column settings used if the Bilingual Excel file type is used:

Maria Rosaria Venosa said:

Then went to the Bilingual File Type (as explained by Paul in the link), the Excel is converted, but the final doc is not what I was expecting.

What were the results you’re getting?

The more information you give, the more chances we have to understand what's going on with your issue and give you the best possible solution.

Edited to be suggested as an answer.

Hello Jesus,

thank you for your answer. I was referring to the  Bilingual Excel file type. 

Everything seems to be clicked in the same way as in your screenshot.  I just tried again, same result. 

(I am not managing to attach a screenshot, otherwise I would have)

Thanks for your help,

Maria 

Maria Rosaria Venosa 

To insert a screen-shot on your post, use the Insert menu > Image/Video/File to upload the file, or even easier, just paste it with the usual shortcut CTL+V if the screen-shot is already in your Clipboard.

Hello Jesus,

here it is. I hope it'll make my issue clearer. Thank you for all your kind support.

Maria 

Hi Maria Rosaria Venosa ,

Sorry, I can’t see much on your picture.

You can create screen-shots in Windows by pressing ALT+PRNT SCREEN keys. Then you can edit the image in Paint for example to remove unneeded parts. This is what I do.

Anyway, I would need the same 2 screen-shots I posted above (with your project settings and legible ).

Hello, 

here it is again. Should be better now.

Thanks again for your support (and patience going through all the steps, really appreciate it),

Maria 

Maria Rosaria Venosa ,

ok, I know what’s going on: The Bilingual Excel file type has to be above the other Excel file types, like this:

The reason is that the first file type matching the file extension (xlsx in this case) of the list will be used. As you have it now, Trados Studio is using the default Excel type, not the Bilingual Excel one.

You can do that in 2 ways in your Project Settings:

• Select the Bilingual Excel file type and then click con the Move Up button as many times as needed to be above the other Excel filetypes.
• Untick the Microsoft Excel 2007-2019 filetype.

Now preview it. If the columns are well defined in the Bilingual Excel filetype (I can’t see it from your screen-shot), then everything will be fine.

Maria Rosaria Venosa ,

ok, I know what’s going on: The Bilingual Excel file type has to be above the other Excel file types, like this:

The reason is that the first file type matching the file extension (xlsx in this case) of the list will be used. As you have it now, Trados Studio is using the default Excel type, not the Bilingual Excel one.

You can do that in 2 ways in your Project Settings:

• Select the Bilingual Excel file type and then click con the Move Up button as many times as needed to be above the other Excel filetypes.
• Untick the Microsoft Excel 2007-2019 filetype.

Now preview it. If the columns are well defined in the Bilingual Excel filetype (I can’t see it from your screen-shot), then everything will be fine.

Hello Jesus,

nothing. I've moved the  Bilingual Excel file type up as you said, also Unticked the Microsoft Excel 2007-2019 filetype. Closed and reopened Trados. Tried again, same result. 

Maria Rosaria Venosa 

Sorry, I’ve just realized your screen-shoots: You need to make all changes in your Project Settings not in File > Options)

Hello,

yes, I did them in Project Settings, not in File-Options. 

Still same issue

Maria Rosaria Venosa ,

And in that Project Settings window, if you Browse for your XLSX file and press Preview, do you still get it wrong?

If so, please post a scree-shot of your Bilingual Excel file type Common settings (always in Project Settings). You already posted it, but it was cut-off). I guess you have set the right columns (A & B in my screen-shot)

For this Excel sample:

I get this Preview:

Hello,

no,  if I go to the Project Settings window and Browse for XLSX file and press Preview I see it fine! I see the IT on the left and the EN on the right. 

But then I go to Bilingual Excel - Browse - Preview, it's still messed up. 

What should I do? 

Maria Rosaria Venosa 

We are getting closer!

So if it is fine on your Project Settings > Preview, now you need to open the XLSX file. To do that, delete the file of your project and then add the same XLSX file. Prepare it as usual, an then everything should be fine in the Editor.

Maria Rosaria Venosa said:

But then I go to Bilingual Excel - Browse - Preview, it's still messed up. 

I don’t know where you are here. Anyway, try as I said before. Fingers crossed…

Hello Jesus,

so sorry, in the meantime, before I procced as you say, I see that the 'Bilingual Excel' option which we moved up is at the right position in Project Settings, but when I go to 'Options', 'Bilingual Excel' to convert my file, the 'Bilingual Excel' is again below the Microsoft Excel 97-2003'. I don't know why. It is ok in Project Settings though. 

?????

Maria Rosaria Venosa 

Maria Rosaria Venosa said:

when I go to 'Options', 'Bilingual Excel' to convert my file, the 'Bilingual Excel' is again below the Microsoft Excel 97-2003'. I don't know why.

Me neither , but regarding your issue you can really forget about the File > Options settings.

But that's how I open my Bilingual Excel file via the File - Options settings. I could go via a different route maybe?

Maria Rosaria Venosa 

Via Project Settings > Preview, as mentioned above.