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






Anycount & Translation Office 3000
Translation Office 3000

Translation Office 3000 is an advanced accounting tool for freelance translators and small agencies. TO3000 easily and seamlessly integrates with the business life of professional freelance translators.

More info »
Trados Business Manager Lite
Create customer quotes and invoices from within Trados Studio

Trados Business Manager Lite helps to simplify and speed up some of the daily tasks, such as invoicing and reporting, associated with running your freelance translation business.

More info »