Spread Windows Forms and Camera Shapes

Spread Windows Forms supports a unique feature known as a camera shape. This allows you to create a snapshot of a range of cells and use that as a shape in the Spread control. The cell range can also contain other shapes. You can use the following steps ... more

Spread ASP CRUD Row Edit Template

While Spread for ASP.NET can be combined with CRUD operations, it might be useful to provide a better way for the user to enter data. In this blog, I will show how to combine a Row Edit Template with CRUD operations. This can be useful for cases where ... more

Creating a Spread.Views Calendar

A calendar that shows when employees are out can be useful to everyone at a company. Spread.Views has a calendar view that you can add custom information to. You can see several examples in the Spread.Views demo on our web site: http://spread.grapecity.com/Demos/JS/ViewsDemo/#/demos/ ... more

Spread ASP CRUD SpreadDataBinding

Using CRUD operations with Spread for ASP.NET provides useful database functionality along with an intuitive interface. Spread for ASP.NET has built-in functionality for connecting to a SQL Data Source that can be accomplished in the Design view of Visual ... more

Introducing Spread.Views, The First JavaScript Data Layout Component

We are very excited to introduce a new JavaScript component that takes data and lays it out virtually any way you can imagine. This includes tabular grids, calendars, cards, trellis, masonry, Gantt, news feed, timeline and more. You give it JSON data, ... more

SpreadJS Designer and the Settings Tab

The SpreadJS Designer allows you to create spreadsheets quickly and without code. The Settings tab in the designer provides appearance and UI options for the entire widget and specific sheets. Settings Tab The Spread Settings section has General, ScrollBars, ... more

Build a JavaScript Spreadsheet in Five Minutes

SpreadJS’s Spread.Sheets component is so complete that it can be implemented with very little code and in just a few minutes. You only need the Spread.Sheets core JavaScript library and style sheet; there are no external dependencies. This tutorial uses ... more

SpreadASP CRUD ADO.NET Binding

Using CRUD operations with Spread for ASP.NET provides useful database functionality along with an intuitive interface. You can use ADO.NET code and a SQL Server with Spread for ASP.NET with just a little bit of coding to connect everything. The download ... more

DevChannel Update: Spread.Sheets v10 Preview with Client-side Excel IO Available

Our DevChannel delivers pre-release previews of next version builds and hot fixes. The first entry is a preview build of v10 which is due to release in November. This build has an early version of the new client-side ExcelIO feature. You can now implement ... more

Spread Windows Forms and Built-in Shapes

You can use built-in shapes in Spread for Windows Forms to draw attention to different areas of your spreadsheet. You can use shapes to show a process with flowchart-like graphics, use shapes to highlight a particular result, or use a shape for some ... more

SpreadJS Designer and Sparklines

The SpreadJS Designer allows you to create sparklines quickly and without code. The following sparkline types are available in the SpreadJS Designer. Line Column Win/Loss Pie Area Scatter Spread Stacked BoxPlot Cascade Pareto Bullet Hbar Vbar Variance ... more

SpreadJS Camera Shapes

Camera Shapes in Spread for WinForms allow the developer to take snapshots of content in a range of cells for use in other areas of the sheet, or different sheets entirely. This can help with organizing and presenting data in one cohesive view without ... more

SpreadJS Formulas and Cell Formatting

You can use cell formatting with formulas in SpreadJS to get the results you want. Some formulas may not return the number of decimal places you want or the types of values you want to see. For example, some formulas may return more decimal places than ... more

SpreadJS.Sheets Custom Slicer

Slicers provide an easy and efficient way for users to filter table data quickly. SpreadJS slicers allow the developer to customize the types of filters they want to provide to the users, and these slicers can be used with different types of UI and JavaScript ... more

Overview of the Spread Product Family v9 Sp1 Release

In case you are new here, Spread is a product line that includes spreadsheet, grid, and data presentation components for .NET and JavasScript developers. Spread Studio v9 Sp1 and SpeadJS v9 Sp1 were just released and we have a lot of news. Here is an ... more

