FarPoint Spread for .NET Bundle - .NET Component

Überblick | Preise u. Lizenzierung | Evaluierungen u. Downloads | Kompatibilität | Herstellerinfo. | Rezensionen | Forum | Zusammenfassung

Bitte beachten Sie, diese Produktinformation ist nicht in deutscher Sprache verfügbar.
Easily present, edit and update tabular data in Windows Forms and ASP.NET applications. Spread for .NET Bundle includes Spread for Windows Forms and Spread for ASP.NET. Spread for Windows Forms includes the Spread Designer to allow developers and/or designers to quickly and easily design the look of the component at design time with no coding required. Spread for Windows Forms supports Microsoft Excel import/export. Spread for ASP.NET supports bound or unbound modes (no dataset needed), AJAX, native Microsoft Excel import/export, in-cell editing, multiple edits on multiple rows without server round trips, client-side column/row resizing, multiple sheets, searching, filtering, multiple cell types, validations, cell spans, multiple headers, sorting, complete customization at the cell level, over 300 built-in calculation functions, hierarchical display, Print to PDF and much more.

Unsere regulären Preise werden nachstehend angezeigt. Bitte melden Sie sich an um Ihre ermäßigten Preise zu sehen.

Spread for .NET Bundle (Includes Spread for ASP.NET V4 and Spread for Windows Forms V4)

Spread for .NET Bundle with Maintenance (Includes Spread for ASP.NET V4 and Spread for Windows Forms V4)

Spread for .NET Bundle - Maintenance Renewal

Unsere Preise beinhalten einen technischen Support durch ComponentSource und für die meisten herunterladbaren Produkte zusätzlich ein Online-Backup sowie eine kostenlose Aktualisierung auf die neue Version, sofern sie binnen 30 Tagen nach dem Kauf freigegeben werden. Die angezeigten Preise sind zuzüglich aller Steuern. Für mehr Information zu eventuell anfallende Steuern, gehen Sie bitte auf diese Webseite. Alle Verkäufe unterliegen unseren Standardgeschäftsbedingungen und unseren Rückgaberegeln. Treten Sie bitte mit uns in Kontakt , wenn Sie eine Lizenzierungsoption anfordern möchten, die in der obigen Liste nicht aufgeführt ist, einschließlich Mehrplatzlizenzen und ältere Versionen.

Unsere regulären Preise werden oben angezeigt. Bitte melden Sie sich an um Ihre ermäßigten Preise zu sehen.

What's New in FarPoint Spread for Windows Forms 4.0?

• PDF Export: You can print a sheet to a Portable Document Format (PDF) file using the PrintToPdf method in the PrintInfo class. Use the PdfFileName property to specify the file name and location to which to save the file.
• Floating Formula Bar and Range Selection for Formula: You can set up a floating formula bar that end users can use to add formulas. The formula bar is similar to the formula editor available to the developer and has the appearance of a text box. The formula bar provides a list of calculation functions. It also provides a visual method of selecting cell ranges for the formula.
• Fractions (in Number Cell Type): The number cell can now display values in a fraction format such as 1/100. Set the FractionMode property of the number cell to display values in the fraction format. You can type values such as .01 (which will then display as 1/100) or you can type 1/100 in the cell.
• Barcode Cell Type: You can display a barcode graphic in a cell with the barcode cell. Various barcode types are available such as barcodes that are used in retail, the post office, etc. You can set various height and width properties for the barcode display.
• Range of Cells as a Data Source and Bind Data Source to Range
• Add Row (as in DataGrid)
• Automatic Completion (type ahead) for Cell in Column and Selects: You can provide automatic completion (type ahead) from user input to a cell. You would use the IAutoCompleteSupport interface and its properties to provide the automatic completion feature.
• Increased Performance
• Spread Designer Updates
• Color Picker Cell Type: You can allow your end user to select a color from a color picker using the color picker cell. A color picker cell displays a dialog for selecting a color. When a color picker cell is selected it displays a single color, which can appear either in a box or filling the entire area of the cell. Optionally text can be displayed.

What's New in FarPoint Spread for ASP.NET V4?

• Excel XLS 97-2007 import and export
• Microsoft Excel 2007 XML (Office Open XML) support
• Print to PDF
• Sleek new predefined skins and custom skins
• Multi-column listbox cell type
• Editing templates
• Support for AJAX Extenders
• Title/Subtitles for a sheet
• Drag/Move multiple columns
• New Designer and Wizards
• drag-and-drop integration with Visual Studio
• Display a single record on multiple rows
• Preview Row and row templates
• Add client side event handler through property window
• Display totals, data aggregation in the row/column footers

Spread for .NET Bundle includes Spread for Windows Forms and Spread for ASP.NET

