Release Highlights
Calumo Excel Office Client > Excel Batch Processing¶
Calumo now supports Formula Batch Processing in Excel to improve performance and reliability for large report calculations. This enhancement enables administrators to control how many formula cells are processed at once, reducing the chance of timeout errors, while also giving users better visibility and control during processing.
- Formula batching can be enabled via CALUMO Admin > Settings > Feature Settings by setting Excel Batch: Enable Formula Batching to true.
-
Configurable settings include:
- BatchSize: Number of formula cells per batch (default: 20,000; max: 200,000)
- MaxCellsToProcess: Maximum number of total cells processed in one report (default: 1,000,000)
- BatchTimeout: Execution time per batch, inherited from the existing
ClientTimeout
setting - These settings are editable via the Calumo Admin interface and do not require a restart to take effect.
- Reports exceeding the MaxCellsToProcess limit now trigger a clear warning message showing the total cells found, the configured limit, and suggested actions.
- During recalculation, users are shown detailed batch progress such as: “Processing CGetMDX batch 5 of 10 (5,000 out of 10,000 cells processed)”
- A progress bar shows total progress across all batches, and an estimated time remaining is calculated based on earlier batches.
- Users can cancel processing at any point via a new Cancel button. In case of errors, users receive clear and meaningful messages to help diagnose and resolve issues.This enhancement makes large report processing more efficient and transparent. Visit Calumo Excel Batching - Documentation to learn more about Batch Processing in Excel.
Apps Access Control Improvements¶
Enhanced security by restricting app visibility for non-admin users by default.
- Apps are now only visible to administrators unless explicitly assigned to a user group.
- When an app is assigned to a group, both the group members and administrators can access it.
- If no group is assigned, the app remains exclusively visible to administrators, improving control over app access.
Apps Permission Denial Messaging¶
Improved user experience by providing clearer messages when access is denied for Apps.
- Users who try to open an app they do not have permission for now see a clear message: “Don’t have access to App, contact Admin for access.”
- This replaces the previous generic and confusing error message: “An unrecoverable error has occurred.” The change helps users understand their access restrictions and encourages them to contact administrators for assistance.
Visual Beta > Visual Report Loading Fix¶
Opening visual reports in Calumo is now smoother and error-free. Previously, some users saw error messages or a loading issue when opening reports in Visual Beta. This has been resolved, and reports now open as expected without showing any error notifications.The update improves reliability and gives users a more seamless experience when working with visual reports.