Thank you for your answer. I would like to do so!

I just prepared an Excel test file, I added it to an existing project but impossible to translate it. This is what appears when I want to translate:

The text I insered for translation doesn't appear...

The text I exported looks like that:

The arrows show the places where normally a space had to be (after the end of every segment)

Simone Duverger

Can you also share a screenshot of the Excel file, and also confirm which of the various Excel filetypes in Studio is being used for this file.  Go to your Files View and you'll see it in there under the "File Type ID" column.

Here is the screenshot of a test with Excel:

The original text is in cell A and the translation in cell B. Normally, Studio should have replace the original text in cell A by the translation?

The other problem with the Excel file (that I didn't have any text to translate) is that before treating it with Studio, I changed the layout (p.ex. change the line when you come to the end of the column). My Studio doesn't obviously like treating Excel files when layout was changed.

I confirm: I'm using Microsoft Office 2007

(Sorry for my English, it's not my mother tongue :-))

I've found under "File Type Identifier" in the files view in Studio: "Bilingual Excel v. 1.0.0.0."

Is that right or must I look otherwise?

In the File type options of Studio I have the version 2.0.0.0. - Could that be the problem?

Simone Duverger

Simone Duverger said:

I've found under "File Type Identifier" in the files view in Studio: "Bilingual Excel v. 1.0.0.0."

This gets us closer to your problem.  This filetype requires that you specify the column for the source language and the column for the target.  So it would allow you to see column A and column B correctly in Studio for translation.  But to do this you would need to specify the columns before you create your project.  In here:

Since you are seeing nothing it makes me think you have different settings in here.

Finally after seeing your sreenshot, I found it - in "Bilingual Excel", I lookd at "Microsoft Excel 2007-2013" before!

I would like configurate it so that I don't have the source in the finally document, is that possible? I write "A" in the translation column and nothing in the source column? It's strange because I never touched this option before and I never had any problem...

PS: I don't want the source text to appear in the final document because what will be when I have further columns to translate??

Simone Duverger

Simone Duverger said:

I don't want the source text to appear in the final document because what will be when I have further columns to translate??

well... you would simply change the target column to be C and then D and then E etc.

Simone Duverger said:

I would like configurate it so that I don't have the source in the finally document, is that possible?

If this is the case then the solution is different.  You should not use the bilingual Excel filetype.  So disable it and use the monolingual filetype version 2.0.0.0 you found earlier.

You copy the source into the column you want the target to be and hide all the other columns.  Then when you translate only the one you want to be translated will be used and the translation will replace the source content in the target file.

Simone Duverger

Simone Duverger said:

I don't want the source text to appear in the final document because what will be when I have further columns to translate??

well... you would simply change the target column to be C and then D and then E etc.

Simone Duverger said:

I would like configurate it so that I don't have the source in the finally document, is that possible?

If this is the case then the solution is different.  You should not use the bilingual Excel filetype.  So disable it and use the monolingual filetype version 2.0.0.0 you found earlier.

You copy the source into the column you want the target to be and hide all the other columns.  Then when you translate only the one you want to be translated will be used and the translation will replace the source content in the target file.

Thank you for your answer, Paul! A last question: how can I disable the Bilingual Excel? There is no option to do that?

There still stays the problem with the lacking spaces when I export Word files. Could that be a "bug"? Another person told me that she had the same problem...

Simone Duverger

Simone Duverger

Simone Duverger said:

There still stays the problem with the lacking spaces when I export Word files.

You should have created separate posts for these problems because it's hard to mark the question as answered like this, and in turn hard for users to make sense of the thread if they have similar questions.

However... can you provide a sample file?  If it's a DOCX zip it first.

I'm sorry. firstly I posted for the problem with lacking spaces, than I noticed the Excel problem and I thought that there is a general problem with generating correctly all Microsoft files. If you look above in this discussion you'll find a screenshot I posted 5 hours ago.

Thank you for the screenshot. I unchecked the Bilingual Excel and I moved it below, but it doesn't matter - any time I add an Excel file, the File Type Identifier stays "Bilingual Excel". And I don't dare to remove it with the "Remove" button.

Simone Duverger

Simone Duverger said:

Thank you for the screenshot. I unchecked the Bilingual Excel and I moved it below, but it doesn't matter - any time I add an Excel file, the File Type Identifier stays "Bilingual Excel".

I think this article may be helpful for you:

https://multifarious.filkin.com/2012/12/18/tea-and-settings/

If you're adding a file to an existing project then you need to make the change in your Project Settings. If you're creating a new project then you need to make the change in your File -> Options OR your project template depending on how you created your project.

Simone Duverger said:

If you look above in this discussion you'll find a screenshot I posted 5 hours ago.

I saw this, but can I have a copy of an actual DOCX file that behaves this way?

A great THANK YOU, Paul!!!!

I unchecked "Bilingual Excel" in my project and in the exported file, the original text is now replaced by the translations (no source text anymore)!  :-) It's the version "Excel 2007" and it functions as I was used to on my old computer with Windows 7.

And for the missing spaces, it was exactly the same problem: it came from "Wordprocessing", I unchecked it and now, the File Type Identifier is "Word 2007" and I don't have any space problem anymore!

I thank you for the precious time you took to help me! :-)