Spreadsheet

The OneStream Windows App Spreadsheet feature enables users to incorporate spreadsheet functionality experienced by users of the OneStream Excel Add-in without needing to have Excel loaded on their computer. It can be used for ad hoc querying/reporting, analysis, data entry, and formatted reports. The Spreadsheet feature enables users to stay within the OneStream Windows App while being able to use functionality similar to what they know and love in Excel. Similar to the Excel Add-in, the Spreadsheet feature leverages OneStream’s re-usable Cube Views for fast and easy analysis. See Navigating the Excel Add-In for more details on this feature.

• Here are some other functional highlights and benefits:

• Change point-of-view, interact with Forms, assign Cube Views, drill through to source data and update Workflow status

• Utilize familiar retrieve functions for ad-hoc reporting and analysis

• Eliminate risk of errors and duplication of efforts with standardized and centralized spreadsheet controls

• Safely edit, update and analyze data as spreadsheet forms respect Application and Workflow and security

• Eliminate spreadsheet maintenance when metadata changes because Cube Views are read dynamically

• Sheet-based calculations remain intact even when rows or columns are added

• Include multiple Cube View results in the same sheet

The OneStream Windows App Spreadsheet feature can perform most of the tasks accomplished by the OneStream Excel Add-in, with some limitations. These limitations include, but are not limited to:

• Macros

• Solver

• Document properties

• No option to insert copied/cut cells in spreadsheet

• Preview format does not update for format types Effects (Superscript, Subscript, Strikethrough)

• Ability to manage conditional formatting – color scales are reversed

• Shift+End

• Spreadsheet border button does not store last selection

• Text Direction option from Alignment formatting

• Underline formatting does not appear same as in Excel

• Not all Chart options are available in Spreadsheet

• Ability to change chart colors in spreadsheet

• References to other sheets in Spreadsheet is a different process

• Ctrl+PageUp / Ctrl+PageDn correctly changes the tab but does not reset tab focus in spreadsheet

• CTRL+N creates a new spreadsheet, however if an existing spreadsheet was opened with unsaved changes, it closes the existing spreadsheet without saving edits made since last save

Some functionality is currently not supported in the Spreadsheet Tool. Functionality that is known not to be supported in the Spreadsheet feature at this time is listed below:

• Fill number formatting

• The ability to format part of a cell with different formatting

• Justify alignment option

• Managing Rules under spreadsheet conditional formatting

• Spreadsheet alignment cell format "Center Across Selection"

• Undo/Redo

The following Excel Column Charts are incompatible and unavailable with the Spreadsheet feature:

• Stacked 3-D

• 100% Stacked 3-D

• Stacked Cylinder

• 100% Stacked Cylinder

• Stacked Cone

• 100% Stacked Cone

• Stacked Pyramid

• 100% Stacked Pyramid

The following Excel Line chart is incompatible and unavailable with the Spreadsheet feature:

• 3-D Line

The following Excel Bar charts are incompatible and unavailable with the Spreadsheet feature:

• Stacked 3-D Bar

• 100% Stacked 3-D Bar

• Stacked Horizontal Cylinder

• 100% Stacked Horizontal Cylinder

• Stacked Horizontal Cone

• 100% Stacked Horizontal Cone

• Stacked Horizontal Pyramid

• 100% Stacked Horizontal Pyramid