You can customize the behavior of the Spreadsheet App to control font colors, zero formatting, currency defaults, and publish permissions for ranges by navigating to the hamburger icon and selecting Settings.
Retain font color on fetch
When writing fetched values, Cube’s current default is to display publishable dimension values in blue font and non-publishable dimension values in black font.
Retain font color options
Toggle off: Use Cube font color preferences
-
Publishable values will display as blue for new fetches within the range.
-
Publishable values will overwrite any user-modified font colors as blue within the range for subsequent fetches.
Toggle on: Retain user font color preferences
-
Publishable values will display with your chosen font color for new fetches within the range.
-
Publishable values will not overwrite any of your modified font colors within the range for subsequent fetches.
Learn why certain dimensions are excluded from publishing.
Display zero as null on fetch
When writing fetched values, Cube’s current default is to display zero values as zero and null values as empty cells.
Display zero values as null options
Toggle off: Display all existing values
-
Null values will display as empty for new fetches within the range.
Toggle on: Display zero values as null
-
Zero values will display as empty for new fetches within the range.
Learn more about how to exclude zero rows entirely on fetch.
Display null values as zero
Cube’s current default is to display fetched zero values as zero and null values as empty cells. Adjust this setting to better fit your reporting needs.
Display null values as zero options
Toggle off: Display all values as the default
-
Null values will display as empty for new fetches within the range.
Toggle on: Display null values as zero
-
Null values will display as Zero for new fetches within the range.
Default currency for new ranges
Before you can set up a default currency for a new range, you must have currencies set up for your company. Learn how to manage currencies in Cube.
If your company has currencies set up, the Spreadsheet App will use your company's default currency for every new range.
To set a different currency for the new range, choose an available currency code from the dropdown.
Note: This will not change your company's base currency. It will only change your default currency when creating a new range.
Publish permission for new ranges
When the setting publish permission for the new range is toggled on, "Allow Publishing Data" will be automatically enabled for each new range created.
If the setting is toggled off (gray), each new range a user creates will have "Allow Publishing Data" automatically disabled.