Spread.GrapeCity.com will soon be GrapeCity.com

In our continuing effort to leverage all of GrapeCity’s resources to better support you, as of next Tuesday, September 12, we officially launch a single GrapeCity Developer Solutions website: grapecity.com. All four of our current product lines—ComponentOne, ... more

GrapeCity Spread.Services 1.3.0 Officially Released!

Spread.Services is a new GrapeCity spreadsheet server component for .NET Core and developers across all .NET platforms, including: Windows Android Linux macOS Spread.Services contains a high-fidelity spreadsheet document object model that is based on ... more

Spread v10 SP2 Release

We’ve released Spread V10 SP2. This release adds several features and fixes many reported issues. The biggest new feature is for SpreadJS.Sheets: Support for Angular! Here is a list of the resolved issues: WinForms Release Notes for Version 10.40.20174.0 ... more

Spread.Sheets and Angular

For those of you wanting to use Spread with Angular, we have some great news, you can now use Spread.Sheets in an Angular project. Use the following steps to create an Angular project with Spread.Sheets. Create an Angular project using the following ... more

Spread.Sheets Year Sparkline

Spread.Sheets is a spreadsheet widget that works in browser applications that support HTML5. Spread.Sheets has a new Year sparkline feature. A Year sparkline allows you to quickly spot trends in your data. The Year sparkline has 54*7 squares. The horizontal ... more

How to Import/Export Excel files using JavaScript and Spread.Sheets

JavaScript is a versatile platform that allows easy customization of client-side scripting tools. In some applications, it is useful to have some sort of spreadsheet interface that is easy to code and maintain. The Spread.Sheets client-side JavaScript ... more

Spread.Sheets and JSFiddle

You can now test Spread.Sheets in JSFiddle with a special license key. Spread.Sheets can be used in browser applications that support HTML5. For more information about Spread.Sheets, refer to http://spread.grapecity.com/spreadjs/sheets/. The following ... more

Spread Studio V10 SP1 Release

Spread Studio V10 SP1 has now been released. This release adds support for Microsoft Visual Studio 2017 and fixes many reported issues. Here is a list of the resolved issues: Spread Windows Forms : X-axis labels are now correctly imported or exported. ... more

SpreadJS V10 SP1 Release

SpreadJS V10 SP1 has now been released. This release fixes many reported issues. Here is a list of the resolved issues: Spread now works correctly with a list validator. [230436] The formula text box is now initialized correctly. [230201] The copyTo ... more

Spread.Sheets and JS Bin

You can now test Spread.Sheets in JS Bin with a special license key. Spread.Sheets can be used in browser applications that support HTML5. For more information about Spread.Sheets, refer to http://spread.grapecity.com/spreadjs/sheets/. The following ... more

Spread Windows Forms and the Waterfall Chart

A Waterfall chart is a popular visualization tool that you can now use in Spread for Windows Forms, a Visual Studio .NET control. Spread for Windows Forms also supports many other chart types. You can see a list of the many product features on our web ... more

Spread.Sheets Excel Navigation

In Excel, the key combination of Ctrl and an arrow key allows the user to navigate to the end of a data region in a worksheet. While this functionality is not currently automatically provided in Spread.Sheets , it is very easy to add. In this tutorial ... more

Spread for Windows Forms and the GcComboBox Cell

A combo box can be useful when creating a form for users such as an on-line order form. The new GcComboBox cell in Spread for Windows Forms allows you to set different backcolors for each list item. The GcComboBox also has a resize icon that allows you ... more

Spread.Sheets and the Month Sparkline

A Month sparkline can be a useful way to show data trends, such as finding the day with the highest call volume in the month. You can use the Month sparkline in Spread.Sheets to quickly find days with the highest values. The Month sparkline displays ... more

Spread.Sheets V10 Cell Dependencies

