Release Notes

The following page lists new features added to XLCubed, each release will also contain general bug fixes



  • Snowflake connection type
  • Allow user to configure compact/attribute-drill per axes
  • Change default axes for drillable attributes
  • Correct comments typo
  • Compact mode can error if nothing on rows
  • Allow batching of writeback update statements
  • Proxy: avoid error messages in login window after login complete
  • Default cell format as locked
  • y2 axis tooltip incorrectly being set as htmltooltip
  • Date slicer not updating initial value on load
  • Clicks not registered through a viewport with alignment set
  • User's default aspect not saving without user defined aspects
  • Turn off y2 axis in ibcs style and separate axes colours in taskpane
  • Add "Drill Category" menu item on web small multiples
  • Preserve slicer visibility, and apply workbook slicer visibility from XL3SetProperty
  • Fix Table tree slicers outputting 2nd column
  • Merged cell roots should not be in hidden columns
  • Updated Dutch translations
  • XL3Filter works incorrectly with a single row of data
  • Pivot views handle all invalid chars in column names
  • New chart taskpane background
  • Print PDF with connection needing SSO prompt
  • Enable database creation from command line
  • Click off chart should clear the designer new task pane
  • Calculated members can break DAX translations
  • IBCS comparison waterfall can use incorrect filters
  • Try most recent id when connecting to Azure AD
  • Compact axes can error for empty cellsets
  • XL3DoComment - always use the canonical unique name


  • Fluence translation updates
  • Update wixproj files to support per-instance MSBuildExtensionsPath32 for pipeline build


  • Fluence - improved translations and hierarchy hiding


  • Fluence commentry
  • Fluence Display now and preview
  • Fluence - hide sharepoint option when publishing


  • Fluence - Publishing fixes


  • Tabular translations
  • Fluence - tabular translations
  • Rename Fluence ribbon to FluenceXL
  • Fluence - add SSAS connection when connecting and improved auth for publishing
  • Fluence - log out option for data connections


  • Fluence publishing
  • Fluence querying
  • SSO handle logon during formulae
  • Fluence API updates
  • Fluence ribbon icon colours
  • Fluence excel logon
  • Fluence publishing logon
  • AppService installer: add support for multiple Host Names
  • Fluence authentication updates including impersonation on web
  • Fluence "Publish to xlcubedweb" option
  • Fluence - hierarchy metadata changes
  • Excel Installer: Add Microsoft.Identity.Client and Microsoft.Identity.Client.Extensions.Msal
  • Fluence connections should only be available to Fluence license keys


  • Retry socket reset errors
  • AuthToken retrieval can error in Azure app service
  • Relational writeback to use db context
  • Add support for retrying commands to Com data accessor
  • Kyvos updates


  • Attempt to handle "Enable macros" prompt
  • Add HANA session context and MDX catalog context
  • Add XL3DoComment formula
  • Fix freeze pane when hidden rows or columns are contained before the freeze pane.
  • Labelled Control auto-wrapping fix
  • Download prerequisites from HTTPS only
  • Initialise CubeCommentController outside of the QueryCanceller to avoid "Cancel Query" prompt
  • App Service setup, handle invalid connection better
  • App Service setup, more detailed error messages
  • Custom calcuations on SSAS perspective can error when edited
  • Check for mdx missing member mode support before setting command prop
  • Change to more generic error message for file not found on opening web report
  • Handle chart overlays on chart areas with no series
  • Dutch translations
  • small multiples on sql connections driven from a range can error on opening worksheet
  • workbook slicers with initial value changes can cuase multiple refreshes work workbook objects
  • Sql parameters used with "IN" clause whose names are substrings of each other can cause invalid queries
  • Add more properties to slicer bulk edit
  • Allow setting a border on an Excel camera object
  • Log XL3MemberNavigate exceptions
  • XL3MemberNavigate doesn't correctly store duplicate captions stored in the same cell
  • Calculated columns error if grid is in attribute drilling mode
  • If just one invalid member when "Manage structure changes" then it is not shown as invalid


  • Web: Extra startup tracing


  • White label updates
  • Allow ignoring invalid members when member text not validated
  • Acterys
  • Kyvos add support for MDX missing member
  • Copy member validation mode in grid/table settings
  • kyvos and acterys updates


  • Allow context menus in workbook slicer trees
  • Dynamic Charts - option to hide null/zero data labels
  • Dynamic Charts - allow total in center for pie/doughnut chart types


  • New drilling mode: Attribute drilling paths on grids and template tables. Move attributes to Rows to define drill path
  • XLCubedWeb: Excel Chart Datatable improvements
  • General Performance improvements
  • Grid & Table ribbon handles erroring grid better


  • Option to show report name in repository tooltip
  • Handle tel: and callto: links on web
  • Improved donut and pie label support on web
  • Donut chart better border support
  • Allow custom calculation form to open when there are sets that contain syntax errors
  • Business chart improvements
  • Web build now strong-named: Custom Extensions will need to be compiled for each release
  • Ibcs icon changes and rule renaming
  • SQL Query builder improvements
  • Default InlineMicrocharts for new installs
  • Dashboard titles icon picker


  • Azure App Service scheduling support
  • Fixed: "More fields" not appearing


  • Better support for deep links between grids and dynamic charts
  • Improved "Available Hierarchy" searching
  • New right-click options on Tree slicers to select parent/children
  • Auto-create subtotals in drilled template tables
  • Option to return a blank cell from slicers if no selections are made
  • xl3activecelladdress parameter when opening a report will scroll to the cell if it's unlocked
  • Custom business rule formats
  • Improved Excel start-up speed with unavailable azure-storage mapped drives
  • Better format support for "XL3Link" columns in relational tables
  • Parent Child hierarchies can be created in Pivot-Views (right-click on the hierarchy in the Pivot view setup to configure)
  • Support "Startup report" with "Browser-based login" on XLCubed Mobile
  • TM1 - better handling when no measure hierarchy defined
  • New option to apply filters/set functions to drill results
  • Waterfall dynamic chart - better subtotalling and label positioning


  • Fix issue with some Tabular Analysis Services columns and tables not begin shown
  • Better support for display folders in Tabular Analysis Services


  • Better support for some @ style formula on the web
  • Multi-tenant App Service logon will no longer use external website for authentication


  • PowerPoint export supports multi-lined cells
  • Option to control layout of Dynamic Charts used as small multiples
  • Preview: Updated Dashboard task pane
  • Better support for Azure SQL in the SQL Query editor
  • Highly formatted textbox support in FastPDF/Powerpoint
  • Improved Template Table UI


  • Azure connections: renew authentication tickets automatically in more scenerios


  • Preview Option - new Table properties form
  • Preview Option - Improved Dymanic Chart Taskpane
  • Preview Option - Template tables
  • Business rules
  • Improved FastPDF support
  • Dynamic charts support in viewports
  • Hana - option to disable connection pooling


  • Option to turn off XLCubed when editing PowerPoint-embedded workbooks
  • Slicer searching support for more data sources
  • LinkTo option on Dashboard Labels
  • Additional Writeback information available in Web API


  • Workbook slicers support DAX slicers


  • Improved support for Azure Analysis Services/Multi-Tenant OAuth setups


  • Multi-sheet printing: New workbook option to allow "Select All" of members
  • Report exports added to tracking in SQL Repository
  • Improved report loading speed of workbooks with many linked Workbooks Slicers


  • New formula: XL3TrackChanges
  • New formula: XL3Filter
  • New multi-sheet printing option to associate sheets to specific slicers
  • More dynamic chart options to support IBCS


  • FIPS algorithm compliance


  • SQL Repo: Support for case-sensitive server collation
  • Performance improvement loading workbook with lots of aliases
  • Option to alias Dynamic chart Column/Row name
  • Integrated legend now supports "drag" resizing
  • All web popup dialogs work better on small devices


  • Various new dynamic chart options to continue to support IBCS standards


  • Options to handle Data Validation dropdown submit behaviour
  • Slicer lists - allow adding of relational connection slicers
  • Advanced member search support in SAP Hana


  • Add business rules support for dynamic chart formatting
  • Dynamic charts - lots of new options to support IBCS
  • Incell Compare chart support in Grids


  • Add TM1 support for CategoryCompare waterfall charts


  • Support for SSO provider initiated logon
  • Option to disable specific dialogs in XLCubedWeb
  • Multisheet printing: options for sheets to include at start and end of PDF
  • New options in XL3ReportInfo
  • New formula XL3ConnInfo
  • Initial support for Kyvos connections


  • Improved french translation


  • Support for 2 PowerBI connections in one workbook


  • Release version - see Version 10 for a list of all the new features