Important SpeadJS Notice: License Changes, Name Changes, and a New Product

We have just released Spread Studio v9 Sp1 and SpreadJS v9 Sp1 and a few announcements come with this release. SpreadJS is No Longer Part of Spread Studio SpreadJS is growing into its own product line (see the Spread.Views announcement below). Starting ... more

SpreadJS V9 Service Pack 1 Fixed Bugs

In this article, you will find all of the SpreadJS bugs that were fixed in the first Service Pack release of Spread V9. To download Spread V9 Service Pack 1, click here. SpreadJS The hitTest method now works correctly when filters are applied. Certain ... more

Spread Studio V9 Service Pack 1 Fixed Bugs

In this article, you will find all of the .NET bugs that were fixed in the first Service Pack release of Spread V9. To download Spread V9 Service Pack 1, click here. Spread for Winforms The CheckboxCellType now works correctly with certain key characters. ... more

Creating Cells with the SpreadJS Designer

The SpreadJS Designer allows you to create basic cell types quickly and without code. You can create button, check box, combo box, and hyperlink cells in the SpreadJS Designer. The options for setting the cell type are located under the Home tab. Designer ... more

Spread ASP.NET and Multiple-Column Combo Box Cells

You might want to display multiple columns of data in a cell and limit the user choices. Spread ASP.NET allows you to do this with a multiple-column combo box cell. You can create a combo box cell with multiple columns in the drop-down list. You can ... more

Spread Windows Forms and Currency Cells

Currency cells are useful if you want to display numbers as monetary values. You can display currency values in Spread Windows Forms with a currency cell. You can customize formatting in the currency cell such as the currency symbol, separator character, ... more

Spread Windows Forms and the Spread Designer

You can quickly design a spreadsheet component using the Spread Designer. Whether you are prototyping a complete spreadsheet component or simply customizing some aspect of an existing spreadsheet component, the dedicated graphical interface offers many ... more

SpreadJS and Angular Data Binding

AngularJS is a JavaScript library that is used for creating dynamic displays in web-applications. SpreadJS can work with Angular to make binding to data easier to understand by extending HTML. This blog is a part of the SpreadJS Data Binding series, ... more

Spread Windows Forms and Page Breaks

Some applications allow you to view page breaks for printing. You can use code to add visual indicators for page breaks in Spread for Windows Forms. There are several ways to add visible page breaks in Spread Windows Forms. You can add a border to the ... more

SpreadJS and Saving To PDF Files

PDF files are popular because they can be viewed in many different operating systems. You can save to PDF with SpreadJS. There are several ways to create a PDF file with SpreadJS. You can use the Excel Import and Export component to save to a PDF file ... more

SpreadJS and Knockout Data Binding

Knockout is a JavaScript library that helps you create responsive displays, as well as user interfaces that have an underlying data model. SpreadJS can work with Knockout to make binding to data easier to understand. This blog is a part of the SpreadJS ... more

SpreadJS Data Binding

Data binding is a useful feature that enables the user to work with data without needing complex code. In SpreadJS, the workbook can be bound to data using jQuery, and then displayed on a web page to give the user access to that data. To download the ... more

SpreadJS and Sparklines

Sparklines are small charts that you can use to provide visual representation of your data. Sparklines use data from a range of cells. SpreadJS supports sparklines in cells. SpreadJS provides two different ways to create sparklines. You can use methods ... more

Setting Table Colors for SpreadJS

You can set colors for tables in SpreadJS. This simple example allows you to set background colors for the cells, colors for the cell text, and colors for the grid lines. Select the color names and then select the Change Color button to set the colors. ... more

SpreadJS and Locking Cells

You can prevent users from editing cells by locking them. This can be useful if you have formulas, labels, or other data that you do not want the user to change. SpreadJS supports protecting sheets and unlocking or locking cells. Use the setIsProtected ... more