Hi Shmuel Pfeifel (ShmuelPfeifel)

Interesting. I encounter the same. Target text is inserted into plain text boxes, but not into embedded charts. Linked objects are not translated, of course, they are independent files. But embedded charts show up in the Studio editor and the translated text is in the Word file. If I click on the object and select "Edit Data", the target text appears. Interesting also that you can't "undo", CTRL-Z this step. Once the target text is in, it's in. I just don't know whether there is an out-of-the-box method to do this with all objects in a document...

Studio tells me that there are embedded worksheets or charts and that I should refresh the objects manually in the MS Word application, but it does not tell me how to do that without clicking through each chart individually.

Daniel

Shmuel Pfeifel 

Unknown said:

Studio tells me that there are embedded worksheets or charts and that I should refresh the objects manually in the MS Word application

Perhaps the data in these objects has not been refreshed into the Word file (linked rather than embedded), in which case there is nothing Studio can do because there's nothing there.  Studio can extract embedded Excel sheets and charts but there has to be data in them to see:

The message suggests you refresh so this should mean you simply open the file in Word and if you have access to where the data came from it should all update automatically.  If you don't then you probably need to go back to your client with this question.

The article referred to earlier is almost three years old ;-)

Hello Paul

that does not quite explain what I am finding. Of course, linked content is not translated, it's in a totally different file. This whole issue is about embedded content. These are my file type settings:

This is the editor view:

This is how the Word file looks when I first open it (Some chart descriptions are still in source language, so is the text in the *embedded* Excel spreadsheet:

Then I right-click on the spreadsheet and select "edit data":

...and the target text appears:

It is a bit unpredictable when any why some text is immediately in target language and other text is in the source language still. I wonder where in the word file the source language would be stored? Does Word have bilingual capacity?

Here's my text file, should anyone feel the urge to find out:

Plain and embedded text.docx

Daniel

Good one :) Educating those I have (hopefully) some authority over is tough enough. And the client as well is not always in full control or knowledge of how the document was prepared. This is a very technical and specific (but material) issue. So, I would have appreciated a Studio alert that there is an issue of this kind in the document even if it cannot handle it. In long documents having this issue occur in page 57 inside a huge chart is really nasty.

Shmuel Pfeifel

Unknown said:

I would have appreciated a Studio alert that there is an issue of this kind in the document even if it cannot handle it.

That's easier said than done I'm afraid. How do we know it isn't supposed to be like this?  Documents are full of things we simply ensure can be faithfully saved back into the target document without the translator having to do anything.  How can we know if a user has used one of these things for something it was not intended and now wants it translated?  It's only software!

Unknown said:

Here's my text file, should anyone feel the urge to find out:

I just tested your file and see the problem.  I googled this a little and can see a few people have problems with updating embedded Excel tables in Word so my immediate reaction would be that this is a Word refresh issue.  I spent a little time trying to see if there was some setting that automatically refreshed embedded documents but could not find one... some ideas for macros that did this, but no setting.

I'll ask the question, but on the face of it I think this is a Word issue.

Unknown said:

Here's my text file, should anyone feel the urge to find out:

I just tested your file and see the problem.  I googled this a little and can see a few people have problems with updating embedded Excel tables in Word so my immediate reaction would be that this is a Word refresh issue.  I spent a little time trying to see if there was some setting that automatically refreshed embedded documents but could not find one... some ideas for macros that did this, but no setting.

I'll ask the question, but on the face of it I think this is a Word issue.