Problemi con reimportazione tabella doc a excel 2007
Thread poster: Stéphanie Argentin

Stéphanie Argentin  Identity Verified
Italy
Local time: 12:47
Member (2008)
Italian to French
+ ...
Oct 9, 2009

Buongiorno a tutti,

Per tradurre un file xls, ho importato una colonna (lunghissima di 11000 celle) su più documenti doc. Dopo aver usato Trados 2009 per la traduzione, devo ora reimportare le tabelle pulite sul file multilingue xls...Pero' non viene mantenuta la formattazione ovvero alcune celle vengono copiate su più celle! Quindi risultato, mi tocca copiare le celle (almeno quelle con più testo) una a una. Ho provato a controllare le proprità delle celle, ma non ho trovato nessuna soluzione.
Vi ringrazio in anticipo per il vostro aiuto.

Stéphanie


Direct link Reply with quote
 

Tony M  Identity Verified
France
Local time: 12:47
Member
French to English
+ ...
'soft returns' Oct 9, 2009

problemo con celle contenare invio 'soft', creare troppo de celle in DOC rispetto a XLS

buona fortuna!

Parli inglesi?

En effet, peut-être que ça ira mieux en français alors !

Oui, comme je voulais dire plus haut, si les cellules du XLS contiennent des retours à la ligne manuels, ceux-ci se transforment en retours normaux lors de l'exportation en DOC, ce qui crée donc un tableur sous Word avec plus de rangées que dans l'XLS.

Normalement, la meilleure solution consiste en remplaçant ces sauts de lignes manuels par des espaces dans l'XLS avant l'exportation, mais si c'est déjà trop tard, il va falloir regarder ce que vous pourriez faire pour les identifier dans le DOC, puis les remplacer, ou éventuellement fusionner les cellules concernées.

Étudiez bien les cellules à plusieurs lignes (s'il en existe !), pour voir si vous pouvez vous éviter au moins une partie de cette corvée !

Bon courage !

[Edited at 2009-10-09 13:48 GMT]


Direct link Reply with quote
 

Stéphanie Argentin  Identity Verified
Italy
Local time: 12:47
Member (2008)
Italian to French
+ ...
TOPIC STARTER
You can speak in English Oct 9, 2009

Thanks Tony M,

Let's speak in English.

Have you got a solution to this (big) problem?

Stéphanie


Direct link Reply with quote
 

Tony M  Identity Verified
France
Local time: 12:47
Member
French to English
+ ...
Oh, thank goodness! Oct 9, 2009

First of all, you need to see if that is in fact the problem in the first place; when i had the same problem (albeit in Office XP), I found that the column from Word was LONGER than the column in the spreadsheet when I pasted it back into the XLS; this was because XLS cells containing soft (= manual) returns had been converted into 2 or more cells in the Word table.

If this is your case, you could either go back and do a global search-&-replace for them in the XLS, then re-export and re-translate using your TM; or you could try and look for these cells in the DOC table and manually merge the multiple cells back into one; it really all depends on just how many cells are affected.

This has been discussed in an EN forum, where you'll find a bit more technical detail.

Of course, your problem may be a different one!


Direct link Reply with quote
 

Lori Cirefice  Identity Verified
France
Local time: 12:47
French to English
More info Oct 9, 2009

If I have understood the problem correctly, you may wish to try this solution on a copy:

If there were line breaks within the original cells before you pasted into Word, you will not be able to paste those cells back into Excel at the end of translation. Excel will think that each line break is a separate cell, resulting in a big mess!

Now calm down and try this – I have tested it and it works. Thanks to Carlos Montilla for posting this solution!

1) On your clean Word file, Find and Replace ^l with XCXCXC (or any other strange string of letters).
2) Now copy the text from Word and paste in Excel. Make sure you still have the same amount of columns and lines as the original text.
3) Using the Excel Find and Replace, replace XCXCXC with Alt+010 (with the cursor in the "replace" field, hold down the 'Alt' button and type the numbers '010'. The field will remain blank, it looks like nothing happened, but in fact, it's there – just blank)
4) Now you have your text back in Excel, with line breaks as they should be!

On very large files, you may need to split the process up into smaller chunks of text rather than doing it all at once, I have found that the F/R feature gets stuck when there are too many replacements to be done.

NB: when pasting back into excel, you may need to re-set fonts and remove borders and correct other minor formatting issues.

[Edited at 2009-10-09 14:02 GMT]


Direct link Reply with quote
 

Stéphanie Argentin  Identity Verified
Italy
Local time: 12:47
Member (2008)
Italian to French
+ ...
TOPIC STARTER
Thanks a lot ! It works !!! Oct 10, 2009

Je vous remercie tous les deux. Je viens d'essayer sur une première partie de mon fichier la méthode conseillée par Lori et tout a fonctionné correctement qu'il s'agisse d'éliminer les retours à la ligne dans le doc et de les rétablir dans le fichier excel !!

Vous m'avez bien aidée et surtout avez résolu un très gros problème.

Un gros merci encore bon week-end

Stéphanie


Direct link Reply with quote
 


To report site rules violations or get help, contact a site moderator:


You can also contact site staff by submitting a support request »

Problemi con reimportazione tabella doc a excel 2007

Advanced search






Déjà Vu X3
Try it, Love it

Find out why Déjà Vu is today the most flexible, customizable and user-friendly tool on the market. See the brand new features in action: *Completely redesigned user interface *Live Preview *Inline spell checking *Inline

More info »
Wordfast Pro
Translation Memory Software for Any Platform

Exclusive discount for ProZ.com users! Save over 13% when purchasing Wordfast Pro through ProZ.com. Wordfast is the world's #1 provider of platform-independent Translation Memory software. Consistently ranked the most user-friendly and highest value

More info »



Forums
  • All of ProZ.com
  • Term search
  • Jobs
  • Forums
  • Multiple search