 |
|
 |
|
|
AJAX Support -
[View Sample]
AJAX allows the component to refresh without refreshing the entire page. This
affects several features including expanding and collapsing child sheets in a
hierarchical display, column sorting, inserting rows, searching, filtering,
paging, and formulas.
|
|
Row filtering -
[View Sample]
You can customize the user experience for filtering data on a sheet. With row
filtering, you can allow the user to filter the data in columns on a sheet and
display only the rows of data which meet criteria from a drop-down list or
change the appearance of rows based on that filtering. |
|
|
| |
|
|
|
|
| |
|
|
|
|
 |
|
 |
|
|
Searching -
[View Sample]
You can search for data in any of the cells in the workbook by specifying the
sheet and the string of data for which to search. You also have several
searching options you can choose from.
|
|
Frozen Rows and Columns -
[View Sample]
Using Microsoft Internet Explorer (IE) 5.5 and higher, you can freeze columns
and rows and keep them displayed regardless of where the user navigates in the
sheet. Frozen rows and frozen columns do not scroll when the user uses the
scroll bar or navigation keys in the component. |
|
|
| |
|
|
|
|
| |
|
|
|
|
 |
|
 |
|
|
Grouping -
[View Sample]
You can set up the display to allow Outlook-style grouping of rows. For large
amounts of data, this is helpful to display the data in the order the user
needs. The user selects columns by which to sort and the component then
organizes and displays the data in a hierarchy with rows organized accordingly. |
|
Load on Demand-
[View Sample]
You can allow the Web page to load on demand -- as the user scrolls further
down the spreadsheet the FarPoint Spread component on the client loads another
page of rows from the server as needed. This is similar to what was called
"virtual mode" in the COM version of the product. |
|
|
| |
|
|
|
|
| |
|
|
|
|
 |
|
 |
|
|
Conditional Formatting -
[View Sample]
You can set up conditional formats within cells that determine the formatting
of the cell based on the outcome of a conditional statement. You can use a
named style to specify various formatting options such as borders and colors to
apply if the condition statement is valid, that is, if the operation is
satisfied.
|
|
Drag and Move Columns -
[View Sample]
Moving columns just got easier.You can allow your users to click on the header
of a column and drag it to another location on the spreadsheet. You can set
this with the AllowColumnMove property in the FpSpread class.
|
|
|
| |
|
|
|
|
| |
|
|
|
|
|
|
 |
|
|
Hierarchy -
[View Sample]
Display multiple levels of data because datasets are getting deeper. |
|
More Than 300 Built-in Functions -
[View Sample]
Add calcuations quickly to your web applications by using any of over 300
pre-defined algorithims or add your own custom functions. Spread now supports
cross-sheet formula referencing. |
|
|
| |
|
|
|
|
| |
|
|
|
|
 |
|
 |
|
|
Insert and Edit
Allow or prohibit users from inserting and editing data in columns, rows, or
cells. |
|
Custom Messages
Display custom error messages when invalid data has been entered (for example,
entering text into a date-time cell). |
|
|
| |
|
|
|
|
| |
|
|
|
|
 |
|
 |
|
|
Command Bar-
[View Sample]
A customizable button bar provides an easy and intuitive way for your users to
edit, delete, and insert data, control sheet navigation, and control paging.
This can be positioned on the top or bottom of the control. |
|
Page Navigation-
[View Sample]
Customize the navigation of multiple pages of data by displaying page numbers,
next and previous arrows, or both. It can be positioned on the top and/or
bottom of Spread or on the Command Bar. |
|
|
| |
|
|
|
|
| |
|
|
|
|
 |
|
 |
|
|
Sheets- [View
Sample]
Each control can contain multiple sheets, similar to Microsoft Excel, allowing
you to organize your information on one convenient screen. You can also hide
sheets. |
|
Binding- [View
Sample]
Bind Spread to a dataset to quickly display and easily allow your users to edit
the information. Spread can automatically update the dataset with the changes.
Spread can bind to any data source that supports the IList or IListSource
interface. |
|
|
| |
|
|
|
|
| |
|
|
|
|
 |
|
 |
|
|
Unbound- [View
Sample]
Use in unbound mode to populate columns, rows, and cells using your own data
and custom formatting. |
|
Text Tips
Display custom text tips over any column, row, or cell to display additional
information to help your user. |
|
|
| |
|
|
|
|
| |
|
|
|
|
 |
|
 |
|
|
Multiple Data Changes
Allow multiple data changes, even on multiple rows, without a having to round
trip to the server to save your changes. |
|
Client-Side Data Validation-
[View Sample]
Client-side data validation reduces unnecessary round trips to the server by
validating the entered data on the client side before it gets posted back. |
|
|
| |
|
|
|
|
 |
|
 |
|
|
Named Appearance 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 the
coding and allows you to easily modify the master style and it will update all
related styles accordingly. |
|
Predefined and Custom Skins-
[View Sample]
Easily and quickly configure the appearance of Spread using predefined skins or
create and save your own custom skins. Custom skins can easily be shared with
everyone in your development team, allowing a consistent look of the control
across multiple pages and applications. |
|
|
| |
|
|
|
|
| |
|
|
|
|
 |
|
|
|
|
Sort- [View
Sample]
Automatically sort any column in ascending or descending order by double
clicking on the header, or programatically sort any range of cells. |
|
Client Scripting
Create a rich user experience for your users using the client scripting,
allowing the editing of values without having to round trip to the server, as
well as many other user-friendly benefits. |
|
|
| |
|
|
|
|
| |
|
|
|
|
 |
|
 |
|
|
HTML tables
Use Spread as a replacement for HTML tables, giving you full access to Spreads'
advanced formatting options. |
|
Customization-
[View Sample]
Customize the gridlines, odd/even row colors, colors of the selected item,
scrollbar color, cell spacing and much more. |
|
|
| |
|
|
|
|
 |
|
 |
|
|
Operation Modes-
[View Sample]
Use the Operation Modes to control how selections can be made:
Normal, ReadOnly, RowMode, or SingleSelect. |
|
Objects
You have complete control over the design of Spread by using the Sheet, Row,
Column and Cell objects. |
|
|
| |
|
|
|
|
| |
|
|
|
|
 |
|
 |
|
|
Spans
Add spans to headers, rows, columns or cells. |
|
Multiple Headers-
[View Sample]
Add multiple rows and columns to the headers. |
|
|
| |
|
|
|
|
 |
|
 |
|
|
Cell Customization
Complete customization at the cell level, including setting cell types, tags,
alignment, borders, colors, font and margins. |
|
Spread Designer
Use the Spread Designer to reduce development time by allowing you to fully
customize the look and feel of the control at design time using an intuitive,
easy-to-use interface. |
|
|
| |
|
|
|
|
| |
|
|
|
|
Import / Export Data-
[View Sample]
Import/export Microsoft Excel 97 and higher files and text files. Export to
Spread XML. |
|
Publish Excel Workbooks Online
Easily publish your existing or new Microsoft Excel 97 and higher workbooks
online by using Spread's Excel import and export feature. |
|
|
| |
|
|
|
|
Dual Programming Models
Program directly against Spread's data and style models for maximum control and
speed or use the included Helper Objects for a more intuitive approach. |
|
Multiple Browsers
Unlike other grids, we recognize the possibility that not every one of your
users will be using MS Windows Internet Explorer 6.0. We have done extensive
testing with other browsers and versions and, when possible, have added support
for these as well. Try that with your current grid! |
|
|