This May 2024, SpreadsheetWeb Hub unveils two exceptional features – Interactive Execution and AzureAD Single Sign-On.
Interactive Execution: A New Way of Interacting with Data
Until now, SpreadsheetWeb applications were limited to accepting static values. With the introduction of interactive execution, users can now input dynamic variables using formulas. For example, users can input straightforward mathematical operations such as =10*20, or engage in more sophisticated statistical modeling with formulas like RANDBETWEEN(1,100). This latter formula is particularly useful for simulating different scenarios, as it allows for the generation of random values within a specified range. Furthermore, the ability to reference other cells or named ranges within the Excel file when writing formulas adds a layer of depth and customization. This capability ensures that formulas are not just isolated calculations but can be integrated with the existing data structures in the user's spreadsheet.
One of the most practical uses of this new functionality is in testing environments, where developers and testers can randomize inputs to evaluate how applications perform under various data conditions. In API-based applications, this feature becomes even more critical. APIs that interact with SpreadsheetWeb can now leverage dynamic data inputs.
This feature is exclusive to private cloud and server licenses, ensuring that advanced computations remain secure within the organization.
AzureAD SSO Support: Simplified Access Control
Institutional access has become much easier thanks to the adoption of various single sign-on (SSO) technologies. In addition to Okta, SpreadsheetWeb now supports AzureAD SSO, making it significantly easier for users as they can authenticate using their Azure account without setting a separate password. Setting up AzureAD SSO is straightforward: system administrators or workspace owners need to send invitations to users via their AzureAD email addresses. Once confirmed, users can log in using the “Secure Login with Azure” button, similar to logging into Okta. This feature is restricted to private cloud environments, just like the Interactive Execution, ensuring secure access. After logging in, users' access rights determine what they can see, usually limited to only certain applications initially.
