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.
We are currently rolling out this update to our current reporting feature. You'll see it in your Cube soon!
This article outlines which formatting options and formulas are supported in reports and what to watch for when preparing a new report.
Supported formatting
The following visual and structural formatting is supported in Cube reports:
Text and Style
- Fonts (size and family)
- Font color and background fill
- Bold, italics, underline
- Horizontal and vertical alignment
Borders and Grid
- Border color, weight, and style
- Gridlines (shown or hidden)
Layout and Spacing
- Column width and row height
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.
Arithmetic and Aggregation
- SUM, COUNT, AVERAGE, MIN, MAX
- Standard math operators: +, -, *, /
Logical and Conditional
- AND, OR, IF, IFERROR, SUMIF, COUNTIF
Text Functions
- LEFT, RIGHT, MID
Comparison Operators
- =, !=, <, >, <=, >=
Date Functions
- EOMONTH, MONTH, DAY, YEAR
Rounding
- ROUND, ROUNDUP, ROUNDDOWN
Lookup and reference
- VLOOKUP
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.