Learn More about Our VCL Spreadsheet

Learn More

Documents & Worksheets

Worksheet Protection

Use password encryption to prevent unauthorized access.

Worksheet Protection

The DevExpress VCL Spreadsheet control enables you to use password encryption to prevent unauthorized users from opening or modifying your workbooks. You can also restrict changes to workbooks, worksheets, and specific ranges. In a protected workbook, users are not allowed to add, delete or rename worksheets.

Various sheets can have different protection levels. For instance, a range in a protected worksheet can be unlocked for specific users while other users may be prompted for a password when they try to edit the range.

Comments

Excel-Inspired Comments

Comments

Comments
You can now annotate worksheets by using comments. End-users can add new comments, edit, hide or delete existing comments, move and resize the comment box.

Cell Formatting & Styles

Create professional-looking worksheets that display your data effectively.

Cell Formatting & Styles

Cell Formatting & Styles
The DevExpress Spreadsheet provides several fast and simple ways to create professional-looking worksheets that display your data effectively. You can use cell styles to apply predefined formats, and other manual formatting features to highlight important data.

Master-Detail

Display master-detail relationships of any complexity.

Master-Detail

Master-Detail
The DevExpress VCL Spreadsheet control allows you to create master-detail reports without writing code.

Printing, Export & Import

The easiest way to printing the contents of your workbook.

Printing, Export & Import

Printing, Export & Import

Turn the contents of your workbook into a printed report with a simple method call or using the Print Dialog. You can customize and preview print output using the Print Setup dialog.

The DevExpress Spreadsheet control supports the following file formats to import and export data:

  • XLS, XLSX;
  • CSV;
  • TXT;
  • XML (export only);
  • PDF (export only);
  • HTML (export only).
Requires the DevExpress Printing System.
"Of all of the tools that I purchase and maintain, the DevExpress tools are the most valuable. The price is reasonable, the tools are fabulous and your support, in the rare case that it is needed, is stellar." Al MoskowitzIntelliMedSoft

Data Analysis

Outlines

Arrange related columns or rows into groups and display summaries for each group.

Outlines

Outlines
Outlining data makes your data easier to view. When you outline Spreadsheet data, you group worksheet data into different levels based on column and row headings. You can quickly display as little or as much information by clicking the level symbols to the left of your worksheet.

Conditional Formatting

Highlight cell values for maximum data clarity.

Conditional Formatting

Conditional Formatting
The DevExpress Spreadsheet ships with Microsoft Excel inspired Conditional Formatting support. This powerful feature allows you to highlight cells based on specified criteria without writing a single line of code. Cells can be highlighted with data bars, icons and predefined color scales. At runtime, end-users can easily apply style conditions by activating the Spreadsheet's popup menu.

Sort Data

Sort data against an unlimited number of columns.

Sort Data

As you would expect, our VCL Spreadsheet supports sorting against an unlimited number of columns. You can sort data by text (alphabetically, according to the current culture), numbers, dates and time.

Functions

Numerous built-in functions and operators (mathematical, statistical, financial, logical, etc).

Functions

Functions

Numerous built-in functions and operators (mathematical, statistical, financial, logical, etc.) allow you to enter formulas and perform calculations of any complexity.

The VCL Spreadsheet API allows you to create your own functions. Custom functions are available for all spreadsheet calculations, and can be used in formulas. Custom functions are not saved in a workbook file, and should be added in code.

Text Search & Highlighting

Find / Replace

Text Search & Highlighting

Text Search & Highlighting
A simple and quick way to find cell values. The 'Find and Replace' dialog removes all complexities associated with data searching. This dialog allows users to enter a search string and initiate a search against all values displayed in the worksheet.

Try It Now!

Download our fully-functional 30-day trial today and
experience the DevExpress difference today.

 

Free 30 Day TrialDemos

Additional Info

The most powerful VCL Data Grid

The most popular data grid for the VCL platform is only available from DevExpress. From standard two-dimensional tables to runtime grouping and column customization; from master-detail relationships to card views; from integrated themes to unbound mode... The DevExpress VCL Grid Suite is the industry standard, without equal in the marketplace. Learn more

Straightforward Localization

DevExpress VCL Subscriptions ship with a localization component and a standalone Localizer Application, which allows end-users to generate translations for individual components. A number of ready-to-use translations have been published and can be downloaded via the DevExpress Support Center. Search the Support Center

The richest collection of VCL Data Editors

From masked data input and built-in data validation to HTML formatting, the VCL Data Editors Library offers unmatched data editing options whether used for standalone data editing or as cell editors in container controls like the DevExpress VCL Data Grid. Learn more

The easy-to-use VCL Reporting

Render and print your UI without writing a single line of code and deliver a nearly unlimited set of reports without using a banded report designer.

VCL Themes and App Skins

The DevExpress VCL Subscription ships with over 40 custom-designed and highly-polished themes for your next Delphi & C++Builder application.

Built-in, easy-to-use Application Templates

The DevExpress VCL Subscription includes a series of application templates so you can hit the ground running and create application shells that mimic some of today's most popular applications.

What's New

230+ VCL Controls

Multi-Purpose
Activity Indicator ControlBreadcrumb EditorCallout Popup ControlCloud Storage ControlsGallery ControlLocalizer EditorRTTI Object InspectorSkin EditorTaskbar ProgressToken EditorUI Adorner Manager
Layout & Windows UI
Checkbox GroupDocking ManagerGroup BoxLayout ManagerPage and Tab ControlsSplitterTabbed MDI ManagerTile ControlWizard Control
Analytics & Reporting
Filter ControlFlow ChartGauge ControlMap ControlOrg ChartPivot GridPrinting & ExportingSparkline EditorSpreadsheet Report Designer
Navigation
App MenusNavigation BarTile Bar ControlToolbarsTreeViewListView
Dialogs & Notifications
Alert WindowColor DialogShell Browser DialogPage Setup DialogPrint DialogPrint Preview Window
Miscellaneous
Barcode ControlCamera ControlIcon LibraryImage SliderOAuth2 Authorization Agents