How to lock empty segments in an Excel project?
Initiator des Themas: CafeTran Trainer
CafeTran Trainer
CafeTran Trainer
Niederlande
Mitglied (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: 09:58
ProZ.com-Mitarbeiter
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
Niederlande
Mitglied (2006)
THEMENSTARTER
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:

Moderatoren dieses Forums
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?






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 »
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! »