← Back to all blogs

Posts in 'spreadsheets'

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.

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 contained within a Ribbon toolbar. This tutorial provides step-by-step instructions for adding an open-source Ribbon toolbar to a WPF application with Spread. The toolbar that is used in this tutorial is an open-source ribbon for WPF applications called “Fluent Ribbon”, and it can be found here: Fluent Ribbon GitHub

SpreadCOM FAQ

Many people are pleasantly surprised that we still offer our classic SpreadCOM control and naturally have many questions. Here are your answers:

Spread Windows Forms and Camera Shapes

Spread Windows Forms supports a unique feature known as a camera shape.

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 there are a lot of columns, and it would be tedious for the user to scroll through them all to edit the value that they want.

Creating a Spread.Views Calendar

A calendar that shows when employees are out can be useful to everyone at a company.

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 Studio.

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.

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.

Spread ASP 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.

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 Excel import and export functionality on the client and you no longer need to implement the .NET server component. This makes Spread.Sheets applications much easier to distribute and removes dependencies on IIS. Keep in mind that this is a very early preview and many Excel features are not yet supported. We have a special DevChannel forum in which you can discuss any problems you may be having.

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 other purpose.

SpreadJS Designer and Sparklines

The SpreadJS Designer allows you to create sparklines quickly and without code.

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 having to worry about constraints on that view. In particular, camera shapes help make creating dashboards and complex reports simple and easy. In this blog post, I will show you how to create a custom CameraShape class for use in SpreadJS.

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.

Using the Spread.Sheets Custom Slicer to Create a Filter Panel

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 libraries. A very common use of slicers are the filter panels you see on common product websites such as Amazon.com. When you narrow your list down by price and brand, for example, you are using a slicer.

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 overview:

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.

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.

Creating Cells with the SpreadJS Designer

The SpreadJS Designer allows you to create basic cell types quickly and without code.