 |
|
 |
|
|
Multiple Sheets
Use Multiple Sheets to categorize your information, similar to Microsoft Excel. |
|
Bound Mode
Use in Bound mode to connect to your favorite data source to display and edit
information. |
|
|
| |
|
|
|
|
| |
|
|
|
|
|
|
 |
|
|
Hierarchical view
Display your data in Hierarchical view or Flat view. |
|
Multiple Panes
Display data in multiple panes and allow your user to customize their own pane
view.
|
|
|
| |
|
|
|
|
| |
|
|
|
|
 |
|
 |
|
|
Grouping
Allow Outlook-style grouping with any number of levels |
|
Undo/Redo
The undo/redo feature allows you to add capability to your application to undo
various actions in the spreadsheet performed by your end user. |
|
|
| |
|
|
|
|
| |
|
|
|
|
 |
|
 |
|
|
Control Layer
You can place any control, including other 3rd party controls, on a
sheet that resides on a separate control layer to provide more interaction with
the user. This is in addition to the data area where cells are and drawing
layer where shapes and other graphical elements are located.
|
|
Annotation mode
You can add free-hand drawing to the drawing layer of the sheet using
annotation mode. Annotation mode allows the user to draw in free-hand mode on
the shapes layer and to save the annotation on the sheet as a shape.
|
|
|
| |
|
|
|
|
| |
|
|
|
|
 |
|
 |
|
|
Sort
Programmatically sort data by rows, columns, a range of rows, a range of
columns or a range of cells. Or, allow your users to easily auto sort columns
simply by clicking on the column header. |
|
320 Built-in Functions
Use the 320 built-in functions or create your own custom functions for Spread's
advanced Calc Engine to evaluate, including cross-sheet formula referencing. |
|
|
| |
|
|
|
|
| |
|
|
|
|
 |
|
 |
|
|
Drawing shapes
You can use shapes to make draw attention to parts of your spreadsheet or
emphasize some information or process involving the use of the spreadsheet.
There are several built-in shapes for you to use or you can create your own
shape. Each shape can be rotated and resized, and their ability to be rotated
and resized by the end user can be constrained. |
|
Row filtering
Programmatically sort data by rows, columns, a range of rows, a range of
columns or a range of cells. Or, allow your users to easily auto sort columns
simply by clicking on the column header. |
|
|
| |
|
|
|
|
| |
|
|
|
|
 |
|
 |
|
|
Printing
Specify print ranges and print your spreadsheet data using the optional print
preview.
|
|
Unbound Mode
Use unbound to display and edit any data - no datasource needed.
|
|
|
| |
|
|
|
|
| |
|
|
|
|
 |
|
 |
|
|
Cell Spans
Create cell spans to join cells together, allowing one cell to span across
multiple cells to include, for example, your company logo. |
|
Operation Modes
Use the Operation modes to determine how your user can interact with Spread:
Normal, ReadOnly, RowMode, SingleSelect, MultiSelect,
ExtendedSelect. |
|
|
| |
|
|
|
|
| |
|
|
|
|
 |
|
 |
|
|
Named Styles
Create Named Styles to define a certain style (for example; fonts, colors, cell
types, etc.) and share the style with other cells. This greatly reduces your
coding time and allows you to easily modify the master style so that it will
update all related styles accordingly. |
|
Intuitive Spread Designer
Use the Spread Designer to save valuable development time by quickly adding
data and easily designing the look of the Spread component with no coding
required. |
|
|
| |
|
|
|
|
| |
|
|
|
|
 |
|
 |
|
|
Zoom
Zoom in and out of the spreadsheet data. |
|
Enhanced Scrolling
Use the scrollbar tracking feature to quickly see what row you are on while
scrolling through Spread's data. |
|
|
| |
|
|
|
|
 |
|
 |
|
|
Skins
Use any of the built-in skins to apply a consistent look across controls or
quickly create and use your own custom skin. Your custom skin can be shared
with your fellow developers to use across the company. |
|
Selections
Allow or prevent your user from selecting rows, columns, blocks of cells, or
multiple blocks of cells. |
|
|
| |
|
|
|
|
| |
|
|
|
|
 |
|
 |
|
|
Objects
Use the Column, Row and Cell objects to quickly take advantage of Spread's
extensive feature set. |
|
Multiple Line Headers
Use multiple line headers to better organize your column and row information |
|
|
| |
|
|
|
|
|
|
|
|
|
 |
|
 |
|
|
Open
Open Microsoft Excel files, Spread 6/7 files, Spread XML files, and Text
delimited files. |
|
Save
Save to Microsoft Excel, Spread XML, HTML, XML and Text delimited files. |
|
|
| |
|
|
|
|
| |
|
|
|
|
| |
|
 |
|
|
Cell Extensibility
In addition to our included cell types, you can create and use your own custom
cell type. For example, you could display another Spread inside a cell, use
another control or create your own custom control to display and use. |
|
Gradients, Background Images and Alpha Blending
Spread supports background images, alpha blending, and transparent background
colors. This allows you to place background pictures in cells, on Spread so all
cells bleed through the image, or even place an image on the form and have the
image show through Spread. |
|
|
| |
|
|
|
|
| |
|
|
|
|
 |
|
 |
|
|
Enhanced Keyboard Mapping
You have complete control over how your spreadsheet will react when the user
presses any key, including function keys. For example, your could move the
focus to the next cell below when the Enter key is pressed or bring up your own
custom editor or a calendar when the user presses the F4 key when in a datetime
cell. |
|
Merge Cells
Automatically merge cells that contain identical information for easier viewing
of your data. |
|
|
| |
|
|
|
|
 |
|
 |
|
|
Cell Overflow
Allow cell contents to overflow to adjacent cells if the data is too long to be
displayed in the cell. |
|
Cell Notes
Display pop-up cell notes, which contain your own custom text, over any cell. |
|
|
| |
|
|
|
|
 |
|
 |
|
|
All The Things You Expect
Apply fonts, borders, and colors to an individual cell, range of cells or
specified columns and rows. |
|
AlternatingRows
Easily customize the display by using AlternatingRows to apply your own
distinct look. |
|
|
| |
|
|
|
|
 |
|
 |
|
|
Full Clipboard Support
Including special paste features that you are used to in Excel. |
|
Security
Add security to your data by locking cells from being edited and protecting
sheets. |
|
|
|
|
|
|
|
| |
|
|
|
|
Microsoft Excel Look and Feel
If your users are familiar with Excel, they will be comfortable using Spread. |
|
Extensible Models
Spread's Models allow extensive customization. |
|
|
| |
|
|
|
|