Jump to: navigation, search
  • Main page
  • Recent changes
  • Random page
  • Version 9

    What's new in XLCubed Version 9

    Main Additions

    • Dashboard sheets - build auto-connected, responsive, and device optimised dashboards in Excel for Web and mobile deployment.
    • Grids can connect to Additional datasources - SQL, Excel and Big Data Sources.
    • Paged Viewports - Ideal for 'panel' dashboards - Bring any part of an Excel workbook together in one dynamically switchable container.
    • Viewports can now reference Excel charts directly, rather than the range the chart is located in.
    • Data Mashup - to bring data from different sources together in one reporting table.
    • UI enhancements

    General

    Grids now connect to additional Datasources

    Tables

    Visualisation

    Slicers

    • "Apply query restrictions" available for Member Selector slicer types
    • Slicers will now retain data types when outputting to cells - off by default in pre-v9 workbooks, can be enabled in Workbook Options

    Formulae

    • XL3Link adds "PRINTSHEET" and "PRINTWB" to print the active sheet/workbook without prompting

    Scheduling

    General

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

    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

    • Skip Levels for tree slicers
    • Reduced Excel resource usage by dimension slicers

    Grids

    • * Skip Levels in member selector
    • "Clear drills" option in member selector
    • New "Scope_Isolation" option in Custom Calculations
    • Option to sort named sets in member selector
    • Option to turn off "Refresh when slicers change", similar to "Refresh when driving ranges change"

    Web Edition

    General

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

    Formulae

    SharePoint

    • Reports published directly to SharePoint can now be used in scheduling

    Visualisation

    API