Release Notes

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

V2410.1 - Oct 11, 2024

• Anaplan connections: check if XL3LookupRW and enable workbook writeback
• 'Zoom Out' for Grids
• Toggle between MemberName and Selected Alias for Freeform Reports
• Show aliases in filter section of Grid
• Member picker should retain Alias view after it has been closed & re-opened (freeform)
• Suppress Zeros shortcut to be added to toolbar (freeform)
• Member properties not displayed in grid (Anaplan connection)
• Validate members disabled when reports are downloaded as live
• Error opening file on the Web
• Option to display Base Name instead of Name
• Convert empty grid to freeform and suppressing nulls causes error
• Scheduling a pivot view errors
• Improve Kyvos logging
• Web: Default to use new portal

V2409.1 - Oct 2, 2024

• Rebrand to Anaplan XL
• Improved Anaplan Connection UI
• New UI: Minor updates and improvements
• Updated Japanese translations
• Oauth SSO support for Atoti
• XL Web now supports SSO connection to Anaplan
• Speed up formatting of large writable member areas
• Improved Support for Booleans in MDX Calcs
• Add text support to Filters
• Atoti mdx change for drilldown
• Custom Calculation Support for AtScale Connection
• Ability to toggle booleans in grids with a click to writeback
• Anaplan connection screen option for currently used cubes(modules) only
• Check licenced connection types in Excel
• Member selector - remove members by dragging them to the left
• Enable set command timeout for Atoti
• Disable anaplan modules with no data or too large dimensions, per API restrictions
• Disable writeback setting (Product Key level)
• Support for Freeform reports on Essbase
• Marimeko Chart improvements (including reference line)
• Various Security updates and fixes
• Fixed: Convert to freeform errors on non-cube members
• Fixed: Anaplan MDX wizard doesn't use YTD() function
• Fixed: Writeback hierarchies duplicated in UI
• Fixed: Dashboard title static on web
• Fixed: Anaplan writeback boolean errors
• Fixed: Scheduling UI fixes / improvements
• Fixed: Anaplan waterfall charts error
• Fixed: Freeform pick members incorrect on first open
• Fixed: Custom calcs screen doesn't show measure groups or display folders
• Fixed: Freeform conversion on grid with hidden areas fails
• Fixed: Other stability improvements

V2408.1

• (internal)

V2407.1 - July 15, 2024

• Add new scheduling UI to Excel
• Various security updates and fixes
• New UI improvements and fixes
• Anaplan: integration improvements and fixes
• Freeform support for member properties
• Fixed: Schedule doesn't work with distribution list/group
• Fixed: Can't change locale in reports sent via scheduling
• Fixed: Small multiple non-empty toggle icons don't change
• Add SharePoint to External source types
• Outline default format allow setting border style
• Atoti: XL3Member formulae support captions
• Support Anaplan line items styles
• Embedded workbook: support merged ranges
• SQL table merging doesn't work correctly when header is hidden
• Remove need for Access 2010 installation by using FluenceXL csv driver instead
• Sign all DLLs and EXEs
• Add support for SSAS azure link:// servers
• Rotated cells render incorrectly on high dpi displays
• Disabled schedules can be executed
• Adding dynamic chart on cube with no time hierarchy gives an error
• Conditional formats with Row() in criteria can be rendered incorrectly.

V2406.1

• Manage Scheduling available in Web portal
• Web portal - option to display the report full screen
• New UI: Updates and Fixes
• Security updates
• Fix: Pager not copied to new sheet
• Incorrect number formatting on web when mdx calc returns -0.0
• Refactor alias resolution to happen in mdx generation
• Fix Textbox font size when using fractions
• Proxy: Relational connections request reauthentication on invalid query
• Multisheet save to Excel fails when no sheets are selected
• Web report tabs - show ellipsis if name is cut off & improve tooltip
• Anaplan - support formulae writeback
• Column headers not right aligned on the Web
• Error displaying custom calculations form when connection has been deleted
• Fixed: SAP HANA hierarchies can have blank captions
• App Service - Allow setting witch Claim to use for username & email
• Scheduling: enable connecting to Anaplan for embedded scheduler
• Conditional format does not override accounting format layout on web
• Kpis on Atoti create duplicate measures
• Complex send to: doubling output
• Fixed: Invalid UniqueName on grid calculations
• Freeform allow setting output to caption/key/un if validating
• Add table filter does not work through grid designer
• Table Filter does not work on Anaplan/Fluence/etc

V2405.1

