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
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
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
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
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).
"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
Outlines
Arrange related columns or rows into groups and display summaries for each group.
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
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
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
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.