Release Notes

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

V2311.1

• New UI improvements and fixes
• Axis set editor
• General security fixes
• Powershell Cmdlet - Get license info
• App service - support printing viewports onto incell charts
• Scheduling allow new Exchange connections
• Fixed: Dashboard Label with title gets scrollbars
• Fixed: Grid title replaces the first member when headers are hidden
• Dax designer doesn't show member picker when hierarchy on Filters
• Fixed: All hierarchy member choice disappears from grid when a new filter is added
• Fixed: Template table 1 not showing column headers
• Fixed Slicer aliases ignored
• Improved logging
• Allow SSO logon for PBI xlsx connection files
• Improved support for legacy(2000) Cube files
• SSAS Azure unauthorized exceptions can be missed
• Dashboard title button does not output on web
• Hierarchy editor not showing member aliases
• Waterfall chart with no series errors
• Kyvos remove sso retry with basic auth
• Datalabel background not applied on reversed waterfall charts
• Variance chart labels wrong way round
• Axis tuple switch error if grid is hasn't been executed
• Dashboard item captions don't update when items are edited
• Formatting issue if format sheet selected and pick Accounting
• Import Items into Web show import progress
• Fluence: Don't cache global variables
• Variance waterfall - split by doesn't keep new hierarchy
• Fixed: Template table indentation issue on Web
• Add SQL Server connections (relational) to Powershell
• Download to Powerpoint using XL3ReportType
• Rename XLCubed dashboard
• Error when editing picture link
• Connection mapping: Support mapping from integrated to un/pw
• On-premise Embedded scheduler - can't connect to azure as
• Override border colour not working in dynamic chart
• Slicer selection doesn't update chart on pivot view
• Remapping hierarchies on a connection for a grid with gap calculation errors

V2310.1

• New Feature: Report Publication Workflow Process
• Grid Designer - Axis editor for asymetric selections
• Store detailed information about each 'SendTo' run
• New UI - bug fixes and enhancements
• Security updates
• Freeform report ribbon + improvements
• New Template table UI
• Fix reversion Icon order on In-cell chart formula
• Fixed: Grid Chart added on the web is printed in the upper left corner
• Improve Button Slicer Rendering
• Added {gridlastrefresh} option to grid title
• Propagate to new workbook should keep formatting
• Convert Incorta grid to formula can give wrong measure aggregation type
• Allow sql: directly in xl3lookup for incorta
• Add logging to browser initialisation
• Incorta formulae using measure columns as filters give blank
• Incorta SSO change
• Improve anaplan SSO error message
• Tabular SSAS gives incorrect error when session invalidated
• Basic auth doesn't prompt after log out
• "Message" editing controls fix
• Combo tree slicer on web - Scroll button moves after resizing slicer
• New UI: Publish complete notification missing
• Fluence drillback: handle jsonDetails
• Fixed: Unable to manage multi-sheet printing schedules
• Fluence drills on filters cause error
• XLCubedWebDashboard should use XL3LocaliseFormatString for date formats
• Fixed: Basic authentication, Publisher - 2 login prompts
• Web Ad-Hoc Add toolbar items
• Fixed: Kerberos-alternative doesn't work with embedded scheduling when using Windows or Basic authentication
• ImpersonateJWT - allow custom effectiveuser claim & set SQLContext
• Fixed: Member properties are lost after Edit & Remap connection
• Icon Text incorrect in published FluenceXL reports
• Fixed: Create Powerpoint chart - charts don't render correctly

V2306.1

• Rebranded to FluenceXL
• New UI improvements & fixes - Web & Excel
• XL3Link - option to reload current workbook
• Add support for SSO on Anaplan connection
• Can't apply set function to column aggregate measures
• Option to insert real charts into Powerpoint export
• Connecting to Azure Analysis Services in a tenant that isn't the user's home tenant fails
• Embedded scheduling: allow anonymous SMTP server connection
• Bubble charts can error with customized tuples
• Allow role management via Web UI
• Error with calc grid column on Fluence-based grid with no columns
• Incorta set pageSize as well as maxRows
• Security fixes
• Fluence - Add mdx functions for tags
• Cube Comments error with multiple filters
• Client executed MDX calc improvements
• Option to set default member search type
• Ability to refresh all the objects / Grids of the current sheet from the menu
• Add the capability to sort Fluence data by member property
• Grid designer - subcube button should be disabled for some connections
• Polygon data label names not resolved on web
• Embedded scheduler support Named User Licenses
• Printing conditionalformat icons on the web can error
• Fluence - Drillthrough
• New formula: XL3LastComment - returns most recent comment for data slice
• Multisheet printing not showing slicers
• Azure authentication from Excel required too many Admin approvals - Analysis Services, SQL & Power BI permissions now optional

