Spread for Windows Forms - Summary

Overview | Pricing & Licensing | Evals & Downloads | Compatibility | Publisher Details | Reviews | Support Forum | Summary

Summary

Spread for Windows Forms by GrapeCity

URLs: farpoint-spread-windows-forms, farpoint spread windows forms, farpointspreadwindowsforms, grapecity

Easily present, edit and update tabular data. Spread for Windows Forms is a comprehensive spreadsheet component for Windows Forms applications that combines grid capabilities, spreadsheet functionality, fully integrated charting support and includes the ability to bind to data sources. A single control can handle up to 2 billion sheets, each with up to 2 billion rows and 2 billion columns. Spread for Windows Forms supports Microsoft Excel import/export and cross-sheet referencing. Styles and formatting can be applied at sheet, row, column and cell level. Spread for Windows Forms supports cross-sheet referencing, splitter bars, sorting, cell spanning, multiple row/column headers, bound/unbound modes. Spread for Windows Forms offers fully integrated charting support with over 85 different chart types and built-in user interface for creating and customizing charts. Maintenance Package includes all updates, major upgrades, email and forum support, and unlimited support calls for one year. FarPoint Spread for Windows Forms now includes Export to PDF, Excel-like Grouping, Excel 2007 XML Support (Office Open XML, XLSX), Floating Formula Bar and Range Selection for Formula, Automatic Completion (type ahead) and much more. Spread for Windows Forms is now Visual Studio 2010 Compatible.

Spread for Windows Forms provides a completely new, object-oriented spreadsheet control for use in the Microsoft .NET framework. Spread for Windows Forms now includes a 2.0 framework and a 3.5 / 4 framework build. Spread for Windows Forms combines grid capabilities, spreadsheet functionality, fully integrated charting support and includes the ability to bind to data sources. Spread for Windows Forms also supports Tablet PC with InkNotation. You can control the appearance and the user interaction in a variety of ways. With most of the Spread’s 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. Spread for Windows Forms can handle data from comma-delimited text files as well as multiple spreadsheets from Microsoft Excel files. The contents of a sheet may be saved as a Microsoft Excel file (BIFF8 format) or stream, text file, or as a Spread XML file.

You can customize the appearance in a variety of ways, among them:

Work with Multiple Sheets

Set the Background Color for the Sheet

Display Grid Lines on the Sheet

Customize the Sheet Corner

Apply a Skin to a Sheet

Create a Custom Skin for a Sheet

Customize the Number of Rows or Columns

Set the Row Height or Column Width

Resize the Row or Column to Fit the Data

Hide a Row or Column

Create Alternating Rows

Customize the Style of Header Cells

Show or Hide Headers

Customize the Default Header Labels

Customize Header Label Text

Create a Header with Multiple Rows or Columns

Create a Span in a Header

Color a Cell

Align Cell Contents

Resize the Cell to Fit the Data

Customize Cell Borders

Create a Complex Border with Multiple Lines

Create a Range of Cells

Spanning Cells

Merge Cells Automatically

Allow Cell Data to Overflow.

Create and Apply a Style for Cells

Fpoint Spread can import and export native Microsoft Excel .xls files, multiple sheets and cross-sheet formula referencing, hierarchical display, grouping, conditional formatting, sorting, row filtering, searching, zooming, undo/redo, data binding or unbound modes, and splitter bars, you can create a solution for any application. Farpoint Spread also offers complete customization at cell level with the 18 cell types (including the ability to create your own custom cell types), cell spans, multiple headers, shapes, over 320 built-in calculation functions, cell tips and notes, and much more.

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

Customize Interaction with Rows and Columns

Move Rows or Columns: You can allow the user to drag and move rows or columns

Freezing Rows or Columns:You can freeze (make unscrollable) any number of the rows or columns in a sheet. The frozen rows are always the top rows. The frozen columns are always the leftmost columns

Resize Rows or Columns: You can allow the user to readjust the size of a row or column in the control

Search Data

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.

Filtering Data

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.

User interaction with individual cells

