Spreadsheet

The Spreadsheet emulates Microsoft Excel capabilities and allows you to create, load, edit, save, and print spreadsheet documents.

A workbook is a spreadsheet document. When you open the Spreadsheet , it contains a workbook with one empty worksheet (“Sheet1”).
Worksheet is a single page within a workbook. You can create, rename, move, copy, hide, or delete worksheets.

You can create a new documents or load load an existing file, see Supported File Formats topic
The Spreadsheet allows you to save modified data to a file or export your document to PDF and HTML
Here are only key features of the spreadsheet, for very detailed description please refer to Microsoft Excel manual.
 

Rows and Columns

Worksheets in the Spreadsheet display 1,048,576 rows and 16,384 columns (the number of rows and columns in spreadsheet management programs such as Microsoft Excel).
The number of rows and columns is permanently fixed.
Rows and columns have headings in a worksheet (rows are numbered - “1”, “2”, “3”,…, “1048576”, and columns are lettered - “A”, “B”, “C”,…,”XFD”).
You can insert, copy, hide, freeze, resize, or remove rows and columns.

Cells and Cell Ranges

All worksheet data is shown in cells. Each cell can only hold and display a single piece of data - the cell value.
Cells can contain different values: numbers, dates, text, logical values, and formulas.
An individual cell is a box at the intersection of a column and row.  For example, C3 refers to a cell that belongs to column C and row 3
 
Formulas and Functions

You can create formulas and perform calculations of any complexity. The Spreadsheet has the Formula Bar that allows you to view, enter, and edit formulas.The Spreadsheet supports over 400 built-in functions designed to address a broad range of usage scenarios. You can use basic mathematical functions to aggregate data within a spreadsheet or create complex formulas with statistical, engineering, and financial functions.

Defined Names

To make it easier to understand the information contained in a worksheet and refer to individual cells, ranges of cells, formulas and constant values, you can use defined names.

You can define descriptive names for cells, formulas, and constants to make your formulas easier to understand and maintain.

The Spreadsheet has the Name Box and Name Manager that allow you to create, view, edit, and delete names.

Shapes and Pictures

The Spreadsheet allows you to add shapes and pictures to worksheets. All shape types are supported: from simple lines and rectangles to 3D shapes with advanced effects.

Charts and Sparklines

You can create charts and sparklines to visualize data in your documents. The Spreadsheet supports a broad range of 2D and 3D charts: from the commonly used Column and Line charts to modern Excel 2016 charts (Box and Whisker, Histogram, Pareto, Waterfall, Treemap, Sunburst, and Funnel).

Tables

The Spreadsheet allows you to convert a cell range into a table. Use tables to manage worksheet data more effectively: sort and filter table data, bind a table to a data source, create calculated columns, display a total row, and use table names in formulas. You can apply a predefined or custom style to a table to change its appearance.

You can convert a cell range into a table. Spreadsheet tables allow you to manage data more effectively: you can sort and filter table data, use table names in formulas, create a calculated column, display the total row, and so on.

Pivot Tables

Create Excel-inspired Pivot Tables to summarize and analyze large amounts of data in your document. Pivot Tables are highly flexible and interactive. You can easily change the report layout and specify advanced Pivot Table options to create a summary table that fully addresses your requirements.

Threaded Comments

Use comments to attach additional information to worksheet cells.
You can add comments to a spreadsheet cell and reply to existing comments. Discussions can take place within the context of the cell, without the need to switch to another communication tool (email, instant messaging, or project management software).

Hyperlinks

Insert hyperlinks into worksheet cells to navigate to a web page or a specific location in a workbook.

Organize and Shape Data

The Spreadsheet supports the following features that help you manage and organize data more effectively:

Sort data in a cell range or table in ascending or descending order.

Filter data in a cell range or table to display only rows that meet specific criteria. Different types of filters are available: Text Filters, Number Filters, Date Filters, and Filter by Values.

Group rows and columns and display summary information for each group. You can group data manually, create an automatic outline based on summary formulas, or calculate subtotals for related rows.

Protect and Encrypt Data

The  Spreadsheet allows you to protect your documents to prevent unauthorized access. Security options include:

Restrict changes to workbooks and worksheets. Protect the workbook structure and lock cells in a worksheet so that you can execute only specific actions.

Grant user permissions. Unlock specific cell ranges in a protected worksheet for authorized you.

Encrypt a document with a password. The Spreadsheet uses 256-bit AES encryption for XLSX files and the custom RC4 CryptoAPI implementation for XLS files.

Configure which actions are available to you. Unavailable operations are disabled or hidden in the ribbon UI and corresponding context menus.

Print Documents

You can print documents in code or use the built-in Print dialog. Invoke the Preview window to preview your document before printing.

The Page Setup dialog allows you to customize page settings, specify page margins, add headers and footers, set a print area, and define rows and columns to repeat on every page.

Mail Merge

The  Spreadsheet supports Mail Merge operations. Use Mail Merge to automatically generate personalized letters and business-centric reports of any complexity. Merged documents are generated based on a template that is bound to a data source. The Spreadsheet control’s Mail Merge tools allow you to visually design templates and preview mail merge results on-the-fly. You can save data-bound templates to XLSX and XLS files and reuse them later to quickly create new documents and reports.