XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/

Difference between revisions of "Version 9"

(General)
Line 25: Line 25:
 
* Support more then 30 parameters on XLCubed formulae
 
* Support more then 30 parameters on XLCubed formulae
 
* New function: XL3RefreshSheetObjects
 
* New function: XL3RefreshSheetObjects
 +
* XL3SetProperty can now set:
 +
** Chart Series colours
  
 
==SQL==
 
==SQL==
Line 33: Line 35:
 
* Workbook option to set queryengine.ValidateMembers
 
* Workbook option to set queryengine.ValidateMembers
 
* Moved to .net framework 4.5.2  
 
* Moved to .net framework 4.5.2  
 
+
* Updated format sheet - allows better control of borders.
  
 
=Excel Edition=
 
=Excel Edition=

Revision as of 11:21, 12 April 2016

What's new in XLCubed Version 9

Main Additions

General

Grids

  • Grids can be built from any datasource

Tables

Visualisation

  • Improved layout of Treemaps
  • Dashboard sheets
  • Paged viewports
  • Popup viewports
  • Option to autos-size maps
  • Maps support additional placeholders in tooltips

Slicers

Formulae

  • Support more then 30 parameters on XLCubed formulae
  • New function: XL3RefreshSheetObjects
  • XL3SetProperty can now set:
    • Chart Series colours

SQL

Scheduling

General

  • Workbook option to set queryengine.ValidateMembers
  • Moved to .net framework 4.5.2
  • Updated format sheet - allows better control of borders.

Excel Edition

General

  • Updated ribbon and UI
  • Option to remember logon credentials for current Excel session
  • Removed support for Excel 2003 - previous versions remain compatible

Slicers

  • Reduced Excel resource usage by dimension slicers


Grids

  • "Clear drills" option in member selector
  • New "Scope_Isolation" option in Custom Calculations
  • Option to sort named sets in member selector

Web Edition

General

  • Connection Mapping includes an optional "path" attribute to allow folder-level mappings
  • Option to include custom css file to override css

Formulae

SharePoint

Visualisation

API