V2305.1

• Moved to .Net Framework 4.8
• Allow adding a DAX: measure to a dax table by picking an Excel cell
• Enable multi select on the treeview slicer search results
• XLCubed copy sheet improvements
• Grid Calc with xl3Link can error
• Excel Sparklines can error on different locales
• New UI: Commenting, Breakout
• App Service: Allow managed identity for Repo DB access
• Writeback member formatting erroneously applied
• SSO: Custom procedure customise identity claim
• Add placement option to Slicer lists
• Incorta SSO integration
• Excel treemap chart causes publish error
• Support for Excel validation lists in Writeable grids
• Fluence: Member lookup by Key
• Proxy Server: Role/impersonation optional
• Smallmultiple formatting limit by Name
• Support replace 0 with null for Fluence connections
• Anaplan API update fix

V2304.2

• Proxy server performance improvements

V2304.1

• New Version numbering: YYMM.Release.Build.0 where YYMM is release year and month
• Extended new preview UI to include: breakout, comments, tabular queries, scheduling overview
• Add parameter to hide the workbook slicers pane when activated through XL3WebReportLink
• Kylin support
• Add InterSystems support
• New Web Portal UI - add zoom in/out
• SAI 360 authentication support
• Scheduling: Handle malformed email errors better
• Support calculation group format strings for Tabular SSAS sources
• PowerShell Cmdlet - Export and Import XL3RZ files
• Fluence - Open in new Tab is not showing correct name after rename
• Excel can hang on OnUserPreferenceChanged message
• Unauthorized (401) error when opening Fluence Favourites
• Fluence MDX Calc - better handling of divide by zero
• Template tables - add support for calculated columns
• New web portal:support "Back and Forward" change history
• New UI: Ability to move folders in the publisher screen
• Add an alignment option for slicer lists
• XL3Link new type with extra calcs
• Add Item Footer option on Dashboard sheets
• Add a filter/button option to the workbook object menu to change the view from per sheet to object types
• New web portal: Make side bar color configurable
• Fixed: Comment Timestamp issues in FluenceXL portal
• Improved XLCubed Proxy error handling
• Support Number format in non-pinned Grid Calculations
• Fluence dimension mapping uses type not role
• Edit table properties - Error getting query from Excel Range
• Fixed: Blank comments can error
• Fixed: Empty sql dynamic charts can error when data is returned again
• Incorta calcs on fields outside of hierarchies lose calcs
• Fixed: Multisheet - first slicer cell output not handling value type correctly
• Member Set from Excel to ignore empty rows / columns
• Intersystems support calculated dimensions
• Fixed: Drill on excel set can use incorrect dimension index in excel
• XLCubed Mdx Aggregate errors if one of the members isn't returned due to non-empty behaviour
• Better handling of objects that overlap frozen pane by a few pixels
• Minor performance improvements in Excel Grid rendering
• Incorta - add support for xl3membernavigate()
• PowerShell - Allow output directly to Azure Store Blob
• Improve handling of infinitely recursive MDX calcs
• XLCubedWeb: New "Send to" scheduling options for outputting to Azure blobs
• Drill down on web with named set only possible with right click first
• XLCubedWeb App Service - OpenID authentication support
• Change incorta schemas description
• Scheduling: Malformed email address shows stack trace to user

V10

v10.0.157