You can control the user interaction with individual cells (or a range of cells):

Allow the end user to drag-and-drop data from one range of cells to another. You can specify whether the user can select a cell or range of cells and drag and drop them to a new location in the same spreadsheet or another spreadsheet on the control

Allow the user to drag-and-fill data from one cell or a range of cells to another cell or range of cells. With a cell or range of cells selected, you can fill other cells either in a row (or rows if more than one column is selected) or a column (or columns if more than one row is selected)

Add a note to a cell or range of cells

Add a tag to a cell or range of cells. If you prefer, you can associate data with any cell in the spreadsheet, or the cells in a column, a row, or the entire spreadsheet

Lock a cell or range of cells and make it unavailable for editing by the end user. You can make the appearance of locked cells different so that it is noticeable by the user. You can also specify a different color (for background or for text) in locked cells

Set up conditional formats within cells that determine the formatting of the cell based on the outcome of a conditional operation, for example, the value is less than 0. You can use a named style to specify various formatting options such as borders and colors. The conditional format uses string values and can be a comparison such as less than, greater than, between, or equals.

Allow or restrict the display of buttons in cells that are the specific graphical cell types that allow buttons. Use the ButtonDrawMode property to set the limits on where buttons can be displayed

Data Selection

You can control what the user can select and how it appears. You can control whether users can only select:

Cells

Rows

Columns

Sheet

Combination

Cells, ranges of cells, or multiple ranges of cells

Only rows, no editing

Only rows, editing

Multiple contiguous rows, no editing

Multiple noncontiguous rows, no editing

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

Currency Cell

Date-Time Cell

General Cell

Mask Cell

Number Cell

Percent Cell

Regular Expression Cell

Text Cell

Display Spin Buttons

Button Cell

Check Box Cell

Combo Box Cell

Hyperlink Cell

Image Cell

Multiple Option Cell

Progress Indicator Cell

Rich Text Cell

Slider Cell

Hierarchical Display

You can create a sheet within a row to display relational data hierarchically, with parent rows and child views of related data

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.

Place a Formula in Cells

Specify a Cell Reference in a Formula

Use a Circular Reference in a Formula

Nest Functions in a Formula

Recalculate and Updating Formulas Automatically

Allow the User to Enter Formulas

Create a Custom Name

Create a Custom Function

Supported Functions include Date and Time Functions, Engineering Functions, Financial Functions, Logical Functions, Math and Trigonometry Functions, Statistical Functions, Text Functions

Printing

You can print any of several parts of the spreadsheet, offer print preview with zoom, etc..

You can print a sheet in the control by calling the FpSpread.PrintSheet method or specify that only a range of cells within a sheet prints, rather than the entire sheet, all or some of the pages for the sheet, print child sheets of a hierarchy and manage how they are printed

You can customize the printing by setting the properties of a PrintInfo object and setting the PrintInfo property of a sheet to that object. The PrintInfo object has the settings for customizing the printing of a sheet. You can provide header and footer text that appears on the printed pages. You can print a background image or a watermark when the spreadsheet is printed. Also, Spread provides a way to automatically determine the best way to print your sheet.

You can preview what the printed pages will look like for a sheet and you can allow your end user to preview the printing.

Data Binding

You can bind the control to a data set, such as data in a database, or to anything that the .NET framework allows, such as an IList object:

Bind to a Data Set

Add an Unbound Row to the Sheet

Customize Column Headers for Bound Sheets

Customize Cell Types for Bound Sheets

Customize Column and Field Binding

Work with Hierarchical Data Display

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.

The Spread Designer creates a snapshot of the spreadsheet control. Once all the changes are made, you apply the changes to the spreadsheet control on your form. You can also open files from within Spread Designer and save your design as a file.

Import and Export Capabilities

You can save data from Spread into several different file types and open data files from several different file types into Spread. At design time, you can use the Spread Designer to save the Spread to any of various file types or open previously saved files. With code, you can save the whole control, a particular sheet, or data from a particular range of cells to several different file types or streams. Similarly, you can allow your users to handle file operations for a range of file types.

