So this is our second blog on the new features of XLCubed v8 – today we’re going to run through workbook slicers.
Workbook slicers allow the user to create the slicers at the workbook level so that they can be displayed for any/all sheets.
There’s a slicer pane which can be arranged horizontally or vertically and stays in place when you navigate to another sheet. This means that if you have a multi-sheet workbook you only need to define one set of slicers. These can then configured to be shown or hidden for individual sheets as required.
Turn the slicer pane on by selecting Workbook slicers from the XLCubed ribbon, Slicers tab:
Within the slicer pane there’s an Add Slicer button – this brings up the standard design form for adding slicers.
The Edit layout button brings up the window below. It allows you to configure the order in which slicers will appear on the pane, which sheets they will be visible on and the padding between individual slicers. You can also set a background fill colour from here.
The screenshot above shows that the Date.Calendar slicer is available on a number of sheets. Selecting a slicer choice on one sheet will refresh the other sheets where the slicer is also available:
Once added, you link workbook slicers to your report in the same way as embedded slicers. You can link directly to grids and other XLCubed objects and output their selection to Excel cell locations for use by formulae.
Their positioning on the web is fixed but if you find the slicers are taking up too much screen space you can make your slicer selections and then use this icon to toggle the Slicer Pane off:
Today we’re revisiting one of our more popular guides, Creating rounded corners in Excel Tables, and have updated it for v7.1. When Igor Asselbergs was contemplating the value of round corners in design, he came to the conclusion that in many cases they added real value to the user experience.
The effect can be explained by the Gestalt Law of Continuity. Gestalt is a set of rules based on research into perception psychology, and a very powerful tool for Excel table design. In table design this effect can help us to see the table columns as a unit.
The previous process to create rounded corners in Excel tables required quite a bit of persistence and patience. In Version 7.1, we’ve introduced a feature to enable adding rounded corners in a few seconds rather than several minutes, so while the theory is identical the implementation is much improved. Take this report showing sales KPIs, where we would like to add rounded corners to the header row in the table.
To do this we first highlight the required area:
Then we go to Extras -> Add/Edit Round Corners:
The Colours and Border thickness will be picked up from the selected cells. Select the corners to be made round (in this case the Top Left and Top Right corners):
Click OK to apply the borders
To edit existing corners which were created by XLCubed then you can just highlight the cell or range and Go to Extras -> Add/Edit Round Corners. The changes will be applied to the existing corners (or the corners can be removed by unselecting them).
It’s a simple addition to the product which would have saved us quite a bit of time in customer implementations over the years, and hopefully now does the same for our users.
There has been a lot of criticism regarding Excel 2007, particularly about the new chart engine, the UI inconsistencies and the Ribbon. Jorge yesterday concluded that Excel 2007 is Useless and Jon wrote a comprehensive analysis about Changes to Charting in Excel 2007 where he expressed his concerns regarding the new Charting. In 2006 Stephen Few reviewed Excel 2007 charting and concluded Excel 2007 charting Preview of an Opportunity Missed. Charley Kyd did a survey about How Do Business Users Like the Ribbon and came back with the result that about 56% of all respondents had a negative opinion about the Ribbon
Continue reading Microsoft, Pimp Down My Ribbon