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

Difference between revisions of "Version 7.5"

(Created page with "What's new in XLCubed Version 7.5. =General= ==Grids== * Allow ranking types to be selected from a range ==Tables== * Columns as sections ==Visualisation== * Cube-based treemaps...")
 
Line 22: Line 22:
 
* Initial value slicer selection can be applied when its contents changes
 
* Initial value slicer selection can be applied when its contents changes
 
==Formulae==
 
==Formulae==
* XL3GridMember formula
+
* XL3GridMember formula changes
 
==Miscellaneous==
 
==Miscellaneous==
 
* Allow picking Measure Group and Display Folders for custom calculated measures
 
* Allow picking Measure Group and Display Folders for custom calculated measures
Line 34: Line 34:
 
* 'Add Pager' Grid shortcut
 
* 'Add Pager' Grid shortcut
 
==Miscellaneous==
 
==Miscellaneous==
* Excel 2013 support
 
 
* Propagate across sheets can propagate into a new workbook
 
* Propagate across sheets can propagate into a new workbook
 
=Web Edition=
 
=Web Edition=

Revision as of 16:38, 10 June 2013

What's new in XLCubed Version 7.5.

General

Grids

  • Allow ranking types to be selected from a range

Tables

  • Columns as sections

Visualisation

  • Cube-based treemaps can use custom number formats
  • Interactive charting
  • In-Cell box plots: option to plot a value
  • In-Cell box plots: option to 'other values' as a dot or line
  • Small Multiple Charts: add support for datapoint tooltip
  • Small Multiple Charts: control thickness of line charts
  • Small Multiple Charts: control label and legend text attributes
  • Small Multiple Charts: support outputing multiple points to a range
  • Small Multiple Charts: display trend line
  • Small Multiple Charts: output all of the details about an individual data point
  • Small Multiple Charts: use an Excel range as a data source

Slicers

  • Initial value slicer selection can use multiple cells
  • Initial value slicer selection can be applied when its contents changes

Formulae

  • XL3GridMember formula changes

Miscellaneous

  • Allow picking Measure Group and Display Folders for custom calculated measures
  • Picture links
  • Drillthrough uses format sheet for formatting
  • Option to refresh Grid after an invalid writeback

Excel Edition

Grids

  • Smarter handling of invalid members
  • 'Format Cell' option highlights an individual cell
  • 'Add Pager' Grid shortcut

Miscellaneous

  • Propagate across sheets can propagate into a new workbook

Web Edition

General

  • Multi-language workbook name and descriptions can be set
  • Grids and formula values can be cleared for security
  • Cells starting with 'HTML:' can be passed to the browser as is (must be enabled on the web server for security)
  • Help button can be redirected to an alternative URL
  • Analytics workbooks

Formulae

  • XL3IsWeb formula
  • XL3WebReportLink supports relative paths

Scheduling

  • Publish PowerPivot connections when published
  • Allow an email alert to be sent based on a limit value
  • Ability to write report out to a network share