Appendix C: Spreadsheet Features and Functionality

Supported Spreadsheet Features and Functionality

Component Integration

  • Dashboards

  • Workflow Forms
Data Sources and Related Functionality

  • Spreadsheet Files

    • Create, open, edit, and save

  • Cube View Connections

    • Create, display, edit, and remove

    • Refresh data and submit changes

    • Support for Cube View formatting

  • Table View Definitions

    • Create, display, edit, and remove

    • Refresh data and submit changes

  • Retrieve Functions

    • Supported Functions

      • XFGetCell, XFGetCell5, XFGetFXRate, XFGetCalculatedFxRate, XFGetMemberProperty, XFGetRelationshipProperty, XFGetHierarchyProperty, XFGetMemberInfo XFSetCell

      • Refresh data and submit changes (XFSetCell only)
Ribbon Functions

  • New (Create Spreadsheet)

  • Open (Local File, OneStream System File, Application Workspace File, System Workspace File)

  • Save As (OneStream System File, Application Workspace File, System Workspace File)

  • Refresh Sheet and Refresh Workbook

  • Submit Sheet and Submit Workbook

Unsupported Spreadsheet Features and Functionality

Charts

  • Limited Chart Types

  • Color Customization
Functions

  • Macros

  • Solver

  • Sheet References

  • Document Properties

  • Context Menu Features and Functions

  • Insert Copied/Cut Cells

  • Keyboard Controls:

    • Shift + End

    • Ctrl + PageUp / Ctrl + PageDown (does not set tab focus)

    • Ctrl + N (overwrites spreadsheet with unsaved changes)
Formatting

  • Preview Font Formats

  • Conditional Formatting

  • Cell Borders (last selection is reset after format is applied)