When you save a report to Cube, Cube preserves your spreadsheet’s structure, formatting, and many commonly used formulas, so your reports stay consistent and easy to understand.
This article outlines which formatting options and formulas are supported in reports and what to watch for when preparing a new report.
Supported formatting
Note: For ranges in Web Reports, format row and column headers as Date or General for the Time dimension, and as Text or General for all other dimensions.
The following visual and structural formatting is supported in Cube reports:
Text and Style
- Fonts (size and family)
- Note: Fonts must be supported by your browser. If a font isn’t available, your browser will display Times New Roman instead.
- Font color and background fill
- Bold, italics, underline
- Horizontal and vertical alignment
- Standard Text, Number, Date, and Percentage formatting (some custom formats may not be supported)
Borders and Grid
- Border color, weight, and style
- Gridlines (shown or hidden)
- Freeze Panes
Layout and Spacing
- Column width and row height
Data Validation
- Data Validation dropdowns are maintained as long as the source for the list resides within the Report Range
Supported formulas
Cube supports the following formula functions within a published report. These formulas are retained when you open or fetch a report in the Workspace and will automatically recalculate as data is updated.
Formulas must reference cells that exist WITHIN the report area. Formulas cannot reference other tabs or named ranges that don't reside within your report.
Arithmetic and Aggregation
- SUM, COUNT, COUNTA, AVERAGE, MIN, MAX
- Standard math operators: +, -, *, /
Logical and Conditional
- AND, OR, IF, IFERROR, SUMIF, COUNTIF, ISERROR
Text Functions
- TEXT, LEFT, RIGHT, MID, LEN, CONCATENATE
Comparison Operators
- =, !=, <, >, <=, >=
Date Functions
- NOW, EOMONTH, DATE, MONTH, DAY, DAYS, YEAR
Rounding
- ROUND, ROUNDUP, ROUNDDOWN
Lookup and reference
- VLOOKUP, SEARCH
If your selected range includes unsupported or out-of-range formulas, Cube will warn you during validation. Those formulas will not be retained in the saved report, and in some cases, won't allow the report to be created.