• Fluence repo - Favourite linked to delete folder causes error on publish form
• Fix case of Excel crash on exit
• Fixed: removePartialTextMatches() when resizing iFrame
• Add option to use Row Heights defined on the format sheet
• Web option to throw error if EffectiveUser has not been set on a connection
• Formula can fire too early when loading workbook xml - causes access issues when using App Service
• Fixed: Workbook option 'include page showing selections' not working
• Incorta data reading misses calling cells overload
• Added Aspect support in New Web UI
• Add support for {DimensionTable.{Global.ConsolDataModel}.Entity} in Fluence SQL Queries
• Update Dutch translations
• New UI: various updates sna dfixes
• SQL and Excel dynamic charts should use old properties form
• Data entry Workbook option: Save post & pre writeback triggers
• Data Entry Settings - enable for standard XLCubed
• XL3RunSqlProc2 can fire twice, no table arracy second time
• XL3Link parameter for A target attr
• Web can run calculations before connections have password
• Option to turn of borders from Workbook Slicer Pane
• Printing workbook with invalid Array formula fails
• Make grid sort context menus more consistent
• Chart doesn't pick up measure format in variance report if driven from custom item
• Improve dashboard item deleting
• Anaplan grids can reformat numbers after writeback
• Smallmultiples hidden on web when placed in certain frozen panes
• Allow and ignore blank member properties in XL3SetProperty()
• Embedded scheduler: connect to Azure SQL and PowerBI
• Configure embedded scheduling on on-prem XLCubedWeb
• Track Active Cell doesn't work on calculated members
• SQL boolean parameters not correctly converted to strings
• Fixed Chart error on web: Cannot read properties of null
• Add MDX logical functions
• Anaplan cube picking improvements
• Stacked charts with hidden labels hide all labels
• Add dynamic chart null checks
• Allow disabling of Cancel Query dialog
• Incorta fixes and improvements
• Incorta add support for session sql calcs
• Drill relational tables - add expand/collapse all button support
• Relational tables - option to drill/group based on indenting field
• Support scroll wheel in frozen panes on web
• Edge Data validation drop down fixes
• Remove IE from forms login handling
• Default new workbooks to "Use Embedded images"

v10.0.156

• Default to new UI for new installs
• Default to embedded image publication on new workbooks
• Fixed regression issue with XL3Filter/XL3Trackchanges being passed to formulae

v10.0.155

Internal

v10.0.154

• Fluence Web - Support text writeback
• Grid Actions - custom right-click menu items
• Auto handling of typed hierarchies in Fluence between tenants
• Prep for Fluence formula query optimisation
• Web: Change Run sql order to avoid conflicts with XL3Lookup
• Option remove slicer if dimension not present when opening workbook
• Add ability to pick descendants of Level in member selector
• Drop Internet Explorer Support
• Fixed: Chart colour disappears on web dashboard sheet when clicked
• Group members doesn't show range name when on filters
• Improve Anaplan formula performance when multiple measures
• Change sql command timeout UI
• IsEmpty function support in custom calc support for Fluence & Anaplan
• Fixed: Validation drop downs disappear in Edge
• Bold Column/Row labels don't size correctly on web
• Percentage bar format in second breakout grid resets to default
• App Service: Auto restart CubeBuilderShim
• Fluence: Option to limit tenants to match URL
• New UI: General improvements & fixes
• Dynamic Charts manual layout option
• Incorta white label updates
• Print object option for viewports
• Grid "Auto size rows" option

v10.0.153

• Item title button support large range copying
• Support HierarchiesOnHeaders in XL3SetProperty for slicers
• Allow changing of Dynamic Chart connections
• Error on web when grid has measure with null default format
• Anaplan can have dimensions with no members if you have no security access
• Save to excel using direct link fails
• Asymetric drill errors on Kyvos
• Fluence writeback issues fixed
• Connection made before connections are configured on web when using a cell parameter created with a named range
• Dynamic Charts can refresh during Excel recalc before any format sheet formulae have calculated
• Multiple writes in a transaction on Fluence don't overwrite properly
• Improved Fluence debug messages
• Incorta - Allow nesting of measures
• Fix regression on encoding of some styles
• Anaplan support for retrying writeback
• Upgrade from ADAL to MSAL
• User Aspects not saving on some reports
• Embedded toolbar via Javascript API errors because of missing DataEntry div
• Scheduler: Handle @@XL3TOTALPAGE@@ in pdf output
• App Service installer Manual mode gives object ref not set
• Veracode scan updates
• Give proper error when cube is unavailable in reports with Slicers
• Abandon App Service session when anonymous and redirected to login
• Improved error for XL3WebReportLink pointing to missing report
• Support different first page setup
• Excel freezes when opening file with viewports on dashboard sheets
• Update jquery-ui & jQuery version
• New UI Preview: Dimension slicer & Table Designer
• New UI Preview: Named ranges in new grid editor UI
• New UI Preview: Connection Form
• Writeback that requires old value changes active cell

