FarPoint Spread for ASP.NET（英語版） - 概要

概要 | 価格及びライセンス | 試用版とそのダウンロード | 互換性 | 開発元詳細 | 結果

結果

FarPoint Spread for ASP.NET（英語版） by FarPoint Technologies

ASP.NET データの表示、編集、および更新が簡単にできます。 Spread for Web Forms は、多くのグリッド機能と直感的に使用できる操作性とを備えたスプレッドシート コンポーネントです。 Spread for Web Forms を使用することにより、サーバーとやりとりをしなくても、複数の行に対して複数の編集を実行できます。 クライアント側でのデータ検証機能に優れているため、無効なデータが入力されると直ちにユーザーに警告できます。また、クライアント側で簡単にキーボードでナビゲーションができます。 C# でまったく最初から記述された Spread for Web Forms なら、簡単で信頼性が高く、機能が豊富でユーザー フレンドリなオンライン体験をユーザーに提供することができるでしょう。Visual Studio 2005とAJAXをサポート。リアルタイムの公式結果を含みます。

Spread for Web Forms は、FarPoint社の画期的な Spread Designer を用いて短期間で開発をする際の設計作業に大変役立ちます。セル値の編集および妥当性検査にも対応しています。 行、列についてだけでなく、セル レベルで十分にカスタマイズ可能です。また、ポストバックしなくても複数行を編集できます。 表、行、列、およびセルのそれぞれのレベルでスタイルを適用することができます。カスタマイズしたビューの表示もできます。 Spread は、ページング、セル スパニング、複数行ヘッダー、ソート、豊富なセル タイプ、その他多数の機能を持ちます。

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. Please, read the 'Optimizing Web Applications with AJAX and Spread for Web Forms' Whitepaper on the 'evals and downloads' section for more information.

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. Think of the new opportunities you now have!

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.

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

Farpoint Spread for Web Forms V3.0の新機能は?

Outlookスタイルのグルーピングをサポート(何レベルでも可）

Microsoft ASP.NET AJAXテスト済み及び継続してAJAXをサポート

Load-on-demandページング(バーチャルモード)

ページナビゲーションの追加

シート名タブでCSSをサポート

コンボボックスのセルへデータバインディングが可能に

列へのドラック&ドロップ機能

クライアントサイドのメソッドの追加

実行モードの選択の追加

PartNumbers: PC-513244-163744 513244-163744 PC-513244-163764 513244-163764 PC-513244-163768 513244-163768 PC-513244-163825 513244-163825 PC-513244-163748 513244-163748 PC-513244-163784 513244-163784 PC-513244-163756 513244-163756 PC-513244-163795 513244-163795 PC-513244-163797 513244-163797 PC-513244-163826 513244-163826 PC-513244-163792 513244-163792 PC-513244-163803 513244-163803 PC-513244-163856 513244-163856

Publisher PartNumbers: SSW01 SWB01 SWB06

PurchaseOptions: Spread for ASP.NET V4.0 1 開発ライセンス , Spread for ASP.NET V4.0 4 開発チーム ライセンス , Spread for ASP.NET V4.0 6 開発チーム ライセンス , Spread for ASP.NET V4.0 1 開発アップグレード ライセンス - Spread for Web Forms V3から , Spread for ASP.NET V4.0 1 開発アップグレード ライセンス - Spread for Web Forms V2.5から , Spread for ASP.NET V4.0 1 開発アップグレード ライセンス - 他のFarPoint productから , Spread for ASP.NET with one year Maintenance V4.0 - Includes all updates, major upgrades, email and forum support, and unlimited support calls for one year 1 開発ライセンス メンテナンス付き , Spread for ASP.NET with one year Maintenance V4.0 - Includes all updates, major upgrades, email and forum support, and unlimited support calls for one year 4 開発チーム ライセンス メンテナンス付き , Spread for ASP.NET with one year Maintenance V4.0 - Includes all updates, major upgrades, email and forum support, and unlimited support calls for one year 6 開発チーム ライセンス メンテナンス付き , Spread for ASP.NET with one year Maintenance V4.0 - Includes all updates, major upgrades, email and forum support, and unlimited support calls for one year 1 開発アップグレード ライセンス メンテナンス付き - Spread for Web Forms V3から , Spread for ASP.NET with one year Maintenance V4.0 - Includes all updates, major upgrades, email and forum support, and unlimited support calls for one year 1 開発アップグレード ライセンス メンテナンス付き - Spread for Web Forms V2.5から , Spread for ASP.NET with one year Maintenance V4.0 - Includes all updates, major upgrades, email and forum support, and unlimited support calls for one year 1 開発アップグレード ライセンス メンテナンス付き - 他のFarPoint productから , Spread for ASP.NET - Maintenance Renewal 1 メンテナンス リニューアル ライセンス（1開発者に単位での1メンテナンス更新）

Resources: Read the Spread for ASP.NET help file, Spread for ASP.NET Formula Reference, Spread for ASP.NET Documentation, Spread for Web Forms End User ライセンス契約 (EULA), Read the 'Optimizing Web Applications with AJAX and Spread for Web Forms' Whitepaper - Requires Acrobat Reader, Spread for ASP.NET Import and Export Reference, Spread for ASP.NET Developer's Guide, Download the FarPoint Spread for ASP.NET V4.0 evaluation on to your computer - Expires After 30 Days

OS: Windows Vista, Windows XP, Windows Server 2003, Windows 2000, Windows NT 4.0

製品のアーキテクチャー: 32Bit

ツールタイプ: コンポーネント

コンポーネントのタイプ: .NET WebForms, ASP.NET AJAX (ATLAS), .NET Class, 100% Managed Code, JavaScript, AJAX

互換性のあるプラットフォーム: Microsoft Visual Studio 2008, Microsoft Visual Studio 2005, Microsoft Visual Basic 2008, Microsoft Visual Basic 2005, Microsoft Visual C++ 2008, Microsoft Visual C++ 2005, Microsoft Visual C# 2008, Microsoft Visual C# 2005, Microsoft Internet Explorer 7.0, .NET Framework 3.5, .NET Framework 3.0, .NET Framework V2.0

製品のクラス: ユーザーインターフェース　コンポーネント

検索アイテム: New Product Jan 05

Keywords: グリッド 表計算 テーブル 表 計算 Enterprise Partner farpoint spread web forms, farpoint spread webforms, farpoint spread asp.net, farpoint spread web, spread web forms, farpoint spread, fpoint spread, farpoint, farpoint tech