SpreadsheetGear 2009 is the leading Microsoft Excel compatible spreadsheet component for the Microsoft .NET Framework.

With one safe managed assembly, SpreadsheetGear 2009 enables ASP.NET and Windows Forms developers to easily take advantage of scalable Excel Reporting, dynamic dashboards from Excel charts and ranges, powerful Windows Forms spreadsheet controls, comprehensive Excel compatible charting, the fastest and most complete Excel compatible calculations and more.

General Features

·         Royalty free deployment to 32 bit and 64 bit Windows 2000, Windows XP, Windows Vista, Windows 7, Windows Server 2003 (including R2) and Windows Server 2008 (including R2).

·         Create, read, modify, view, edit, format, calculate, print and write Microsoft Excel 97-2003 (xls) and Excel 2007 Open XML (xlsx) workbooks without Excel.

·         Scalable and reliable Excel Reporting.

·         Powerful Windows Forms spreadsheet controls.

·         Easily create images from Excel charts and ranges.

·         Comprehensive charting APIs.

·         Fastest and most complete Excel compatible calculation engine available (significantly faster than Excel).

·         Read and write CSV and tab separated text files.

·         Support for cell comments, pictures, text boxes, check boxes, drop-downs, list boxes, spinners, scrollbars, buttons, lines and many autoshapes.

·         Drag Fill / Auto Fill including support for numbers, dates, times, month names, day names and certain text patterns.

·         Fill Data Series support including automatic, chronological, linear, growth, day, weekday, month, year, start value, step value, stop value and the ability to use regression for linear or exponential trends.

·         Fast single variable and single target goal seeking.

·         Data validation including operators, alert messages, alert styles, custom formulas and drop-down lists.

·         Conditional formats with support for simple comparison operators and custom formulas.

·         Copy and insert DataTables into pre-formatted ranges with complete formula, border and format fixups.

·         Easily convert entire workbooks or specific ranges to a DataSet or DataTable.

·         Copy, transpose and consolidate across cells, worksheets, workbooks and workbook sets.

·         Insert, delete and clear rows, columns and cells.

·         Stable sort with an unlimited number of keys and the ability to sort text as numbers.

·         Grouping and outlining of rows and columns.

·         Supports 1,048,576 rows, 16,384 columns, 64K worksheets, unlimited workbooks and unlimited workbook sets.

·         Copy, insert and move entire worksheets.

·         C# and Visual Basic samples for ASP.NET and Windows Forms.

·         Reads and writes VBA Macros.

Windows Forms Spreadsheet Control Features

·         WorkbookView spreadsheet control provides viewing, navigation and editing support which is familiar to Excel users.

·         In-cell editing and optional FormulaBar control provide the ability to enter and edit cell values and formulas, including support for pointing at cell references in formulas across worksheets and workbooks.

·         Smart data entry with optional data validation as well as automatic recognition and formatting of dates, times, percentages, currency, scientific notation and fractions will be familiar to Excel users.

·         Conditional formatting enables font colors, font styles, background colors and borders which are based on simple comparison operators or complex formulas.

·         Grouping and outlining which allows users to easily expand and collapse the displayed level of detail.

·         WorkbookDesigner provides an MDI Windows application which may be used from within Visual Studio 2005 and Visual Studio 2008 at design time and by applications at run time.

·         WorkbookExplorer provides the ability to manipulate workbooks, worksheets and defined names as well as their properties.

·         RangeExplorer provides extensive modeless formatting of the currently selected range with support for number formats, alignment, fonts, borders, colors, patterns, protection options, hyperlinks, conditional formats and data validation.

·         ChartExplorer provides basic modeless modification and formatting of the selected chart with support for chart types and data sources, legend options, primary and secondary axes options and various series options.

·         Modeless find and replace dialog with support for find, find all, replace and replace all.

·         Support for an unlimited number of workbooks associated with each WorkbookView.

·         DisplayReference and DisplayReferenceName properties allow complete control over what appears for each sheet tab, including the ability to make multiple workbooks appear as one workbook and the ability to specify dynamically changing ranges using worksheet functions such as OFFSET().

·         Cut, copy, paste and paste special support including rich data and formatting interchange with Excel and full formula fixups.

·         Frozen rows and columns, split panes, sheet tab colors, zoom, multi-level undo/redo, autofit rows and columns, goto, clear, printing, print preview, interruptible background calculation, real time workbook updates and more.

·         CommandManager provides the ability to add custom undoable commands as well as the ability to override the behavior of common commands.

