Formatting Grids/Version 7.0

In v7 formatting is available on XLCubed right-click menu as option, Format This Member.

So if we want to format Accessories row, we right-click on Accessories, XLCubed, Format This Member. We are presented with the standard Excel Format Cells window from which we can choose any of the usual settings to change.

We will choose Fill, select a colour and OK. The refreshed grid now looks like this:

The lower half of the XLCubedFormats sheet shows that both Member Accessories and associated row data will be filled in pink.

If you do not want the data to be filled go to the XLCubedFormats sheet, right-click the Data Format cell for Accessories and remove the fill colour by setting the backgound to 'No Colour'.

Once refreshed, the grid now looks like:

Formatting Rows and Columns

In v7.2 we now have the ability to set formatting on rows and/or columns for grid members.

Here we have a simple report where we have set formatting at different levels:

The format sheet looks like this:

Let’s change the format sheet to ROWS as below:

We will add another hierarchy on rows. The refreshed report will now format all report rows for all hierarchies on rows as above depending on the member level.

If you have a reporting standard across your organisation this could easily be included in the master format sheet so that all grids created would have the same row format. The same applies to columns.

Format this level

New to v7.2, Format this level allows the user to easily format all members at a particular hierarchy level and is available on XLCubed's right-click menu, Formatting, Format this level. You will be presented with the standard Excel Format Cells window from which you can choose any of the usual settings to change.