• Introduction
  • Reports
  • Dashboards
    • Web Dashboard - Designer Mode
      • Creating a Dashboard
      • Providing Data
        • Create a New Data Source
        • Connect to an Existing Data Source
        • Manage Data Sources
        • Working with SQL Data Sources
          • Manage SQL Queries
          • Dashboard Data Source Wizard
          • Query Builder
          • Filter Queries
          • Pass Query Parameters
          • Stored Procedures
          • Preview Data
        • Filter Data Sources
        • Calculated Fields
      • Adding Dashboard Items
      • Binding Dashboard Items to Data
        • Binding Dashboard Items to Data in the Web Dashboard
        • Hidden Data Items
        • Binding Dashboard Items to Data in OLAP Mode
      • Designing Dashboard Items
        • Chart
          • Providing Data
          • Series
          • Panes
          • Interactivity
          • Legend
          • Axes
          • Orientation
        • Scatter Chart
          • Providing Data
          • Interactivity
          • Legend
          • Axes
          • Orientation
          • Labels
        • Grid
          • Providing Data
          • Columns
          • Interactivity
          • Conditional Formatting
          • Totals
          • Layout
        • Pies
          • Providing Data
          • Interactivity
          • Layout
          • Labels
          • Style
        • Cards
          • Providing Data
          • Layout
          • Delta
          • Sparkline
          • Formatting
          • Interactivity
          • Cards Arrangement
        • Gauges
          • Providing Data
          • Delta
          • Gauge Scale
          • Interactivity
          • Layout
          • Style
        • Pivot
          • Providing Data
          • Interactivity
          • Conditional Formatting
          • Layout
          • Expanded State
        • Choropleth Map
          • Providing Maps
          • Providing Data
          • Delta
          • Map Navigation
          • Interactivity
          • Labels
          • Legend
        • Geo Point Maps
          • Map Types Overview
          • Providing Maps
          • Geo Point Map
            • Providing Data
          • Bubble Map
            • Providing Data
            • Legends
          • Pie Map
            • Providing Data
            • Pie Options
            • Coloring
            • Legends
          • Clustering
          • Map Navigation
          • Interactivity
          • Labels
        • Range Filter
          • Providing Data
          • Series
          • Interactivity
          • Predefined Periods
        • Images
          • Image Overview
          • Providing Images
          • Interactivity
          • Image Settings
        • Text Box
        • Treemap
          • Providing Data
          • Interactivity
          • Layout
          • Grouping
          • Coloring
          • Labels
        • Filter Elements
          • Filter Elements Overview
          • Providing Data
          • Interactivity
        • Dashboard Item Group
      • Data Shaping
        • Summarization
        • Grouping
        • Sorting
        • Filtering
        • Top N
        • Formatting Data
      • Interactivity
        • Master Filtering
        • Drill-Down
      • Appearance Customization
        • Conditional Formatting
        • Coloring
      • Data Analysis
        • Aggregations
        • Calculations
        • Dashboard Parameters
          • Creating Parameters
          • Passing Parameter Values
          • Requesting Parameter Values
      • Converting Dashboard Items
      • Dashboard Layout
        • Dashboard Title
        • Dashboard Item Caption
        • Dashboard Items Layout
      • Undo and Redo Operations
      • Saving a Dashboard
      • Opening a Dashboard
      • Exporting
      • UI Elements
        • Toolbox
        • Dashboard Surface
        • Dashboard Menu
        • Dashboard Item Menu
        • Data Item Menu
    • Web Dashboard - Viewer Mode
      • Data Presentation
        • Data Presentation Basics
        • Master Filtering
        • Drill-Down
        • Dashboard Layout
      • Dashboard Parameters
        • Requesting Parameter Values
      • Exporting
      • Dashboard Items
        • Chart
          • Data Presentation Basics
          • Interactivity
          • Exporting
        • Scatter Chart
          • Data Presentation Basics
          • Interactivity
          • Exporting
        • Grid
          • Data Presentation Basics
          • Interactivity
          • Exporting
        • Pies
          • Data Presentation Basics
          • Interactivity
          • Exporting
        • Cards
          • Data Presentation Basics
          • Interactivity
          • Exporting
        • Gauges
          • Data Presentation Basics
          • Interactivity
          • Exporting
        • Pivot
          • Exporting
        • Choropleth Map
          • Data Presentation Basics
          • Interactivity
          • Exporting
        • Geo Point Maps
          • Data Presentation Basics
          • Interactivity
          • Exporting
        • Range Filter
          • Exporting
        • Image
          • Exporting
        • Text Box
          • Exporting
        • Treemap
          • Data Presentation Basics
          • Interactivity
          • Exporting
        • Filter Elements
  • Interface Elements
    • Common Activities
    • Touch Support
      • Card View
    • Data Editing
      • Add and Delete Cards
      • Switching a CardView to Edit Mode
      • Save or Discard Changes
      • Batch Editing
    • Selection and Navigation
      • Page Navigation
      • Select Cards
    • Sorting
    • [Filtering]
      • Creating Complex Filter Criteria with the Filter Control
      • Header Filter
      • Date Range Header Filter
      • Search Panel
    • Exporting
      • Charting
    • Chart Designer
    • Series Selection
      • Data View
      • Docking Panel
      • Document Viewer
    • Classic Document Viewer
      • [Navigation]
        • Navigate to a Specific Report Page
        • Navigate using Report Bookmarks
        • Search for a Specific Text within a Report
      • [Printing]
        • Print a Report Using the PDF Web Browser Plug-In
        • Install and Activate the Adobe Reader Plug-In for Printing in a Web Browser
        • Print Reports Using the Native Functionality of a Web Browser
      • [Exporting]
        • Export a Report and Save It to the Disk
        • Export a Report and Show It in a New Window
      • Passing Parameter Values
    • HTML5 Document Viewer
      • [Viewing and Navigating]
        • Navigate Between Pages
        • Navigate Using Bookmarks
        • Search for a Specific Text
        • Switch Display Mode
        • Zooming
      • Content Editing
      • Passing Parameter Values
      • Printing
      • [Exporting]
        • Export a Document
        • CSV-Specific Export Options
        • HTML-Specific Export Options
        • Image-Specific Export Options
        • MHT-Specific Export Options
        • PDF-Specific Export Options
        • RTF-Specific Export Options
        • Text-Specific Export Options
        • XLS-Specific Export Options
        • XLSX-Specific Export Options
        • DOCX-Specific Export Options
      • Editors
    • Work with Dropdown Editors
    • Editing Values, Selecting Text and Using the Clipboard
    • Editor Context Menu
    • Masked Input
    • Calendar
      • Fast Navigation Window
      • Date Selection
    • Captcha
    • Color Edit
      • Custom Color Picker
    • Date Edit
    • Image Uploading
    • Token Box
    • Track Bar
      • Track and Scale Clicks
      • Change Buttons Clicks
      • Dragging Bar Highlight
      • Drag Handle Drag-n-Drop
    • Validation Summary
      • File Manager
    • File and Folder Editing
    • Filtering Files
    • Multiple File Selection
    • Uploading Files
    • Downloading Files
    • Details View
    • Access Control
    • Adaptive Layout
      • File Upload Control
    • Uploading a Single File
    • Uploading Multiple Files
    • Canceling File Uploading
    • Multi-File Selection
      • Filter Editor
    • Create New Conditions in Filter Editor
    • Change Conditions in Filter Editor
    • Delete Conditions in Filter Editor
      • Grid
    • [Data Editing]
      • Add and Delete Grid Rows
      • Save or Discard Changes when Editing Grid Rows
      • Switch a Grid to Edit Mode
      • Batch Editing
    • [Selection and Navigation]
      • Page Navigation in Grids
      • Select Grid Rows
      • Keyboard Navigation
    • [Expand and Collapse Group Rows]
      • Expand and Collapse Group Rows
    • [Sorting]
      • Sort Grid Rows
    • [Grouping]
      • Group Grid Rows
    • [Filtering]
      • Date Range Header Filter
      • Filtering Grid Data
      • Search Panel
      • Creating Complex Filter Criteria with the Filter Control
    • [Context Menu]
      • Context Menu
    • [Layout Customization]
      • Hide and Display Grid Columns
      • Reorder Grid Columns
    • [Customization Dialog]
      • Sorting Page
      • Grouping Page
      • Filtering Page
      • Column Chooser
    • [Responsive Layout]
      • Responsive Layout
    • [Grid Lookup]
      • Grid Lookup
      • Filter Grid Lookup Data
      • Select Grid Lookup Rows
      • HTML Editor
    • [HTML Editor User Interface]
      • Ribbon
      • View Modes
      • Context Menu
      • Toolbar
      • Search Panel
      • Tag Inspector
    • [Formatting Text]
      • Make Text Bold in HTML Editor
      • Apply Italic Formatting in HTML Editor
      • Underline Text in HTML Editor
      • Apply Strikethrough Formatting in HTML Editor
      • Change Foreground Color in HTML Editor
      • Change Background Color in HTML Editor
      • Change Font Type in HTML Editor
      • Change Font Size in HTML Editor
      • Make Text Superscript or Subscript in HTML Editor
      • Remove Formatting in HTML Editor
    • [Formatting Paragraphs]
      • Text Indentation in HTML Editor
      • Text Alignment in HTML Editor
      • Paragraph Styling in HTML Editor
      • Ordered and Bullet Lists in HTML Editor
    • Paste Formatting
    • [Find and Replace Dialog]
      • Find and Replace Dialog
    • [Working with Hyperlinks]
      • Create a Hyperlink in HTML Editor
      • Modify a Hyperlink in HTML Editor
      • Remove a Hyperlink in HTML Editor
    • [Working with Tables]
      • Create a Table in HTML Editor
      • Remove a Table in HTML Editor
      • Modify a Table in HTML Editor
    • [Working with Images]
      • Insert an Image in HTML Editor
      • Modify an Image's Settings in HTML Editor
      • Image Settings
    • [Working with Audio Files]
      • Insert an Audio Into HTML Editor
      • Modify Audio Settings in HTML Editor
      • Audio Settings
    • [Working with Flash Files]
      • Modify Flash Settings in HTML Editor
      • Insert a Flash Into HTML Editor
      • Flash Settings
    • [Working with Video Files]
      • Modify Video Settings in HTML Editor
      • Insert a Video Into HTML Editor
      • Video Settings
    • [Working with YouTube Video]
      • Modify YouTube Video Settings in HTML Editor
      • Insert a YouTube Video Into HTML Editor
      • YouTube Video Settings
    • [Miscellaneous Operations]
      • Repeat and Undo Actions in HTML Editor
      • Printing HTML Editor Content
      • Clipboard Operations in HTML Editor
      • Check Spelling in HTML Editor
      • Sizing and Full-Screen Mode
      • Export HTML Editor Content to Various Documents Formats
      • Shortcuts
      • Image Gallery
    • Fullscreen Viewer
    • Image Gallery Pager
      • Image Slider
      • Image Zoom
    • Fullscreen Window
    • Navigation Bar
      • Menu
    • Menu Scrolling
    • Responsive Layout
      • Navigation Bar
      • News Control
      • Pivot Table
    • Data Presentation
      • Sort Data in Pivot Tables
        • Simple Sorting
        • Sort Data Using a Field List
        • Sort Data by Summaries
      • Filter Data in Pivot Tables
        • Filter Data by Field Values
          • Invoke a Filter Popup Window
          • Using Filter Popup Windows
        • Build Complex Filter Criteria
    • Layout Customization
      • Expand and Collapse Groups in Pivot Tables
      • Hide Pivot Table Fields
        • Hide Fields Using the Context Menu
        • Hide Fields Using a Field List
      • Display Hidden Pivot Table Fields
      • Reorder Pivot Table Fields
        • Simple Fields Reordering
        • Reorder Fields Using a Field List
    • Field List Overview
      • Invoke a Field List
      • Defer Pivot Table Updates
      • Change Field List Layout
      • Popup Window
      • Rating
      • Report Designer
    • Report Types
      • Table Report
      • Multi-Column Report
      • Label Report
      • Parameterized Report
      • Cross-Tab Report
      • Drill-Down Report
      • Chart with Static Series
      • Chart with Dynamic Series
      • [Master-Detail Report (Subreports)](/interface-elements-for-web/articles/report-designer/report-types/master-detail-report-(subreports).md)
      • [Master-Detail Report (Detail Report Bands)](/interface-elements-for-web/articles/report-designer/report-types/master-detail-report-(detail-report-bands).md)
      • Master-Detail Report
    • Creating Reports
      • Basic Operations
        • Create a New Report
        • Create Report Elements
        • Change Measurement Units of a Report
        • Adjust the Layout of Report Elements
        • Adjust Page Layout Settings
      • Providing Data
        • Bind a Report to Data
        • Bind Report Controls to Data
        • Report Parameters
        • Query Parameters
        • Calculated Fields
      • Shaping Data
        • Grouping Data
        • Sorting Data
        • Filtering Data
        • Calculating Summaries
        • Formatting Data
      • Appearance Customization
        • Understanding Style Concepts
        • Use Odd and Even Styles
        • Conditionally Change a Control's Appearance
        • Conditionally Change a Label's Text
        • Conditionally Hide Bands
      • Report Navigation and Interactivity
        • Create a Document Map with Bookmarks
        • Create a Table of Contents
        • Create Hyperlinks
        • Add a Cross-Reference
        • Enable Content Editing in Print Preview
      • Add Details about a Report
        • Add Page Numbers and System Information to a Report
        • Create or Modify Watermarks of a Report
      • Scripting
    • Report Elements
      • Report Controls
      • Report Bands
    • Interface Elements
      • Design Surface
      • Field List
      • Main Toolbar
      • Menu
      • Properties Panel
      • Query Builder
      • Report Explorer
      • Toolbox
      • Custom SQL Editor
      • Expression Editor
      • Filter Editor
      • Format String Editor
      • Master-Detail Relation Editor
      • Script Editor
    • Wizards
      • SQL Data Source Wizard
        • Adding a New Data Source
          • Choose a Data Connection
          • Create a Query or Select a Stored Procedure
          • Configure Query Parameters
          • Configure Master-Detail Relationships
        • Editing an Existing Data Source
          • Create a Query or Select a Stored Procedure
          • Configure Query Parameters
      • Report Wizard
        • Choose a Report Type
        • Empty Report
        • Data-bound Report
          • Choose a Data Source
          • Choose a Table or View
          • Choose Columns
          • Create Groups
          • Choose Summary Options
          • Choose a Report Layout
          • Choose a Report Style
          • Specify the Report Title
        • Label Report
          • Choose the Label Type
          • Specify the Label's Parameters
    • Document Preview
      • Preview Toolbar
      • Export Options Panel
      • Search Panel
      • Document Map Panel
      • Preview Parameters Panel
      • Ribbon
    • Minimizing the Ribbon
    • [Gallery Bar]
      • Gallery Bar
    • Invoke Ribbon Commands
      • Rich Text Editor
    • [Text Editor UI]
      • Editor Elements
      • Ribbon Interface
    • [File Operations]
      • Create a New Document
      • Load a Document
      • Print a Document
      • Save a Document
    • [Document Layout and Page Setup]
      • Divide a Documents into Sections
      • Adjust Page Settings
      • Lay Out Text in Columns
    • [Viewing and Navigating]
      • Navigate through a Document
      • Show Horizontal Ruler
      • Full Screen Mode
    • [Text Editing]
      • Select Text
      • Delete Text
      • Cut, Copy and Paste Editor's Content
      • Undo and Redo Last Operations
    • [Formatting]
      • Format Text
      • Format Paragraphs
      • Using Tabs
      • Using Indents
      • Apply Predefined Styles
    • [Pictures and Text Boxes]
      • Insert, Select, Copy or Delete a Picture or Text Box
      • Move a Picture or Text Box
      • Resize a Picture or Text Box
      • Rotate a Picture or Text Box
      • Wrap Text Around a Picture or Text Box
      • Add, Change or Delete a Border for a Picture or Text Box
      • Add, Change or Delete a Text Box Fill
    • [Lists]
      • Numbered Lists
      • Bulleted Lists
      • Multilevel Lists
    • Mail Merge
    • Keyboard Shortcuts
      • File Operations
      • Navigation inside Documents
      • Work with Selections
      • Copy, Paste and Edit the Content
      • Text Formatting
    • [Miscellaneous]
      • Insert a Page Break
      • Insert a Hyperlink
      • Insert a Symbol
      • Round Panel
      • Scheduler
    • [Appointment Management]
      • Create an Appointment
      • Edit an Appointment
      • Manage Reminders
      • Make a Series of Recurring Appointments
      • Delete an Appointment
      • Restrictions for Operations with Appointments
    • [Layout Customization]
      • Switch Scheduler Views
      • Scheduler Grouping
    • [Selection and Navigation]
      • Navigate Time Cells and Dates in the Scheduler
      • Navigate Scheduler Resources
      • Scheduler Navigation Buttons
      • Scheduler 'More' Buttons
      • Spell Checker
      • Splitter
    • Resizing a Pane
    • Expand or Collapse a Pane
      • Spreadsheet
    • [Spreadsheet UI]
      • Ribbon Interface
      • Spreadsheet Elements
    • [File Operations]
      • Create a Workbook
      • Load a Workbook
      • Create a Worksheet
      • Rename a Worksheet
      • Delete a Worksheet
      • Save a Workbook
      • Import Text Files
      • Print a Workbook
      • Adjust Page Settings
      • Undo and Redo Last Actions
    • [Viewing]
      • Hide and Display Worksheets
      • Hide Gridlines
      • Full Screen Mode
    • [Editing Cells]
      • Select Cells or Cell Content
      • Copy and Paste Cell Content
      • Fill Data Automatically
      • Find and Replace
      • Insert a Comment
    • [Cell Formatting]
      • Format Cells
      • Format Cell Content
      • Wrap Text and Merge Cells
      • Number Formatting
      • Clear Cell Formatting
    • [Columns and Rows]
      • Insert and Delete Rows and Columns
      • Show and Hide Columns and Rows
      • Specify Column Width and Row Height
    • [Data Presentation]
      • Sort Data
    • [Formulas]
      • Create a Simple Formula
      • Cell References
      • Using Functions in Formulas
      • Supported Functions
      • Error Types in Formulas
    • [Charting]
      • Charting Overview
      • Creating a Chart
      • Changing a Chart Type
      • Applying a Predefined Chart Layout and Style
      • Modifying a Chart Manually
    • [Pictures and Hyperlinks]
      • Insert a Picture
      • Move and Resize a Picture
      • Insert and Delete Hyperlinks
    • Keyboard Shortcuts
      • File Operations
      • Navigation inside Worksheets
      • Work with Selections
      • Copy, Paste and Edit the Cell Content
      • Cell Formatting
      • Work with Columns and Rows
      • Tab Control
    • Tab Scrolling
      • Tree List
    • Edit Tree List Cells
    • [Data Presentation]
      • Expand and Collapse Tree List Nodes
      • Sort Nodes in Tree List
    • [Filtering]
      • Header Filter
      • Date Range Header Filter
      • Data Filter Row
      • Search Panel
      • Creating Complex Filter Criteria with the Filter Control
    • [Layout and Navigation]
      • Selection and Navigation in Tree List
      • Reorder Columns in Tree Lists
      • Reorder Tree List Nodes
      • Keyboard Navigation
      • Field Chooser
      • Tree View
    • Expand and Collapse Tree View Nodes
    • Tree View Nodes Checking
      • Vertical Grid
    • [Data Editing]
      • Add, Delete and Recover Records
      • Switching a Vertical Grid to Batch Edit Mode
      • Save or Discard Changes when Editing Grid Records
      • Batch Editing
    • [Selection and Navigation]
      • Page Navigation
      • Select Records
    • [Filtering]
      • Creating Complex Filter Criteria with the Filter Control
      • Header Filter
      • Search Panel
    • Sorting
    • Expand and Collapse Category Rows
  • Published with GitBook

