This guide will show you the Excel functions that are not currently supported in Report Designer.

Excel functions not supported

The functions listed below are not currently supported in the report designing area of Ciphr. Although, some of the listed functions do work within design they are not retained when the report template is checked in:

• Conditional formatting (all)
• Filtering by selecting values from within drop down lists, other filtering where values are manually typed in is supported
• Grouping (all)
• Subtotals in Base Data (Subtotalling within pivot tables is supported)
• Macros - for security reasons Ciphr does not allow for any Macros to be recorded or embedded within the Report templates