Clearing Styles from Worksheets

Visual cues, or styles, are a great way to help visualize data in Spreadsheet Add-in. Applying styles, however, involves additional processing time during a retrieval request. This additional processing impacts retrieval speed slightly.

If you do not want to apply styles to the worksheet, you can clear them. You can also turn off styles so that they are not displayed when you refresh the view (by selecting Essbase, then Retrieve, for example).

If styles are applied to the worksheet and you execute the FlashBack command, these styles are temporarily removed from the current view. The styles are reapplied whenever you initiate a retrieval.

To remove all styles from the worksheet:

Select all cells in the worksheet.
From the Excel menu bar, select Edit, then Clear, and then Formats.

To turn off styles:

Select Essbase, and then Options.

In Display, under Cells, clear Use Styles, and then click OK.

Note:

If you turn off styles without clearing them from the worksheet, the styles remain in the current worksheet view when you refresh the view. The styles remain to avoid removing styles that you may apply to individual cells using native worksheet formatting options.