v10.0.152

Internal

v10.0.151

• Resolved issue with asymmetric drilling
• Support asymmetric drilling on Kyvos data sources

v10.0.150

• Fluence writeback update - Restore cursor after writeback

v10.0.149

• Spark Sql connector
• Fixed: Writeback on Fluence doesn't include default members
• Fixed: Named user licensing - creating User table entry even if user doesn't have access
• Centrally disable workbook storing of Credentials
• Specify Locale on startup for addin conflicts
• Fixed: Fluence Portal - Aspects not saved
• Allow insert tables for Kyvos and Incorta
• Template Tables: add Range picker in formatting selector
• XL3SetProperty should allow using captions if no unique name matches
• Update to new PowerBI xlsx connection files
• Fixed: Indenting formatting issue
• Update Fluence naming conventions
• Fixed: Custom calcs not registered for fluence sql pivot tables
• Anaplan tenant and writeback improvements
• Can't add calc columns to aggregate measures
• Outlier grouping can error on waterfall chart against Tabular SSAS
• Add ability to capture member expression from metadata
• Task pane always displays layout of the first grid (new UI)
• New UI: Grid designer advanced selections & Member properties
• Add Rendering support to PowerShell
• Support Trusted Publisher via group policy
• Workbook Aspects don't reset slicer selections to default (all)

v10.0.148

• Scheduling service startup hotfix

v10.0.147

internal only

v10.0.146

• New Web portal – updates and fixes
• New Report Designer – support for member properties and other improvements
• Allow DAX: in XL3LookupTabular()
• Fluence – support GlobalVariables for Model name
• Allow escape to cancel writeback editing without a warning
• Latest IBCS standards updates
• Fixed: Converting Qlik grids with dynamic measures errors
• Data driven dashboard labels don't update on the web
• Deal with ! in sheet name when parsing addresses
• Fluence Tag reporting enhancements
• Handle blank Favourite Names
• Incorta - adjust page size based on current position
• Incorta default member caption should be blank
• MdxCalcs - genarate blank tuples as necessary
• Measure search doesn't include calculated members
• Member tree allow loading "More" into top level
• XLCubed Powershell Cmdlet for automated report deployment/management
• Slice highlights with blank members not handled correctly
• Table properties - hide some tabs for Incorta
• TM1 custom calc sets can error
• Performance improvement for Workbook slicers – stop additional refreshes
• Fluence – added “Level” property
• Incorta add measure filters on tables, custom query on tables and improve timeout handling
• Update Maps to use embedded Edge to address Google dropping IE support
• Fluence: Web-based Model entry support
• Enhanced logging capabilities

v10.0.144