Spread for ASP.NET Overview

Spread for ASP.NET offers excellent design time support for rapid development using the innovative Spread Designer and supports in-cell editing and validation. Complied against both the 2.0 and 3.5 Frameworks, Spread for ASP.NET supports bound or unbound modes (no dataset needed), AJAX, native Microsoft Excel import/export, in-cell editing, multiple edits on multiple rows without server round trips, client-side column/row resizing, multiple sheets, searching, filtering, multiple cell types, validations, cell spans, multiple headers, sorting, complete customization at the cell level, over 300 built-in calculation functions, hierarchical display and much more.

Spread for ASP.NET Main Features

AJAX Support: You can add AJAX support to the FpSpread component by setting the EnableAjaxCall property. This affects several features including expanding and collapsing child sheets in a hierarchical display, column sorting, inserting rows, paging, searching, filtering, and formula updates. If the ClientAutoCalculation property is true, then after a cell value is changed, an AJAX call is made to the FpSpread component. Then the component calculates the formulas and sends the values to the client side. The component then updates the values at the client side.

Microsoft Excel Compatibility: You can import data from and export data and formatting to Microsoft Excel in its native format, both individual spreadsheets and entire workbooks. You can save data to an Excel-formatted (BIFF8 format) file or stream. There are several SaveExcel methods each with several options. For instance, you can specify whether headers are saved with the data using the setting of the IncludeHeaders enumeration. You do not need Excel on the server for Spread to display your Excel files.

Row Filtering: 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. You can use the basic default filtering or you can customize practically every aspect of the filtering.

Spread for ASP.NET Formula Support: Spread includes a powerful calculation engine that allows you to quickly add formulas to your web applications by using any of over 300 pre-defined functions or you can add your own custom functions. Spread also supports cross-sheet formula referencing.

Frozen Rows & Columns: 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. This is useful if you need information in non-header rows or columns to stay visible regardless of where in the sheet the user navigates. Frozen rows and frozen columns are currently only supported with Microsoft Internet Explorer (IE) 5.5 and higher.

Spread for ASP.NET Grouping: 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.

Spread for ASP.NET Hierarchical View: Spread makes it easy to display and edit your hierarchical data. Simply set up your dataset with relations and set the HierarchicalView property to True. That's all it takes to display your data. You have full customization at the child level if you want to hide columns, change colors, etc. You can also choose from two hierarchy views: Hierarchical View and Parent Row View.

Spread for ASP.NET Importing and Exporting: Like any good spreadsheet, Spread supports the loading and saving of data. You can import/export Microsoft Excel 97 and higher files, text files (comma delimited, tab delimited, etc), and Spread files. This allows you to view or load your data in your favorite desktop application or, for example, you could create and load company templates on the fly.

Interaction: You can customize the Paging settings and the CommandBar settings that control how the user can interact with the spreadsheet.

Load on Demand: You can allow the Web page to load on demand -- as the user scrolls further down the spreadsheet the FarPoint Spread for ASP.NET 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. You can specify the number of rows to load initially and how many are added in subsequent loads. You can specify these properties at the component level (for FpSpread) or at the sheet level.

Move Columns: Spread for ASP.NET 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

Spread for ASP.NET Operation Modes: With these enumerations, you can set how much the user can interact with the sheet by controlling the ability to select a row and to edit a cell. Member Description

• Normal Allows users to perform default spreadsheet selecting and editing
• ReadOnly Allows users to see the data but not to select or edit any cell or row in the sheet
• RowMode Allows users to select (highlight) a single row only and to edit an individual cell in that row
• SingleSelect Allows users to select (highlight) a single row only but not to edit any cell
• MultiSelect Allows the user to select multiple contiguous rows in the spreadsheet (as one would in a multiple-select list box)
• ExtendedSelect Allows the user to select multiple discontiguous rows in the spreadsheet (as one would in an extended-select list box)

Optimizing Performance: The default behavior of Spread for ASP.NET makes it very easy to quickly publish your information on-line. However, there may be times when you need to fine tune Spread's behavior when working with large amounts of data to present it to your customer in the quickest possible time. Spread for ASP.NET provides several methods to dramatically increase the performance of your web applications and decrease the size of the download page:

• Use style sheets
• Use State Management
• Program against the Models instead of Helper Objects
• Use Named Styles

Order Entry Sample: Spread for ASP.NET is ideal for any internal online order entry system or external shopping cart. After selecting an ID below, Spread for ASP.NET does an AJAX call back to the server, grabs the requested information, then passes the needed data back into Spread...all without a full page refresh. You can also adjust the pricing, discounts, or quantities and again, Spread will make an AJAX call and update the data accordingly.

