Release Notes

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

V10

v10.0.121

• Add support for MFA when connecting to Azure Sql Server
• Add TableFilter selection type: https://help.xlcubed.com/Table_Filter
• Waterfall charts in PowerPoint & pdf
• Option to use inline Incell Charts in Fixed Excel Exports (clearer but needs font installed)
• Sort fluence folders alphabetically
• Multipart number formats with thousand dividers not correctly applied
• IBCS tables chart columns with missing formats can have previous format applied
• Dashboard sheet with workbook slicers can have initial size rendered with scrollbars
• Filter table selection item: add sort option
• Web formulae with "ResetAddress" don't work when the reset cell is on another worksheet
• New dashboard taskpane - hide/show all items
• New dashboard taskpane - items context menu
• Allow reference ranges on business charts
• Waterfall category direction/colour can be incorrect if expenses are +ve
• Waterfall chart fixes
• Business chart task pane can error when there is missing series data
• Freeze panes can be in wrong position
• Improved support for xl3lookup with >20 hierarchies
• Allow multi-drag of hierarchies in grid designer
• White label updates
• App Service - Azure SQL Authentication
• Fluence style update
• Improve handling of cell editing in sheets with merged cells
• Remove member selection type menu for measures on the web
• MDX formatting can be slow, timeout after 3 seconds
• Add "between levels" selection type to web UI

v10.0.118

• Demo sample data

v10.0.117

• Pivotview update

v10.0.116

• Fix hierarchy unique names in TupleArray-s
• Fluence api
• Odata fixes
• Small multiple task pane auto apply for agg setting
• OData network creds and waterfall tabular calc fixes
• Fluence tenant mapping

v10.0.115

• 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

v10.0.114

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

v10.0.113

• Fluence - improved translations and hierarchy hiding

v10.0.112

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

v10.0.111

• Fluence - Publishing fixes

v10.0.110

• 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

v10.0.109

• 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

v10.0.107

• 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

v10.0.106

• 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

v10.0.105

• Web: Extra startup tracing

v10.0.104

• 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

v10.0.103

• 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

v10.0.101

• 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

V10.0.98

• 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

V10.0.96

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

v10.0.94

• 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

v10.0.93

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

v10.0.91

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

v10.0.87

• 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

v10.0.81

• Azure connections: renew authentication tickets automatically in more scenerios

V10.0.79

• 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

v10.0.75

• 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

v10.0.62

• Workbook slicers support DAX slicers

V10.0.60

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

V10.0.57

• 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

V10.0.56

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

V10.0.55

• FIPS algorithm compliance

V10.0.51

• 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

V10.0.49

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

V10.0.47

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

V10.0.46

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

V10.0.35

• Add TM1 support for CategoryCompare waterfall charts

v10.0.34

• 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

V10.0.32

• Improved french translation

V10.0.31

• Support for 2 PowerBI connections in one workbook

V10.0.28

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