Customize the behavior of the Spreadsheet add-on by changing the following options or settings:

You can update 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.