Spread for ASP.NET Searching: 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.

Multiple Sheets: Each control can contain multiple sheets, similar to Microsoft Excel, allowing you to organize your information on one convenient web page.

You can add and remove sheets at design-time or run-time. You can set the background color and gridline color for each sheet or apply a built-in or custom "skin". You can also hide or show sheet tabs at run-time.

Sorting: You can sort the data displayed in the sheet by column or by row. You can sort in ascending order (A to Z, zero to 9) or descending order (Z to A, 9 to zero) and you can select which values to use as a key when sorting the data.

Spread for ASP.NET also provides an AllowSort property that will automatically sort the data by double-clicking on column header. The appropriate sort indicator will be displayed.

Spread for ASP.NET Designer: Spread includes the robust Spread Designer, a user-friendly design-time environment that allows you or your web designers to quickly configure the look and feel of the Spread control with no coding required.

You can easily assign cell types, color, text, etc for any cell using the Spread Designer's WYSIWYG implementation. This allows for faster design of your applications by your developers or you can even give the Spread control to your graphic designers to configure and create "skins" that can be used across multiple spreadsheets or even across multiple applications for a consistent look.

Unbound Mode: If you're using the MS Grid, you are required to use it in bound mode. But if your situation requires being able to use it in unbound mode, Spread for ASP.NET flexible data model makes this an easy task.

Spread for Windows Forms is a comprehensive spreadsheet component for Windows Forms applications that combines grid capabilities, spreadsheet functionality, and includes the ability to bind to data sources. This control may be dropped on a Windows Form and customized for a range of applications. You can control the appearance and control the user interaction in a variety of ways. With a built-in Designer, you can quickly create a prototype or customize your finished design. With most of the Spreads appearance and functionality based on underlying models, the advanced developer has complete control over the component. Import and export capabilities provide another source of flexibility when developing and exchanging designs.

For more information please refer to the help file in the Evals & Demos section.

Spread for Windows Forms introduces some powerful features.

• Multiple Sheets - You can use multiple sheets in the spreadsheet. Use multiple sheets to categorize your information, similar to worksheets in Microsoft Excel
• Customized Appearance (Skins) - Easily and quickly configure the appearance of Spread using predefined skins or create and save your own custom skins. Custom skins can be shared with everyone in your development team, allowing a consistent look of the control across applications
• Spannable Cells - You can span cells. Create cell spans to join cells together, allowing one cell to span across multiple cells to include, for example, your company logo. You can span data cells or headers. You can also have Spread automatically merge cells that are the same value
• Headers with Multiple Columns and Rows - You can have multiple column headers and row headers. You can also span header cells. Use headers with multiple columns or rows to organize your column and row information
• Sorting Capabilities - You can sort rows or columns or a range of cells. Programmatically sort data by rows or columns. Or allow your users to sort rows automatically simply by clicking on the column header. The methods at the sheet level allow these kinds of sorting: Sorting Automatically by Column, Sorting Columns or Rows Manually, Sorting Data in a Range
• Multiple Cell Types - You can define a feature-rich set of cell types. Use Spread's cell types or create your own to determine what kind of data can be entered into a cell, avoiding unnecessary checks and validations by the developer and providing a natural way for your user to enter data
• Hierarchical Display - You can create a sheet within a row to display relational data hierarchically, with parent rows and child views of related data
• Data Binding - You can bind the spreadsheet to a data set to display and allow your users to edit information. Spread can automatically update the data set with the changes
• Built-In Functions - You can use built-in functions and operators to develop formulas and perform calculations. Add calculations quickly to your applications by using any of over 200 pre-defined algorithms or add your own custom functions
• Navigation - Spread provides multiple ways to control navigation within the spreadsheet. Keyboard Navigation and Action Keys - You can control Spread control actions when the user presses keys. A default set of keys and related actions is provided; however, you can customize these input maps, mapping keys to actions. For example, you can map the Enter key to move the focus to the cell below the current cell. Multiple Viewports - You can allow more than one pane or viewport in the spreadsheet to allow you to view data from different parts of the spreadsheet in one display. Display data in multiple viewports and allow your user to customize their own viewport view
• Spread Designer - You can use the Spread Designer to design your control and to create a prototype quickly. UseSpread Designer to reduce development time by allowing you to customize the look and feel of the control at design time using an intuitive, easy-to-use interface
• Import and Export Capabilities - You can import data from and export data and formatting to Microsoft Excel, both individual spreadsheets and entire workbooks. You can import and export entire spreadsheet(s) with data and formatting to and from XML

Support

Spread Maintenance Package includes all updates, major upgrades, email and forum support, and unlimited support calls for one year.