Mobile menu

Hard return in Excel with SDLX
Thread poster: Jean-S�bastien FEREY
Jean-S�bastien FEREY
English to French
Jan 8, 2007

Hi all,

This is my first post on proz.

I currently have a project for a client (Excel) that is quite big in term of volume and I would like to use SDLX to transalte the Excel files.

My main concern is some cells have their text divided in several lines, each of them separated by a hard return carriage (Alt+Enter).

I tried to import the files with my SDLX segmentation rule set to paragraph, but it imports them lines by lines. Let's say a cell in the Excel files has 6 lines, all separated by a hard return carriage; the result I have with SDLX is 6 separated lines instead of a paragraph.

Does anybody know how I could create a segmentation rule that would alllow me to import each cell as a separated paragraph of text?

Thanks in advance for your help.

Seb


Direct link Reply with quote
 

Heinrich Pesch  Identity Verified
Finland
Local time: 16:13
Member (2003)
Finnish to German
+ ...
Did you try to export the cells to Word first? Jan 8, 2007

I never try to translate straight from Excel, instead I copy the cells to Word. When copying the translation bach into Excel I found it useful to use Open Office instead of excel, because it is more compatible with Word-files and you won't get any additional cells where there are linebreaks in the text.
Cheers
Heinrich


Direct link Reply with quote
 
Marta Fernandez-Suarez  Identity Verified
United Kingdom
Local time: 14:13
English to Spanish
I think there is no problem Jan 9, 2007

Hello Jéan

I've just done a test with a mini-Excell file in which I inserted two lines in one cell (by doing Alt Enter) and there is no problem. You do see two separate lines in the bilingual itd, but when you do a preview of the translated text, you'll see that the format is the same: two lines in one cell.

Please, write to me directly if you want to ask me my settings.


Kind regards,

Marta


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 »

Hard return in Excel with SDLX

Advanced search


Translation news related to SDL Trados





memoQ translator pro
Kilgray's memoQ is the world's fastest developing integrated localization & translation environment rendering you more productive and efficient.

With our advanced file filters, unlimited language and advanced file support, memoQ translator pro has been designed for translators and reviewers who work on their own, with other translators or in team-based translation projects.

More info »
Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »



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