• Updated “Preview UI”
• Grid Designer
• Publishing
• Web Portal
• Web Adhoc
• "Clear and select members" bug fix
• Business template table support for Fluence and Anaplan
• Business charts turn off non-empty series to correct comparisons made
• Template tables - don't flag rows as subtotals if member has no children
• Commas in MDX statements in formulae can be replaced in non-US locales after pdf printing
• Support MDX Calculations in Fluence & Anaplan
• Hide levels MSAS MDX doesn't always work when drilling down
• Misbehaving datasources can cause favourites to be deleted
• XLCubedWeb: Anti CSRF checks + additional adhoc access checks
• Powerpoint: Improved incell chart handling in grids
• Fluence relational - handle quoting of reserved words
• Fluence EffectiveDate - default to today
• Add XL3SetProperty support for member properties for Grids
• New formula XL3HierarchyRoleLookup
• Proxy: Support SSAS Writeback
• Chart taskpane colors checkbox
• Proxy: Improve proxy with inaccessible/invalid connections
• Add new function XL3DefaultMember()
• Add DefaultMemberType to grids
• Add support for #tag to Fluence range selections
• Fluence improve #tag support in range driven reports
• Viewport backcolour not applied to entire dashboard item
• Multidimension Query - fix default members and add more search properties
• Chart taskpane - category axis reverse order checkbox
• Implement selection level for cube tree slicers
• TM1 formula mdx fix
• Fluence: Fix for publishing when user only has access to one tenant
• Fix for XL3Link form inserts formula not cell address
• Allow drilling on smc category labels for lolliplots
• Updated dutch translations
• Fluence data entry - support highlighting by tag in grids
• Fixed: Workbook slicer pane can not have its bg colour set to "none"
• Custom grid highlight ranges and writeback controlled by cell locking
• Fluence comment web server fix
• Powerpoint export: Closer match Excel character spacing
• Powerpoint export: Better viewport support for inline incell charts
• Incorta support paging members
• Workbookslicer visibility issues
• Fixed: Fast PDF regression
• Incorta Scheduling support
• Incorta slicers fix

v10.0.138

• Allow clearing of auth tokens on web
• WebView2 - Fix apply IBCS issue
• Clean up streams after use
• Scheduling: save as Excel can get wrong file name when dynamic
• App Service: Embedded scheduler fails with connection mapping enabled
• New feature: Fixed header rows in Grids
• Change default for "Disable unrelated columns in Tabular Designer" setting to false
• Fix mdx syntax highlighting when query ends with ] and no new line
• AppService installer: handle FTPS-only app services
• Fixed: Quick search for measures doesn't work
• Add Axis level custom queries for Incorta and Qlik
• Pick range doesn't always hide all forms
• Fluence metadata adapter can error on some published reports
• Kyvos support for member key from range
• MultidimensionalQuery calculations initial implementation
• Reading function xml can error on empty elements
• Fluence - support hierarchy aliases from properties
• Preivew feature: improved web adhoc ui
• Qlik paging for spaces and apps
• Fix InsertFavourite for Fluence connections
• Fix fluence query text for advanced selections

v10.0.137

• Fluence model data entry
• Incorta updates
• Default implicit measures on in new installations
• Fluence native member alias support
• Qlik improvements
• Incorta enhancements
• Qlik UI captions
• Add flex drilling on levels to non-mdx data sources
• Add alias support to Anaplan,Incorta,Qlik

v10.0.136

• Qlik updates
• Handle 307 redirects with Proxy server auth
• Fix regression of XL3RunSQLProc

v10.0.135

• Improve handling of waterfall comparisons on expenses/revenues
• Improve handling of line breaks with words longer than a cell
• Fix error with mixed compact axes and grid calculations
• Fix for hang during comment formulae authentication check
• Dynamic chart legend improvements
• Add %distributionlist% placeholder to scheduling
• Grid comment support in viewports
• Member search support multiple criteria
• Allow MDX: when defining member sets in Excel
• Proxy: Relational parameters
• XL3Jsonify Formula
• Scheduling: Use Distribution List name instead of Guid when using %groupname%
• TM1 web auth improvement
• Publish connection form improvement
• TM1 web auth improvements for ibm cloud sources
• Don't retry logon attempts when un/pw is invalid
• Fluence Writeback improvements
• TableFilter may not update correctly on web when driven from range
• Duplicate field names cause pivotview to error
• Fix for hidden headers for Table
• Improve XL3LookupTabular performance
• Restrict business tables to valid connection types
• Qlik cloud handle moved Apps
• Create message can crash with invalid textbox in master template
• Qlik performance improvement and setting removal
• CubeBuilderShim, fix issues and improve performance of App Service PivotViews
• Fluence tree slicer drilling
• Optional WebView2 dynamic charts
• Fluence Model View Support
• Business table with template columns driven from range doesnt update on web
• Improve Qlik connection item listing
• Fluence API - Intrinsic Property support
• Improvements to switching between MSAS and API Fluence connections

