Customize the behavior of the Spreadsheet add-on by changing the following options in your settings 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
-
Zero values will display as zero for new fetches within the range.
-
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.
-
Null values will display as empty for new fetches within the range.
Learn more about how to exclude zero rows entirely on fetch.
Default currency for new range
Before you can set up a default currency for a new range, you must have multi-currency set up for your company. Learn how to set up multi-currency.
If you have multi-currency setup for your company, the Spreadsheet add-on's default setting will be to 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.
Publishing only be done in the company's default currency.
Publish permission for new range
When the setting publish permission for the new range is toggled on, each new range created will have "Allow Publishing Data" automatically enabled.
If the setting is toggled off (gray), each new range a user creates will have "Allow Publishing Data" automatically disabled.