WPF Spreadsheet (SfSpreadsheet) Overview

23 Jul 20263 minutes to read

The WPF Spreadsheet (SfSpreadsheet) is an Excel-inspired control that lets you create, edit, view, and format Microsoft Excel files without Excel installed. It provides a polished UI with an integrated ribbon to cover any possible business scenario. SfSpreadsheet includes a built-in calculation engine that supports 400+ widely used formulas.

SfSpreadsheet

Key Features

  • Ribbon – A fully featured ribbon with an enhanced UI experience.

  • Editing and Selection – Interactive support for editing and cell selection in the workbook.

  • Formulas – Provides support for 400+ widely used formulas that any business user needs, and lets you add, remove, and edit them like in Excel.

  • Name Manager – Supports the name ranges in the formulas. By using named ranges, you can assign a name to a cell range and then use it in formulas without the hassle of remembering cell locations.

  • Data validation – Ensures data integrity by requiring end users to enter valid data. If the entered data does not meet the specified criteria, an error message is displayed.

  • Floating Cells – Supports floating cell mode where text that exceeds the cell width flows into the adjacent cell.

  • Merge Cells – Merges two or more adjacent cells into a single cell that displays the contents of one cell in the merged range.

  • Conditional Formatting – Provides Excel-compatible conditional formatting and lets you apply formats to a cell or range of cells based on cell values or formulas that meet specific criteria. Also supports defining and importing conditional formatting rules such as Data Bars, Icon Sets, and Color Scales to visualize the data.

  • Cell Comments – Supports comments that provide additional information about a cell, such as what the value represents. Useful for helping end users understand the data in cells more deeply.

  • Hyperlinks and Bookmarks – Supports importing, creating, and editing hyperlinks and bookmarks. A hyperlink is a convenient way to navigate or browse data within a worksheet or across worksheets in a workbook.

  • Undo/Redo – Provides support to undo or redo the changes made in the workbook.

  • Clipboard Operations – Provides support for cut, copy, and paste operations in the Spreadsheet.

  • Fill Series – Provides support to automatically fill cells with data that follows or completes a pattern.

  • Freeze Panes – Provides support to freeze rows and columns.

  • Resizing and Hiding – Provides interactive support to resize or hide/unhide the rows and columns.

  • Charts, Pictures, and Textboxes – Provides support to import charts, pictures, and textboxes.

  • Sparklines – Provides support to import Sparklines.

  • Outlines – Provides support to group or ungroup rows and columns.

  • Workbook and Worksheet Protection – Supports protecting worksheets and supports locking down the structure and window of a workbook, which prevents any structural changes or resizing of the workbook window.

  • Conversion – Provides support to export the workbook to PDF, HTML, Image, and CSV.

  • Zooming – Provides support to zoom in and zoom out of the worksheet view.

  • Localization – Provides support to localize all static text in the ribbon and all dialogs to any desired language.

  • Supported file types – Imports the following Excel formats: XLS, XLSX, XLSM, XLT, XLTX, and CSV (comma-delimited).