v10.0.133

• Allow editing of grid calcs when axis set driven from a range

v10.0.132

• Add extracted Scintilla binaries to Excel installers

v10.0.131

• Incorta - add support for picking attr hier as measure
• PowerBI Premium powerbi:// web auth fix
• Incorta int type fix

v10.0.130

• Fluence Pivotview support
• Propagate Forumla creating duplicate grids
• Handle Int32 in PivotViews
• Fluence Table slicer support & Fluence writeback phase 1

v10.0.129

• Anaplan improvements and flunce set function support
• TM1 OAuth improvement
• TM1 Auth improvements for HttpOnly cookies
• TM1 improve auth when at server vs db level
• Anaplan - Support pivoting for cellsets > 2D
• Anaplan Improve token refresh

v10.0.128

• New grid taskpane
• Dynamic charts - copy animation settings
• Template tables - option to compare vs Forecast for IBCS templates 2 and 4
• Make table filter selections editable
• Init Member Search UI with existing config
• Qlik compact mode with nulls fix
• Tooltips on Picturelinks
• Edit Picturelink added to Excel right-click menu
• Better resizing of Dashboards when XLCubed Taskpanes are shown/hidden
• Localise dynamic charts in excel
• Reset slider in small multiples when categories change
• Show cube caption not name in connection dropdown
• Clear progress spinner if listing cubes errors
• Qlik - add support for using variables as measures
• Order schedule execution according to next run time
• Anaplan - support layout with only columns defined, only add view members once in a crossjoin, App Service installer: Always use slashless Url
• Fluence scheduling groundwork
• Anaplan - improve connection handling and security
• Excel installer: include WebView2 bootstrapper
• Improved Member Selection when adding business rules
• "Delay control creation during load" option
• Fluence API - allow partner hosting
• PowerBI Auth update on Web
• Whitelabel updates
• Fix list method overriding

v10.0.126

• Fluence style - increase multi-select slicer min width
• Delay in Selected items updating when setting "Initial selection" in Excel
• TM1 Enhancements - cube picker and writeback
• Business template tables allow comparing to forecast
• Added blue headers to some options
• Initial Fluence relational support
• Hide incell chart formulae for template tables
• "TheSans" better datalabel handling in Incell Chart
• Updated XL3Lookup, CubeSliceEditor and add default member selection in xl3lookup in grid
• Include Microsoft.Web.Scintilla in Excel setup
• Include Microsoft.Web.WebView2 in Excel setup

v10.0.125

• Multiselect in Available Hierarchies
• Chart defaults and save/load styles
• TM1 cloud auth fix
• Table filter improve blank handling
• Some chart settings not being copied
• Formatting fixed for Tables when Headers are hidden.
• Reverse formats option of XL3SparkBar
• Add chart axis option - auto min/max sets to zero
• Speed up member tree view by enabling virtualization
• Support Total page count on FastPDF output
• Breakout % column to match grid font size
• XL3Members should drill up even when they have very long member unique names
• "ignore hierarchies" in comments no longer need to be the last dims on filters
• TM1 auth and view fixes
• Line charts with current month business rule error
• Remove current sample reports and link to new ones
• Chart taskpane - colour field in not visible and error changing chart type with xyz values
• TM1 - test server ip address and host for connectivity
• Fluence commenting
• Support illegal characters in Connection Mapping for sql repo
• Dutch translations
• New Visual styles (Preview)
• Option to change XLCubedWeb title (WebSiteTitle in web.config)
• Fluence commentary
• Fluence API Update
• Update Microsoft.Identity.Client and Microsoft.Graph.Core versions in XLCubedWeb.csproj
• Fluence small mults index fix when no row dimensions
• Fix sparkbar and add error handling to sparklines

v10.0.124

• Qlik changes
• Change connection defaults with evaluation license

v10.0.123

• Workbook slicers don't reshow when switching from the Formats sheet
• ClickOnce: rename as FluenceXL and sign as Fluence
• Proxy: Register logger stub
• Enable AtScale connections
• Remove current sample reports and link to new ones

v10.0.122

• Fluence updates

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