FarPoint Spread is a suite of Microsoft Excel-compatible spreadsheet components available for .NET, COM, and Microsoft BizTalk Server. Software developers use the components to embed Microsoft Excel-compatible spreadsheet features into their applications, such as importing and exporting Microsoft Excel files, displaying, modifying, analyzing, and visualizing data. Spread components handle spreadsheet data at the cell, row, column, or worksheet level.
FarPoint Spread for Windows Forms is a Microsoft Excel-compatible spreadsheet component for Windows Forms applications developed using Microsoft Visual Studio and the .NET Framework. Developers use it to add grids and spreadsheets to their applications, and to bind them to data sources.[5] In version 4.0, new cell types were added to display barcodes and fractions, and exports for XML and PDF were added.[6][7]
FarPoint Spread 8 COM allows COM and ActiveX applications to incorporate spreadsheet features. In the 1997 book Visual Basic 5 for Windows for Dummies, Wally Wang lists an early version of Spread COM in Chapter 35: The Ten Most Useful Visual Basic Add-On Programs.[8]
Another method for achieving the same thing is to open the form designer, select the spread control, display the properties window (press F4 if it isn't already open), and increase the Cols property to 29.
Features: FarPoint Spread 8 COM General Features: Create a spreadsheet with up to 2 billion rows by 2 ... text in a cell Time: Display or allow editing of a formatted time value in a cell FarPoint Spread 8 COM ... in which pages are printed (down then across or across then down) FarPoint Spread 8 COM Sorting ... Read more
Description: Add advanced spreadsheet functionality to your applications. Spread COM helps you easily ... Spread COM will allow you create a spreadsheet with up to 2 billion rows by 2 billion columns. Spread COM ... Features Calculation Engine- Spread includes a very comprehensive calculation engine with over 100 built-in ... Read more
Screenshots: Similar to spreadsheet applications, Spread includes a very comprehensive Calc Engine to provide ... easily add your own custom formulas to Spread. You can also use named expressions or relative cell ... Read more
Description: List Pro which provides robust ListBoxes and ComboBoxes and Spread 8 which allows you to add ... spreadsheet/grid functionality to your Windows applications. FarPoint Enterprise Database Pack includes ... the following products Input Pro, List Pro and Spread. Giving you the following components: grid, spreadsheet, ... Read more Show more results from this product
FarPoint Spread 8.0.14 is a suite of spreadsheet components that can be used in various applications, such as .NET, COM, and BizTalk Server. It is compatible with Microsoft Excel and offers high-performance, fully-customizable spreadsheet/grid functionality.
With FarPoint Spread 8.0.14, you can create rich and interactive spreadsheets that can handle large amounts of data, complex calculations, charts, graphs, and more. You can also customize the appearance and behavior of the spreadsheet cells, rows, columns, headers, and footers. You can add formulas, validations, filters, sorting, grouping, subtotals, and other features to enhance your data analysis and presentation.
FarPoint Spread 8.0.14 is a powerful and versatile spreadsheet component that can help you create dynamic and user-friendly applications that work with data. Whether you need to display, edit, analyze, or manipulate data in your applications, FarPoint Spread 8.0.14 can provide you with the tools and flexibility you need.
Another benefit of FarPoint Spread 8.0.14 is that it is highly customizable. You can change the appearance and behavior of the spreadsheet components to suit your needs and preferences. You can apply different styles, themes, colors, fonts, borders, and backgrounds to the spreadsheet elements. You can also control the visibility, size, alignment, and order of the spreadsheet elements. You can also add custom events, actions, and commands to the spreadsheet components to enhance their functionality.
FarPoint Spread 8.0.14 is a comprehensive and flexible spreadsheet component that can help you create professional and attractive applications that work with data. It is easy to use, reliable, and compatible with Microsoft Excel. It is also customizable, powerful, and feature-rich. If you are looking for a spreadsheet component that can meet your data-related needs, you should consider using FarPoint Spread 8.0.14.
After installing FarPoint Spread 8.0.14, you can add it to your project by using the toolbox or the component gallery. You can drag and drop the FpSpread component to your form or web page, or use the code editor to create an instance of the FpSpread class. You can then access the properties, methods, and events of the FpSpread component to customize and manipulate the spreadsheet.
For example, you can use the Sheets property to access the collection of sheets in the spreadsheet. You can use the ActiveSheet property to get or set the current sheet. You can use the Cells property to access the collection of cells in a sheet. You can use the GetCell and SetCell methods to get or set the value, style, or formula of a cell. You can use the AddColumns and AddRows methods to add columns or rows to a sheet. You can use the ColumnCount and RowCount properties to get or set the number of columns or rows in a sheet.
You can also use the FpSpread component to perform various operations on the spreadsheet, such as importing and exporting data, printing and previewing, sorting and filtering, grouping and outlining, calculating and validating, charting and graphing, and more. You can find more information and examples on how to use FarPoint Spread 8.0.14 in your applications in the documentation and samples.
FarPoint Spread for Windows Forms 5 is the award-winning, Microsoft Excel-compatible spreadsheet component for .NET from GrapeCity. Spread products are high performance, enterprise-strength spreadsheet components, and come battle-tested by over 100,000 registered developers worldwide.
Spread introduced a number of technologies to Microsoft developers all over the world for the very first time, including the first full-featured spreadsheet component for Visual Basic, with the first spreadsheet designer, followed by Microsoft Visual Studio .NET versions, and an array of new Excel-compatibility features and advanced customizations.
Anyone have experience in getting spread 2.5 usable in a VB6 development environment with Windows 10? Works fine in Windows 7, even though it cannot be installed there. Code developed in the Windows XP environment runs properly in both Windows 7 and 10, but I need to upgrade development environment to Windows 10.
Many businesses require the management of data, from financials to inventory, from personnel to parts ordering, and depend on customized applications to provide the user interface and the manipulation algorithms. For many businesses, simply using spreadsheets in office applications are the extent of what they can handle. As they grow, though, those same businesses must move to more advanced applications, and spreadsheet components provide a quick and proven way to make the step up.
We have created a fictitious company, Calaway-Williamson winery, to illustrate the requirements that these companies face and the solutions they have found in spreadsheet components. With a minimal amount of .NET code, you can import existing Excel spreadsheets, customize the component appearance to create a corporate user interface, and quickly develop applications that can be deployed on the Windows desktop for back-office work as well as on the Web for a mobile sales force. FarPoint recommends trying the Spread component, in both Windows Forms and ASP.NET applications, for rapid spreadsheet application development across platforms.
With so much corporate data in easy-to-use Excel spreadsheets, you do not need to lose any of that data when moving to a spreadsheet application. Simply use FarPoint Spread to open the Excel (.XLS) file, and all the data is available, including formulas, custom names, and print settings. Converting from Excel to Spread is as easy as one line of code:
There are several ways to open Excel files in Spread, and additional parameters that you can specify to determine the exact handling of the file. You can include lists of warnings during the import, you can specify the sheet name or number, you can import from a filename or from a stream. Whichever method you choose, it is a simple procedure. Another advantage of importing Excel files, besides the ability to rescue legacy spreadsheets, is the ability to prototype in Excel and then import the finished prototype into Spread.
The quickest way to see how easy it is to develop an application using a spreadsheet component is to try the trial version of the Spread product. With the downloaded Spread for Windows Forms setup, in the VB examples folder, open the fpwine-orderentry demo and see what Calaway-Williamson created. Open and run the order entry program. When you click on Enter Order, a search form appears. To enter an order, click on Find Customer; an additional list appears that displays the customers. Here is a good example showing some of the spreadsheet capability. The figure below shows the interface of the order entry program:
The code is easily edited and built inside Microsoft Visual Studio .NET. Whether you are working in C# or Visual Basic .NET, developing an application using Spread can be as easy as selecting Spread from the toolbox, placing it on a form, and writing a few lines of code to customize it. In this demo, there is a parent form that contains the menu of buttons on the left and the grapes graphic. The order entry form contains the two spreadsheets and the two buttons shown inside the parent form. This illustrates how the spreadsheet component can be used for data entry and database connection.
760c119bf3