Tag: conditional formatting

Introduction In this guide, we'll explore five methods to automate cell locking and unlocking, catering to both manual and dynamic scenarios. Whether it's manual intervention, central control, or dependency on specific parameters, Jedox offers versatile solutions to meet your data protection needs. Let's start. Manual Lock and Unlock: Empowering Users with Control Learn how to manually lock and unlock cells directly from the spreadsheet interface, giving users immediate control over data access and modification permissions. Central Control Button: Streamlining Administrative Oversight Discover the central control button feature, enabling administrators to swiftly lock cells across reports, ensuring data integrity and enforcing security policies. By creating a central setting element, we can access this value from any other report section or control dashboard. In this example, we will keep it on the same page. Automatic Lock Based on Time Parameters: Explore the functionality to automatically lock cells based on time parameters such as month, day, or hour. By setting predefined schedules, ensure data confidentiality and prevent unauthorized modifications...