Here we are, congratulating another release of SpreadsheetWeb!
We are excited to share some of the latest enhancements this month, aiming to improve user experience and functionality. Now, let’s start exploring them to increase the efficiency of using SpreadsheetWeb.
Dynamic Button Labels
One of the standout features in this update is the new support for dynamic button labels, which offers greater flexibility in button design and functionality. Users can now switch the label type in the designer to include fully dynamic text content. This update supports stub injection, allowing placeholder text to be dynamically replaced based on the context,user input, or formula calculations. Additionally, users can incorporate unique styles and images into the button labels, enabling a higher degree of customization and interactivity.
For example, consider an application demo with dynamic buttons (as shown in the screenshot). In this demo, the buttons are labeled with actions such as "Calculate," "Save," "Submit," "Print," "Email," "Next," and "Back." These buttons are color-coded for easy identification and usability. The application also includes a dropdown list for selecting the language, demonstrating the ability to adapt button labels and other text elements dynamically based on the user's language preference.
This feature allows developers to create more engaging and user-friendly interfaces. By using dynamic text content, applications can provide more relevant and context-sensitive options to users. For instance, a "Submit" button might change to "Submit Order" or "Submit Form" depending on the specific task, enhancing clarity and user experience.
Expanded Batch Calculations
Batch calculations now include a new mode for event execution. Although this mode is less optimized than the existing algorithm, it can run an extensive list of events. These events include document printing and saving, Excel export, goal seeking, and more. This update expands the functionality of batch processing, making it possible to handle complex workflows that require multiple types of events to be executed in sequence. Users who rely on automated processes for large datasets or complex calculations will find this new mode particularly useful, as it enhances the flexibility and scope of what can be achieved through batch calculations.
Additional Improvements
In addition to these features, we have made several minor updates to enhance overall functionality and user experience. One improvement is the addition of application type filtering on the application list page and API, making it easier for users to locate and manage their applications. Chart functionality has also been streamlined, eliminating the need for "dynamic column" features and simplifying the chart creation process. Furthermore, named range values can now be displayed as chart names during configuration, enhancing clarity and customization.
Another update involves location maps, which will now automatically ignore null values, ensuring cleaner and more accurate map displays. The system date and time columns have been updated to display relative to the user's time zone, providing more relevant and personalized information.
We have also made several user interface adjustments. These include enhanced datatable search and filter controls for narrow containers, a new "Clear all controls" snippet in the custom code designer module, and the inclusion of a tags column in the web service clients list. Additionally, the system now automatically refreshes the data page after the active record is updated, ensuring users always see the most current information.
In charts, we have expanded the Y-axis and size field options to include all types, not just numeric columns. The cell caching mechanism has been improved for better performance, particularly with large quantities of array formulas. Data page loading has been optimized by moving information fetching to the web services layer, resulting in faster load times.
We have introduced a new clearing functionality for workspace-specific SMTP settings, allowing users to reset to the default SMTP settings with a single click. The edit databases screen now shows the named ranges bound to one-to-many tables, providing more detailed information for users. Lastly, for batch calculations in the API Toolkit, the system now provides error details for failed requests, improving troubleshooting and support.
At SpreadsheeetWeb, we're constantly working behind the scenes to bring you the best tools and features, and we hope these improvements make your experience even better. Stay tuned for next month's updates- exciting new features and enhancements are on the horizon, and we can't wait to share them with you! Thank you for being a part of the SpreadsheetWeb community.