·         Full integration with Visual Studio 2005 and Visual Studio 2008 including the ability to use the WorkbookDesigner, WorkbookExplorer, RangeExplorer, ChartExplorer and ShapeExplorer at design time and at runtime.

·         SpreadsheetGear Explorer Sample Solutions with C# and Visual Basic source code demonstrate commonly used SpreadsheetGear 2009 features and APIs.

Calculation Features

·         Fastest and most complete Excel compatible calculation engine available in a spreadsheet component.

·         331 of Excel 2003's financial, date, time, text, lookup, math, trigonometry, statistical, database and Analysis Toolpak functions (see the list below).

·         All types, operators, defined names, data tables and arrays.

·         Interruptible background calculation.

·         Support for 64K worksheets and unlimited workbooks in formulas.

·         Worksheet specific defined names and global defined names.

·         Custom functions, minimal recalc, iteration, precision as displayed and more.

·         Copy formulas between cells, worksheets, workbooks and workbook sets with full support for reference fixups.

·         Insert and delete worksheets, rows, columns and cells with full support for reference fixups.

·         Cut, copy and paste with full support for smart reference fixups across multiple worksheets and workbooks.

·         Special care was taken with numerical stability.

Formatting Features

·         Number formats, including full support for getting and setting Excel compatible custom number formats as well as getting the formatted text of a cell as Excel would display it.

·         Fonts, borders, Office Theme colors with tinting and shading, RGB colors, Excel palette indexed colors and patterns.

·         Horizontal alignment, vertical alignment, word wrap and rotated text.

·         Merged cells, hyperlinks and conditional formats.

·         Enable or disable worksheet protection, worksheet passwords and cell locking.

·         Grouping and outlining of rows and columns.

·         Automatic row heights and column widths.

·         Copy formats without affecting formulas or values.

·         Named cell style support.

Charting Features

·         The most comprehensive Excel compatible charting support available in a Microsoft .NET Framework component with API support for virtually every charting property.

·         SpreadsheetGear.Drawing.Image class provides the ability to generate an image (such as GIF or PNG) with one line of code.

·         Chart rendering supports the most common charting features:

·         Chart types include area, bar, column, line, pie, stock, XY scatter and bubble charts.

·         Chart type options include multiple chart groups (combination charts), stacked and 100% stacked values, bar gap and overlap, line markers, drop lines, high-low lines, open-close bars, exploded pies, and data point labels.

·         Axes options include axes titles, primary and secondary axes sets, auto and manual scaling, major gridlines and tick marks, reversed axes, tick label positions and rotated text.

·         General chart options include chart titles, legends, theme colors, auto colors, gradients including Excel compatible preset gradients, number formats and fonts.

Microsoft .NET Framework Features

·         Easy to use API which will be familiar to Excel VBA and COM developers while taking advantage of .NET's expressiveness.

·         Supports 32 and 64 bit versions of the Microsoft .NET Framework 2.0 as well as .NET 3.0 and .NET 3.5. SpreadsheetGear 2009 supports 32 bit and 64 bit versions of Windows 2000, Windows XP, Windows Vista, Windows 7, Windows Server 2003 (including R2) and Windows Server 2008 (including R2).

·         Microsoft Visual Studio 2005 and Visual Studio 2008 integration, including IntelliSense and Dynamic Help.

·         The security of 100 percent safe managed code which does not require FullTrust.

·         Hassle free deployment with a single strong named assembly and no license keys, registry entries or configuration issues.

·         No dependency on Microsoft Excel, which is not supported in a server environment.

SpreadsheetGear for .NET 2007 is a royalty free Microsoft Excel compatible spreadsheet component for any Microsoft .NET Framework solution, featuring a fast and Excel compatible calculation engine as well as rich Windows Forms Spreadsheet Controls.

It provides a solid foundation for a rich user experience by starting with basic Excel compatible features including multiple worksheets, multiple workbooks, smart data entry, custom number formats, merged cells, cut, copy, paste, insert, delete, clear, find, replace, conditional formats, data validation, sort, group & outline, split/frozen panes, form controls, pictures, autoshapes, cell comments, print, undo and redo.

It also includes advanced features such as the FormulaBar, RangeExplorer, WorkbookExplorer, DisplayReference, paste special, interruptible background calculation, high performance API's, real time workbook updates, global and worksheet specific defined names, precision as displayed and array formulas.

Pricing Notes:

·         Licence includes royalty free client and server deployment.

·         Subscriptions include a perpetual licence and 1 year of updates and support.

·         Upgrades are from any version of SpreadsheetGear for .NET.

·         Subscription renewals must be purchased withing 30 days of licence or 1 year of subscription.