Difference between revisions of "Version 9.2"

(Scheduling (C))
Line 5: Line 5:
* Query timeout option
* Query timeout option can be set in the [[Managing Connections]] screen.

Revision as of 11:53, 29 October 2018

What's new in Version 9.2

Main Additions




  • Display folder support

Small Multiples


  • Paged Viewports: Can output active overlay index to a cell
  • Marimekko charts

Pivot BI

  • New custom visual for embedding XLCubed elements inside Power BI reports
  • Power BI Embedding in Excel allows a report to be included in a workbook

Formulae (A)

  • XL3SetProperty extended
    • Grid --> ShowDescendantComments
    • Dashboard --> Target
    • PagedViewport --> ActiveViewport
    • SmallMultipleChart/Slicer/Pager/Map/Viewport/PagedViewport/PowerBI --> Visible
    • SmallMultipleChart --> DataLabelsVisible

Commentary (C)

Relational Connections

  • Custom connection string for some typed connections
  • Enhanced SQL Stored Procedure support

Scheduling (C)

  • New UI: Schedules can be created within folders
  • Schedules can now be 'Run Now'
  • Schedules can be setup to allow users to subscribe and unsubscribe
  • Protected workbooks remain protected when sent
  • Emails can include report images
  • Failure emails can be sent


  • Fixed size columns and rows are indicated with an asterisk (*)
  • XL3SetProperty can set target by name and nearest match screen size

Supported backends

  • Support XL3RunSqlProc with SAP HANA
  • Better Custom Calculations support on more server types


  • Workbooks can now have Aspects defined

Excel Edition


  • Better Worksheet copying
  • Holding Shift when opening a workbook allows all Grids to be set to Design Mode
  • Support for Excel worksheet "Zoom" on some controls (slicers, treemaps)
  • Various updates for improved appearance on very high DPI machines
  • Improved control placement when loading reports on machines with different DPI to the original design machine


  • Favourites

Web Edition


  • Logging for license usage
  • .url favourites support passing through parameters



  • Transparent picture links in PowerPoint exports
  • Multi-sheet printing supports ordering of slicers
  • Add option to only allow active sheet to be printed
  • Support for "Microsoft PDF Driver"


  • SQL Connections now supported