Save Data to a File:

To a Spread XML File

To an Excel (.xls) File

To a Text File

Open Existing Files

Spread XML File

Excel (.xls) File

Spread File

Custom Text File

Customize the Display of the Cursor

You can set the cursor or pointer to appear differently for different parts of the display. The control uses one cursor for locked cells (CursorType enumeration equal to Locked) and one cursor for unlocked cells (CursorType enumeration equal to Normal).

Allow the User to Zoom

You can allow the user to change the scale of the display of the control, in other words to zoom in or zoom out. Use the AllowUserZoom property of the FpSpread control. This allows the user to zoom in or out by pressing the Ctrl key and turning the mouse wheel. The user can zoom in up to 400% and out to 10% of the default display. You can also programatically adjust the zoom.

Add a Context Menu to a Control

You can create a context menu and add it to the ContextMenu property of the FpSpread control. The control automatically displays this menu when you right click on the control.

Scroll Bars

You can control the display and operation of the scroll bars on the control:

When to display either a vertical or horizontal scroll bar or both on the edges of the sheet in the control. You can hide them, display them as needed (when there are more rows or columns than can be displayed), or display them all the time

The dimensions of the scroll bars

Whether the spreadsheet scrolls across the display when the user moves the scroll box (tracking)

How much of the spreadsheet the end user can scroll through

Whether to align the scrolls with the last row and column

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

VS2010 Compatible: Spread now works in the client profile targets for .NET 3.5 and .NET 4.0 (VS 2010 Compatible)

The Spread Designer has been enhanced.

The SaveTextFile, SaveTextFileRange, and LoadTextFile methods have new enumerations.

ActiveColumnIndex, ActiveRowIndex, ActiveColumn, ActiveRow, and ActiveCell may be -1 or null if an active cell does not exist.

The NoteStyle property has an additional enumeration.

The GetNoteStyleInfo and SetNoteStyleInfo classes have been replaced with the GetStickyNoteStyleInfo and SetStickyNoteStyleInfo classes.

The GetColumnHeaderSpanCell and GetRowHeaderSpanCell methods have been added.

If two conditional formats are set to the same cell, the second conditional format takes effect instead of the first.

The export to HTML methods now require the FarPoint.Win.Spread.Html.dll assembly

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

Visualize your spreadsheet data using charts inside of Spread with FarPoint Chart for .NET

Fully integrated charting support with over 85 different chart types and built-in user interface for creating and customizing charts .

Present your data in Charts that are integrated in Spread

Present your data in Charts using the FpChart stand-alone Control(outside of Spread).

Use Chart Designer and integrated menus and dialogs to create and manipulate charts in your Spread dashboards without writing code

Use the Change Chart Type and Select Data dialogs to create your charts at design time, or allow your end-users to modify their charts at run time

Use the Chart Designer at design time or run time to modify the formatting of your charts.

Leverage the enhanced Microsoft Excel-compatible spreadsheet features

Lossless editing of Microsoft Excel files containing macros, script code, and other previously unsupported content .

New support for Microsoft Excel import and export of shapes and charts.

New support for importing and exporting Excel 2007 workbooks using ISO-OOXML compliant passwords (new in Excel 2007 SP2).

Simplify your development using new Spread Designer capabilities to design powerful user interfaces

New ribbon bar interface similar to Microsoft Excel 2007.

Set multiline text in the header cells.

Set Microsoft Outlook®-style grouping in design time.

Set conditional formats.

Clipboard support for entire sheets.

Get a fast start with the new Quick Start Wizard

Data bindings.

Rows and columns.

And many more attributes

Perform advanced Calculations using these new functions

AverageIf

AverageIfs

CountIfs

IfError

Match

Search

SumIfs

Text

Enhance your user experience with these new and improved usability features

Sort numeric column filter lists.

Display a current row indicator.

Move multiple columns or rows.

Provide enhanced mouse interaction with buttons in cells.

Customize scrolling increments.

Use new display options for sheet titles, subtitles, row preview, and scrolling.

