Technical forums » CafeTran support »
How to lock empty segments in an Excel project?
Thread poster: CafeTran Trainer
CafeTran Trainer
CafeTran Trainer
Netherlands
Member (2006)
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
Local time: 22:53
SITE STAFF
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.

CafeTran Trainer
 
CafeTran Trainer
CafeTran Trainer
Netherlands
Member (2006)
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?






Pastey
Your smart companion app

Pastey is an innovative desktop application that bridges the gap between human expertise and artificial intelligence. With intuitive keyboard shortcuts, Pastey transforms your source text into AI-powered draft translations.

Find out more »
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! »