Studio 2014 - Excel - Post-Process with [SOURCE] file
Thread poster: d5t6

Local time: 06:52
Feb 12, 2014

Hi there !

Great community, I had to subscribe ... and ask a questionicon_wink.gif

As some of will remember, with SDLX, it was possible to delete a bunch of cells (NOT rows, NOT columns) in an Excel file, preprocess, translate, review and then POST-process the ITD against the COMPLETE Excel source file so you didn't had to manually insert what was deleted at the beginning.

I was wondering if something similar could be done with Studio 2014.
I tried to modify the XML within the SDLXLIFF file, but I got lost and anyway, I think Studio convert the XML from the XLSX file to his own XML structure and it just doesn't work.

And remember, I'm NOT talking about hidden rows or columns, I'm talking about DELETED content that doesn't need to be translated.

Any ideas ?

Thanks !icon_biggrin.gif


SDL Community  Identity Verified
United Kingdom
Local time: 12:52
I guess you have a couple of options... Feb 13, 2014

... that work in a slightly different way. There may be others, but these two might be helpful.

Option #1
Instead of deleting the cells colour them instead in excel and then set the colour as non-translatable so they are not exposed when you work. Once you save the target restore the colour and you’re good. This is explained here : (second part of the post)

Option #2
Delete the cells and translate as you do now in a Project. Once finished add the original file into the Project, pre-translate it and you’re done.
Or add both files into the Project at the start. Translate the first with the deleted cells, then pretranslate and generate the target file for the second.



[Edited at 2014-02-13 06:25 GMT]


Local time: 06:52
Studio 2014 - Excel - Post-Process with [SOURCE] file Feb 13, 2014

The colour trick is viable when everything (or almost everything) is the same colour in the Excel file, but I have clients who uses the whole rainbow palette in there so it's a bit painful to put everything like it was before.

I also thought about the pretranslation of the same, but complete file, but my problem is when I have to copy the source in other cells and hide/delete everything else around it.

Example: source text is in B25:B1225 and the translation must be in D25:D1225. And another bunch of source text is in E500:E2400 and must go in G500:G2400. Everything else must be deleted since it doesn't need to be translated.

I know my example is somewhat "extreme", but it happens more often than not with some of our clients, so doing the pretranslation trick will translate the source cells, which is a no-no. I could do it anyway and just copy/paste the source text over it, but that would defeat the purpose of what I'm trying to accomplish in the first place, which is keep it simple, like SDLX did in the past.

I guess I'm stuck with the colour trick...

Thanks for confirming my doubts. At least it's better than manually copy/paste everything backicon_wink.gif


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

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

Studio 2014 - Excel - Post-Process with [SOURCE] file

Advanced search

SDL MultiTerm 2019
Guarantee a unified, consistent and high-quality translation with terminology software by the industry leaders.

SDL MultiTerm 2019 allows translators to create one central location to store and manage multilingual terminology, and with SDL MultiTerm Extract 2019 you can automatically create term lists from your existing documentation to save time.

More info »
Manage your TMs and Terms ... and boost your translation business

Are you ready for something fresh in the industry? TM-Town is a unique new site for you -- the freelance translator -- to store, manage and share translation memories (TMs) and glossaries...and potentially meet new clients on the basis of your prior work.

More info »

  • All of
  • Term search
  • Jobs
  • Forums
  • Multiple search