• Ability to bring data and named ranges from external workbooks
• New UI - improvements and fixes
• General security updates and fixes
• Complex "Send to" layouts
• Variance charts input children if you select the member twice
• Anaplan freestyle doesn't fill blank members
• Fixed: Error when changing connection in Template Table Editor
• Regional settings English Belgium - xl3link triggers SQL statement but doesn't reset cell reference
• Member property display issue when removing member
• Use "Display Property" in member selector automatically
• Powerpoint export: Excel chart/axis title containing a formula not displayed
• Freeform auto pick alias if grid configure for them
• Powerpoint export: hidden columns are displayed in PowerPoint export
• Anaplan errors on dates and certain blanks
• Dynamic charts can error on web when syncing plots with null data
• Multisheet template scheduling support
• Member props not returned when empty member as mdx values
• Update Dutch translations
• Freeform enhancements
• Atoti can double validate member aliases
• Atoti member caption validation should be for all hierarchies
• Maintain natural column order when doing a Fluence Drillback

V2404.1

• Expanded New UI to client calculations
• New UI: Fixes and updates
• Option to auto log out user on after inactivity
• Encryption of connection string in the connection mapping XML file
• Improved null cell handling for Anaplan / Polaris
• Freeform reports do not support member properties
• Freeform mode: Add support for Aliases
• Chart is overwritten by the last used slicer values
• Formulae can't drill on formula that use a caption with spaces
• Anaplan freestyle doesn't fill blank members
• Apply format sheet row heights: Error when changing member selections -2 members only
• Proxy client error fixes
• Bar chart axis matching can miss in Excel
• Enable replace 0 with null for Kyvos
• Update Japanese translations
• Fixed: Powershell - add-xl3report doesn't import images
• Update Dutch translations
• XL3Comments don't support multi-byte filename attachments
• Improved Proxy server logging
• "Create powerpoint chart" - not showing latest data
• Comments can error when user deleted
• SQL Admin: web.config error when installed on non-server computer
• ImpersonateJWT fails after session expires

V2403.1

• Enable Advanced tab on web designers
• Remove legacy service-based scheduler - see: https://help.fluencexl.com/Embedded_Scheduling_Upgrade
• Slicers - option to maintain named range of selected members
• New UI - various improvements and fixes
• Update permission descriptions to clarify approval level
• Fixed: Scheduler: Embedded images don't embed
• Allow Hierarchy quick search to be cancelable
• Update default FormatSheet grid label colour
• Fix random Webview error when using Dynamic chart error in a Dashboard sheet
• Support of Named Ranges for custom formatting areas of grids
• SQL Repo: new options to limit the number of report versions or number of days to keep old version for
• Imported aliases should overwrite existing aliases
• Grid with #REF named ranges gives obscure error
• Update Japanese translations

V2402.1

• New UI: Manage Favourites form
• New UI – Fix for error in edit XL3Lookup form
• New UI: Upgrade RepositorySideBar to new UI
• New UI: Performance improvement for table designer
• New UI: Insert Member Useability improvements
• Fix for formula Breakout to new sheet
• Improved handling for template publication
• Fix: Save password with connection fix for multiple connections
• Improvement: Display/Member properties - add property as soon as checked
• Fix: Error on quick search when display property set (Fluence connection)
• Atoti Connection: Update for display/member property handling and updated logo
• Fix: Member properties not remembered when "group member props with same name" checked
• Fluence mdx calcs can get incorrect key from unique name
• Null ref error when paging a proxied table rowset
• Add timing to Web SQL repository logging
• Fluence writeback now converts to correct data type
• Handling for Fluence drilling when connection has MDX calcs
• Fix: Fluence formula reports with restricted members
• Fix: Copy Dynamic Chart puts chart underneath original
• New UI: Fix for Hierarchy quick search, 2nd search doesn't always scroll to search result
• Translation: Addition of Japanese language
• Member selection menu wrong
• Fix: Task pane - member selector can show the wrong hierarchy
• Upgrade Microsoft.Data.SQLClient version
• TidyUp : Removal of redundant references:
• TidyUp: Security enhancements

V2312.1

• New UI - additional forms and bug fixes/improvements
• Global Parameters concept for Web reports
• Axis tuple editor for editing tuple sets from workbook
• Clean Formatsheet location if install path changes
• Refresh connections to clear "Save form cookies"
• Remapping connection for a grid with gap calculation errors
• Web Can't download attachment from comment frame
• Publish button remains active when publishing
• Updated paging control
• Check for kyvos server being down before retrying oauth
• Allow editing of groups in admin app
• Removed additional Web UI right click option
• Powershell - Include license key expiration
• Embedded scheduler - support TM1 conns
• Recent reports page not refreshing after opening a report
• Scheduler: Allow connections to PowerBI using service principal
• Fixed: Display member property doesn't work
• Fixed: Freeze pane not positioned correctly in web on very high dpi
• Member property not shown in Web
• SQL Repo managed identity isn't used for scheduling LogController
• Dashboard labels and titles not center aligned on web
• Web multi-select workbook slicers don't resize correctly
• Drillthrough on FluenceXL grid - Group Dimension should only pull itself, not leaf descendents
• Web dialog closing on toolbar click
• Excel update: Camera objects impact Grid Refresh performance
• Fixed performance issue using Picture Links/Camera objects

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

