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: 11:19
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?






Protemos translation business management system
Create your account in minutes, and start working! 3-month trial for agencies, and free for freelancers!

The system lets you keep client/vendor database, with contacts and rates, manage projects and assign jobs to vendors, issue invoices, track payments, store and manage project files, generate business reports on turnover profit per client/manager etc.

More info »
LinguaCore
AI Translation at Your Fingertips

The underlying LLM technology of LinguaCore offers AI translations of unprecedented quality. Quick and simple. Add a human linguistic review at the end for expert-level quality at a fraction of the cost and time.

More info »