Provide new clipboard enhancements.

Select, move, and size shapes and charts while the sheet is zoomed.

Provide multiple links and string trimming in hyperlink cells.

Set a custom cursor for the gray area in a sheet (beyond the last row and column).

New column and group footers with calculated and formatted values.

Additional enhancements for these existing features

More control over edit mode.

Improved export of text from a sheet.

Enhance date and time data entry.

Select multiple list items in list box cells.

Customize display of text in cells and notes.

Display buttons in cells.

Display tool tips over buttons in cells.

Improved display empty values.

Display cell note indicators in any corner of the cell.

Display column sort and filter indicators for each column in any header row.

Customize images displayed for row expand/collapse, row selector, column filter, column sort, and new sheet tab indicators.

Enhanced Outlook-style grouping of data.

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

General Features

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.

Appearance Features

Outline Grouping: You can set the display of the spreadsheet component to allow rows or columns to be grouped as an outline according to the headers. This behavior of the outline grouping is similar (but with subtle differences) from Excel and OpenOffice. This feature is also called range grouping since it operates on a range of rows or columns.

Cell Note Indicator Customization

Sheet Corner Customization

Edit Control Style Customization (MS Excel-like focus indicator)

Text Rendering

New Default Header Renderers (and ability to highlight selected headers)

Export-to-Excel Features

Excel 2007 XML Support (XLSX)

Import/Export Images to Excel (XLS only)

Import/Export Validation List to Excel (ComboBoxCellType to Excel)

Export View-Driven Version of Data to Excel with ExcelSaveFlag

Export Alternating Rows Settings (AlternatingRow properties) to Excel

Other Additions

Add DataColumnName etc. to GetPreferredColumnWidth

Hybrid Data Model Option - by sheet of whether to use hybrid data model - sparse matrix/linear optimization for small sizes, etc.

Events for During Resize - Add events that fire as the user is resizing columns or rows, not when finished

Event for printing header/footer to custom header/footer per page and other enhanced printing options. (HeaderHeight and FooterHeight properties to PrintInfo as well as PrintHeaderFooterArea event for customizable header and footer printing. Event contains the page number being printed.)

Allow user to double-click row header to auto resize the row height (as done for double-clicking column header to resize the column width).

TickLength for Slider - so easier to see ticks and when new TickColor is changed easier to distinguish

Enumeration to have no sorting on the filter item list

Frozen Rows and Columns in Child View (leading only, not trailing)

IReuseEditorControl - interface for cell types to reuse editor control instead of creating and disposing it every time

Grouping enhancements - Ability to change text in group bar area. Group info area background event text

New skins and themes

What’s New in Spread for Windows Forms 3?

More Display and Interaction Options

Outlook-style 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. To select a column by which to group and display that data, either double-click on the header of that column or click and drag that column into the grouping bar at the top of the page. You can provide grouping to allow users to sort the data with multiple levels of groups by dragging additional column headers into the grouping area. You can set up the display so that the items are shown initially all expanded or all collapsed when grouping is performed. You can set the colors and other formatting of both the hierarchy names and the data in the rows when grouping is performed.

Performance improvements: when saving or loading files, working with import and export, and when working with large spreadsheets, etc.

New layer that allows controls to be hosted on the sheets: You can place controls on a sheet (not just on the FpSpread component but on a specific sheet) to provide more interaction with the user. Anything that can be derived from the Control class in the .NET framework can be hosted on a sheet in FarPoint Spread. The child control is placed on a separate layer, the controls layer. This is separate from the cells of the data area of the sheet and is separate from the shapes and other graphical elements on the drawing layer

Right-to-Left ( RTL ) support for viewports, columns, rows, the tabstrip, and many other areas: You can handle support for right-to-left layouts in the FarPoint Spread component to support applications where the language is written from right to left, such as Hebrew, Arabic, or Farsi, so the user interface would be displayed naturally with right-to-left orientation. Currently these aspects of the layout are changed with the right-to-left support: column resizing on right instead of left, direction attribute in HTML export, filter and sort indicators, order of columns, popup and sticky notes and cell note indicators, scroll bars, shapes, sheet name tabs, and viewport columns

