XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Version 7.5
What's new in XLCubed Version 7.5.
Contents
Main Additions
- New web ad-hoc analytic and reporting capability for web based users
- Slice and dice analytics in Mobile apps and devices
- Interactive Charting
- Publication and sharing of PowerPivot reports
General
Grids
Tables
- Columns as sections - option to show only changing values
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 outputting 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
- Small Multiple Charts: use SQL as a data source
- Mobile: Design frame for scaling reports for mobile delivery
Slicers
- Initial value slicer selection can use multiple cells
- Initial value slicer selection can be applied when its contents changes
- New feature - Wait for submit on Web
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
- Pager control for Grids
Miscellaneous
- Propagate across sheets can propagate into a new workbook
Web Edition
General
- New web ad-hoc analytic and reporting capability for web based users
- Slice and dice analytics in Mobile apps and devices
- Publication and sharing of PowerPivot reports
- SharePoint 2013 WebPart
- 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
Formulae
- XL3IsWeb formula
- XL3WebReportLink supports relative paths
Scheduling
- Allow an email alert to be sent based on a limit value
- Ability to write report out to a network share