In some cases, large spreadsheets have formulas with a lot of dependencies on other cells. Showing these dependencies can be useful. In Excel, there are keyboard shortcuts specifically for navigating to and selecting the dependent (and precedent) cells ... more

Spread Windows Forms and the Sunburst Chart

Sunburst charts are effective for showing hierarchical data visually. For example, you can use a Sunburst chart to find out what store and product have the most sales. Spread for Windows Forms and Spread for ASP.NET 10 now have the Sunburst chart. The ... more

Spread Windows Forms and the Funnel Chart

Funnel charts can be a useful tool in your application. For example, since Funnel charts show values across multiple stages, they can be used to find out how many sales leads convert to purchases. Spread for Windows Forms 10 now supports the Funnel chart. ... more

Spread Studio V10 Fixed Bugs

In this article, you will find all of the .NET bugs that were fixed in the first release of Spread Studio V10. To view the release notes, see here: Version 10 Release Notes To download Spread Studio V10, click here: Spread V10 Downloads Spread for WinForms ... more

Getting Started with SpreadJS V10

SpreadJS Version 10 now includes two JavaScript components: Spread.Sheets and Spread.Views . Spread.Sheets is a more traditional spreadsheet component, while Spread.Views is a highly customizable data view component. This tutorial shows how to get started ... more

SpreadJS V10 Fixed Bugs

In this article, you will find all of the SpreadJS bugs that were fixed in first release of SpreadJS V10. To view the release notes, see here: SpreadJS Release Notes To download Spread V10, click here: Spread Downloads SpreadJS The column header will ... more

Spread.Views and the Timeline Layout

A Timeline layout can make your data easier to follow. This can be particularly useful for milestones in a project or a meeting schedule. Use the following steps to create a timeline that displays a meeting schedule. 1. Add the following references to ... more

SpreadJS Rich Text

SpreadJS provides different cell types that give the user useful functionality. Rich text formatting is something that isn’t supported out-of-the-box in SpreadJS, but a custom HTML Cell Type can be implemented that provides most of the functionality ... more

Spread Windows Forms Designer and Sparklines

You can use the Spread Windows Forms designer to quickly design a sparkline. Start the Spread Designer by selecting the FarPoint.SpreadDesigner.EXE from the product bin folder or by right-clicking on the FpSpread component on your form and then choosing ... more

SpreadJS and TypeScript

For some developers, working with TypeScript provides better tools and options than just JavaScript by itself. SpreadJS script code can be written in TypeScript to provide that enhanced functionality in conjunction with the power of SpreadJS . In this ... more

Spread.Views and the Trellis Layout

If you want to create a card style layout that can be used to collaborate with others or to keep track of a process, the Trellis view in Spread.Views may be just what you need. The following example uses a Trellis view for keeping track of a bid process. ... more

SpreadJS Designer and Tables

The SpreadJS designer allows you to create tables quickly and without code. Use the following steps to create a table in the designer. Add the table data to the designer. Table Data Select the table data. Select the Insert tab. Add Table Select the Table ... more

Excel to Spread Copy/Paste V9

Spread for ASP.NET is a useful web tool for providing Excel-like functionality to users on a webpage. It might be useful to give users the ability to paste ranges from their Excel Spreadsheets into Spread. While this feature is not currently in Spread ... more

Spread.Views and the Gantt View

A Gantt view that displays the tasks and progress of a project can make it easier to plan and allocate resources. You can manage your projects with the Spread.Views Gantt view. Spread.Views allows you to create a Gantt view with a minimum number of steps. ... more

Adding a Ribbon to Spread WPF

The Spread WPF Designer provides useful properties and settings that developers can change to create specific sheets and templates for use in their application. This functionality could be useful to users as well, and the bulk of that functionality is ... more

SpreadCOM FAQ

Many people are pleasantly surprised that we still offer our classic SpreadCOM control and naturally have many questions. Here are your answers: What is SpreadCOM? SpreadCOM is the original spreadsheet .OCX control written in Visual Basic 6.0 and is ... more