Event handling to allow custom painting for the sheet tab and gray area

Annotation mode for free-hand drawing

Animated (marquee) focus border: You can customize the focus indicator for the active cell by using the FocusRenderer property of the FarPoint Spread component (which uses the IFocusIndicatorRenderer interface). For animated indicators, you can use the IAnimatedFocusRenderer interface.

Renderer for gradient in header cells

HitTest information for locating cursor (for accessibility compliance): You can use the HitTest method for finding the location of the cursor (pointer) on the spreadsheet component to help with development of applications where accessibility issues are concerned. Whether you are meeting accessibility standards and displaying information for the user based on cursor location, or want to provide additional interactivity based on cursor location, you can use this capability to customize the display and user interaction. You can find whether the cursor is over a part of the header, the tab strip, or a particular viewport of the data area.

More Spread Designer GUI enhancements

Enhanced visual styles property

New default action maps (extend, move, or scroll) based on screen coordinates

More Cell Type Features

New list box cell

New multiple-column combo box cell

Automatic completion for combo box cells

Gradient mode for button cells

Gradient style for progress indicator cells

Picture style for progress indicator cells

New Undo/Redo Actions

With the undo/redo feature, you can add capability to your application to undo various actions in the spreadsheet performed by your end user. You make use of the UndoAction class and several specific classes that correspond with those various user actions. There is also a manager class that keeps track of the end user actions that can be undone and re-done.

Cell editing undo/redo

Clipboard operations undo/redo

Row or column resizing undo/redo

More File Export Options

New save sheet to HTML table: You can save an individual sheet or a range of cells in a sheet to an HTML table in a file or stream if you need to display the sheet in a Web browser. This does not save the entire spreadsheet, only an individual sheet. This saves as much of the formatting information or presentation-related settings as possible, depending on whether that information can be translated to an HTML element or attribute.

New save spreadsheet data to simple XML: You can save the data in the spreadsheet (on an individual sheet) to an XML file or stream if you need to process the data further and want the data in a structured format.

More Formula Capabilities

More formula functions bringing the total to 320 different functions

GoalSeek capability

ROW, COLUMN functions

VALUE function

Spread for Windows Forms is now available as part of Spread.NET.

If you require more information please visit the pages above or Contact Us for pricing and availability.

Easily present, edit and update tabular data.

Operating System for Deployment: Windows 7, Windows Vista, Windows XP, Windows 2000

Architecture of Product: 32Bit, 64Bit

Product Type: Component

Component Type: .NET WinForms

Compatible Containers: Microsoft Visual Studio 2010, Microsoft Visual Studio 2008, Microsoft Visual Studio 2005, Microsoft Visual Basic 2010, Microsoft Visual Basic 2008, Microsoft Visual Basic 2005, Microsoft Visual C++ 2010, Microsoft Visual C++ 2008, Microsoft Visual C++ 2005, Microsoft Visual C# 2010, Microsoft Visual C# 2008, Microsoft Visual C# 2005, .NET Framework 4.0, .NET Framework 3.5, .NET Framework 3.0, .NET Framework 2.0

Product Class: User Interface Components

Keywords: farpoint spread windows forms, farpoint spread winforms, farpoint spread, fpoint spread, farpoint, spread windows forms, farpoint tech,

GrapeCity, Grape City, Powertools, Power Tools, Japanese power-tools, 動力工具 Grape City, ＧｒａｐｅＣｉｔｙ Ｇｒａｐｅ Ｃｉｔｙ グレープシティ グレプシティ

datagrid controls, datatable controls, datagrid components, datatable components, datagrid, data grid, data table, net gridview, net datagrid, data grid, grid control, net datatable, c# gridview, c# datagrid, asp.net datagrid, grid asp, vb.net datagrid

Chart Charting Charts Graph Graphing Graphs

Spreadsheet spread sheet worksheet workbook excel lotus 123 1-2-3 xls xl