Ribbon Interface

Ribbon Interface

The comprehensive functionality of the Spreadsheet is provided by a set of Ribbon pages. Ribbon pages are divided into logical groups that include commands with common features. Use the Ribbon interface to perform basic operations in the Spreadsheet (to create a workbook, create or delete worksheets, select data in a worksheet, navigate through a worksheet, etc.).

File

EUD_ASPxSpreadsheetFileTab

Create a Workbook

Load a Workbook

Save a Workbook

Print a Workbook

Home

EUD_ASPxSpreadSheet_HomeTab

Undo and Redo Last Actions

Copy and Paste Cell Content

Format Cells

Format Cell Content

Wrap Text and Merge Cells

Number Formatting

Clear Cell Formatting

Insert and Delete Rows and Columns

Show and Hide Columns and Rows

Specify Column Width and Row Height

Fill Data Automatically

Find and Replace

Insert

EUD_ASPxSpreadsheet_InsertTab

Insert a Picture

Move and Resize a Picture

Insert and Delete Hyperlinks

Charting Overview

Creating a Chart

Changing a Chart Type

Applying a Predefined Chart Layout and Style

Modifying a Chart Manually

Page Layout

EUD_ASPxSpreadsheet_PageLayoutMenu

Adjust Page Settings

Formulas

EUD_ASPxSpreadsheet_FormulasMenu

Create a Simple Formula

Cell References

Using Functions in Formulas

Supported Functions

Error Types in Formulas

Data

EUD_ASPxSpreadsheet_DataMenu

Sort Data

View

EUD_ASPxSpreadsheet_ViewMenu

Hide Gridlines

Full Screen Mode

results matching ""

    No results matching ""