Version 7.5

What's new in XLCubed Version 7.5.

General

Grids

• Allow ranking type 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