Technical forums » CafeTran support »
How to lock empty segments in an Excel project?
Thread poster: Hans Lenting
Hans Lenting
Hans Lenting
Netherlands
Member (2006)
German to Dutch
May 12, 2023

Hello Igor,

How can I lock empty segments in an Excel project?

I tried to use QA Empty segments / filtering on \A\z (checkbox 'Reg.ex.' selected). All empty target segments are selected, but locking / replacing with a placeholder like '¤' doesn't work.

It is an Excel project that I have to proofread. I don't want empty cells in the Dutch column to get populated.

Thank you for detailled instructions!

Hans
 
Igor Kmitowski
Igor Kmitowski  Identity Verified
Poland
Local time: 18:07
Member (2016)
English to Polish
+ ...
QA and locking task May 12, 2023

Please try the following:

1. QA > Empty segments.
2. Task > Lock segments (on the filtered empty segments).
3. Turn off the QA filter.

Hans Lenting
 
Hans Lenting
Hans Lenting
Netherlands
Member (2006)
German to Dutch
TOPIC STARTER
Worked May 13, 2023

Thanks for your confirmation.

It was a big table, so CafeTran Espresso was slow with assigning the Locked status. LO Calc caused further slowdown – I should have been more patient.
 


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

Moderator(s) of this forum
Natalie[Call to this topic]

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

How to lock empty segments in an Excel project?






CafeTran Espresso
You've never met a CAT tool this clever!

Translate faster & easier, using a sophisticated CAT tool built by a translator / developer. Accept jobs from clients who use Trados, MemoQ, Wordfast & major CAT tools. Download and start using CafeTran Espresso -- for free

Buy now! »
TM-Town
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 »