by ComponentOne - Product Type: Component / ASP.NET WebForms / .NET WinForms
Spread.NET Professional is now available as part of Spread Studio for .NET.
Embedded spreadsheet platform for advanced business, engineering and scientific applications. Spread.NET Professional provides advanced spreadsheet functionality which lets you create highly-specialized applications such as Financial Modeling, Statistical Analysis, Scientific and Engineering Models, Sales Analysis, Budgeting, native Microsoft Excel IO and many other business functions. It also allows you to quickly add data visualization, calculations, and easier layout options to your applications. Spread.NET Professional includes all the features found in Spread.NET plus: stand-alone charting, a formula provider, a MultiRow component for logically presenting data and a Spread Designer tool which lets your users edit or create spreadsheets.
What are the difference between Spread.NET and Spread.NET Professional?
Spread.NET - Allow your users to access, modify, analyze and share data using a spreadsheet. It includes:
Spread.NET Professional - Includes everything in Spread.NET with the following additional components and features:
What’s new in Spread.NET 6?
Add sparkle to your sheets with Sparklines
Create advanced spreadsheet dashboards with new Camera Shapes
Improved Excel import/export performance
New Spread Designer capabilities to design powerful user interfaces
New browser client side support
Spread.NET Professional Features
Embedded, Programmable Microsoft Excel Platform
Import Microsoft Excel documents and preserve complete formatting. Interact with the data in Spread within your application, then export your spreadsheets to Microsoft Excel for portability and distribution to your external customers. Spread supports the current versions of Excel, and supports multiple Excel file formats, including xlsx, xls, comma-delimited (csv), and text (txt).
Dashboard - Data Visualization
Allow your data to tell stories through the data visualization functionality provided in Spread. Use Sparklines to provide small, focused cell-level charts to provide more meaning to your data. Use Camera Shapes to bring together content from various locations within a spreadsheet, even on different sheets, into a dashboard. In Spread, the Camera shape object provides a live view of a range of cells, including any values, formatting, shapes, charts, or other content. If the range of cells is updated or modified through user interaction, or programmatic updates, the Camera shape immediately refreshes to include the changes. Ranges with different column widths and row heights can be arranged together in the same sheet without affecting one another to create a customized report or interactive dashboard. Additional data visualization is provided in Spread through: Chart Support, Conditional Format, Filtering, and Grouping.
Integrated Spreadsheet Chart Control
Create full-featured 2D and 3D charts within your spreadsheets. Chart types include Column, Line, Pie, Bar, Area, XY, Bubble, Stock, XYZ, Doughnut, Radar, and Polar. You can add charts through code by using the comprehensive chart object model, or without writing code, at design time by accessing the Spread Designer and Chart Designer. Charts can be bound to external data sources, and you can allow end user make changes to the chart formatting at run time. The fully integrated support for charts in Spread features built-in design dialogs that you can make available in your applications to allow your end-users to create and modify charts in Spread - just as in Microsoft Excel. View Charts.
Extensive Customization Options
Spread.NET has an extensive and robust object model, and provides the ability for developers to customize many elements of the user interface and control behavior by extending built-in classes and assigning custom objects to Spread. Developers use Spread to embed advanced Microsoft Excel-compatible spreadsheet features into their .NET applications — features that would otherwise be considered impossible to achieve.
Integrated Design Time Support - Spread comes with an easy-to-use, intuitive spreadsheet designer that makes designing detailed spreadsheets and input or data display screens a snap without writing a single line of code. Whether designing new screens or editing existing screens, Spread Designer makes it easy using a Microsoft Excel-like, visual, drag-and-drop user interface. The built-in Chart Designer, and UI-type editors make it easy to design stunning charts and spreadsheet dashboards by providing nearly unlimited customization of your charts.
Flexible Data Binding Support - Spread can bind to any .NET Data Source, including support for displaying relational datasets. Run-time support for unbound rows and columns within bound data allows for inclusion of aggregation information, or for performing what-if scenario analysis. Spread also supports binding a range of cells to a data source, and for providing a range of cells as a data source.
Printing / PDF Support - Customize the printing of your spreadsheets with the wide range of printing options. Spread also support printing to a PDF (Portable Document Format) files. You can even take ultimate control of the printing in your code using the owner print drawing support.
Spread provides the familiar sheets and workbooks you know from Microsoft Excel, as well as formula support, including cross-sheet references. You or your users can search, sort, filter, and group data, including providing outline grouping similar to Microsoft Excel. In addition, Spread can display data in hierarchies.
How do you want your spreadsheet to appear today? Any way you want! Use Spread to achieve clear, colorful table layouts, custom spreadsheets, and more.
Whether your users need to zoom, view multiple panes of data, drag-and-drop data, drag fill data in cells, or view cell notes, Spread can do it, and more. Offer users autocomplete options, undo and redo capabilities, frozen rows and columns, and different selection options, as needed.
Spread offers eight editable cell types and thirteen graphical cell types, which provide just about any interaction or data display you need. You can customize cells with spin buttons and provide pop-up calendars and clocks and other editors as needed.
Layers and Drawing
Spread includes several different layers for you to work with, including the the Data layer (on which cells with data appear), the Control layer (to place child controls on), and the Drawing layer (on which shapes and other graphical elements appear). and the Drawing layer (on which shapes and other graphical elements appear).