V2309.1

• New UI fixes and improvements
• Enable Excel logging through the Options form
• New freeze pane handling option for web publication - improves alignment when zooming
• Add 'last modified' date to Report context menu
• Add scheduling for single report via "Send To" schedules
• Fluence: Support repeated tuples in grids
• Fluence: XL3GlobalVariableLookup function
• Don't overwrite appsettings.json on upgrade
• Fixed: Can't sort grid by calculation on Incorta
• Create aggregates instead of measures for Incorta
• Overlap charts get black fill
• Dashboard Chart Overlay refresh on Web
• Dynamic chart can error with no series on the primary axis
• Web Dashboard Chart - Entity name overlaps chart bar
• Datalabel background missing on reversed value scales
• Deleting a schedule folder doesn't delete its contents
• New Comment UI improvments
• Fixed: Error saving comments when embedded in iframe
• Allow setting custom sql filter for incorta
• Fix error in Web config utility for some virtual directories
• Dax-based tree slicers do not output captions
• Preview option: Embedded styles, to stop needed to save as XML
• Dax tree slicer - support "All" item
• Incorta sql calcs do not go into the right measure group
• Updated Dutch translations
• Reverse sort doesn't work on ATOTI
• Fluence - Add alternate Drillthrough option
• Deleting freeform root cell causes error
• Copy Freefrom reports when copying worksheet
• Incorta - allow self join hierarchies on business schema
• Anaplan SSO updates
• Fixed: Azure SSAS connection may not reconnect after token expiration
• Missing member in set slicer causes error
• Slicer not displayed in chart
• Improve text of SSO auth type option

V2308.1

• New UI - Allow switching of member display from caption to other properties
• Include new toolbar in embedded reports
• SQL Repo - Option to limit excel "Manage" options for "My Reports"
• Fluence Writeback - apply writeable formatting based on security & open periods
• Fluence - formula reports using custom calcs speed up
• Grid writeback - allow grid calculation to be sent on write
• Missing translations in Table Properties form
• Grid designer - member sets are removed after updating the grid
• Retry SSAS weighted writes on null/0
• Grid calcs attached to KPI members disappear
• SendTo: Time zone issue
• Matched chart axes have incorrect direction when data is inverted
• Warn if error occured during load that may impact saved workbook
• Custom MDX implementation: NonEmpty & member.UniqueName property
• Web commentary - fix regression with tagging & viewing attachments
• New UI - various fixes
• Chart print to pdf missing markers
• Incorta v2 PAT connection mapping
• SQL Table drilling - handle nulls better
• Incorta search on attribute hierarchy doesnt work
• Rest API - add report parameter support
• Slicer edit screen cant turn on "all" item
• 'Edit & Remap' missing from new connection dialog
• Incorta drill removes items when slicer "<All>" is selected
• Format Category Axis Alignment - fix align right icon
• Support distinct count in PBI column default agg
• SQL Admin console - Roles window only opens once
• Speed up on some reports when using "delay control creation option"
• Search measures error on Incorta
• Cancel Query form not always shown

V2307.1

• New UI - Dynamic Chart Designer
• BulkConnectionEditor: enable loading xlsb
• Sql connection mapping - add ability to toggle RequiresPassword
• Option to replace Access Driver with our own CSV driver
• Add WebReport Links to Fluence Tenants
• Various security updates
• SmartView freeform retrieval mode
• Add COM accessor option for AtScale connections
• Show download progress for embedded reports
• Option to use managed identity or Client Secret to access Azure storage for "Send to"
• Atoti support
• Add button on Dashboard Ribbon to toggle TaskPane
• Add a way to reset chart category highlighting
• Javascript API - add "XLCubed.ImpersonateFromJwt"
• Extend the number of parameters XL3WebReportLink supports
• Web: Using a tree slicer with a dead session breaks new session
• Tree slicer search focus goes into Excel
• Anaplan tree-slicer search support
• Error on chart with tabular translations

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
• FluenceXL 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 FluenceXL 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
• FluenceXL 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
• FluenceXLWeb: New "Send to" scheduling options for outputting to Azure blobs
• Drill down on web with named set only possible with right click first
• FluenceXLWeb 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 FluenceXL
• 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 FluenceXLWeb
• 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
• FluenceXL 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
• FluenceXLWeb: 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 FluenceXL 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 FluenceXLWeb title (WebSiteTitle in web.config)
• Fluence commentary
• Fluence API Update
• Update Microsoft.Identity.Client and Microsoft.Graph.Core versions in FluenceXLWeb.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
• FluenceXLWeb: 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 FluenceXL 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 FluenceXL 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 FluenceXLWeb
• 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