← Back to all blogs

Featured Posts

Posts tagged with 'spreadsheet'

Using Charts in SpreadJS V9

Using Custom Floating Objects in SpreadJS can be useful to display large graphs inside of the widget. However, large amounts of data can be hard to display in the widget with the graph. In this blog, I will describe the steps for creating a D3-based chart using data from a SpreadJS widget used a fixed-position div element.

Getting the Most Out of Your Spread Experience

If you own a Spread license, you probably already know a lot about the product, but did you know everything that comes with it? Use this article as a guide to getting the most out of your partnership with us.

Spread ASP.NET and Custom Cell Types

Spread ASP.NET allows you to create your own custom cell types. This can be useful if a default cell type does not have the feature you need.

Spread Windows Forms and Drag and Drop

You can drag and drop data from a Spread control to another Spread control using drag events such as DragEnter, DragOver, and DragDrop. Drag and drop requires fewer steps than copy and paste.

Spread Windows Forms and Visual Studio 2015

You can use Spread Windows Forms in Visual Studio 2015.

Spread ASP.NET and Visual Studio 2015

You can use Spread ASP.NET in Visual Studio 2015.

SpreadJS Validation

You can use data validation to control the type of data and values that users are allowed to enter in a cell. This can be useful if you only want to allow correct values in a cell based on your data. SpreadJS supports data validation.

Spread Windows Forms and Printing

Spread Windows Forms supports printing to a PDF file or previewing the output before printing. This allows you to check the data and layout before printing, which can save paper.

Adding a Ribbon to Spread for Winforms

The Windows Forms Spread control brings powerful grid tools and features to desktop applications that users can run on their computer. In the Spread Designer, it is easy to create and format spreadsheets, but it might also be useful for the user to perform these actions at runtime. This tutorial provides step-by-step instructions for adding an open-source Ribbon toolbar to a Windows Forms application with Spread. The toolbar being used in this tutorial is an open-source ribbon for Windows Forms applications called the “Office Ribbon Project” and can be found here: http://officeribbon.codeplex.com/releases/view/113126.

SpreadASP Excel Copy/Paste

Spread for ASP.NET is a useful component for providing Spreadsheet functionality on a web server. While Spread has many great features, it might be beneficial for a user to paste cell ranges into the Spread component, without having to worry about reformatting the cells or writing any code. In this tutorial, we will create an ASP Web Application that allows the users to paste cell ranges from Excel into Spread while keeping the formatting.

SpreadJS and Visual Studio

You can use SpreadJS in a Visual Studio project. This provides access to automatic complete and code checking in Visual Studio.

Adding a Ribbon to SpreadASP

Toolbars are a useful addition that allow end-users to manipulate components on a webpage. This tutorial provides step-by-step instructions for adding an open source Ribbon toolbar to an instance of SpreadASP. The toolbar we are using is an open source JQuery ribbon that can be found here: https://www.openhub.net/p/jquery-ui-ribbon. Other ribbons can be used, but this is a simple example to show how we can go about connecting a ribbon to SpreadASP.

Spread ASP.NET and Client Events

You can use client events in Spread ASP.NET. Client-side scripting allows the user to interact with the page on the client without the page having to be reloaded from the server. This can be useful if the event relies on run time only information.

Adding Undo/Redo to a Ribbon with SpreadJS

Utilizing a Ribbon toolbar with SpreadJS is useful and gives control to end-users without needing to have the knowledge of the code behind it. Users might also need to undo or redo an action, which is possible with keyboard shortcuts, but not with buttons in the Ribbon. This tutorial will show how to add undo/redo functionality for a particular button on the ribbon toolbar.

Spread WPF and Validation

You can use data validation to control the type of data and values that users are allowed to enter in a cell. This can be useful if you only want to allow correct values in a cell based on your data. Spread WPF supports data validation.

Adding a Ribbon to SpreadJS

It is common to need user controls, such as a toolbar, to allow end-users to manipulate SpreadJS sheets and their data. This tutorial will give step-by-step instructions for adding an open source Ribbon toolbar to an instance of SpreadJS. The toolbar we are using is an open source JQuery ribbon that can be found here: https://www.openhub.net/p/jquery-ui-ribbon. Other ribbons can be used, but this is a simple example to show how we can go about connecting a ribbon to SpreadJS.

Using Charts in SpreadJS

SpreadJS is a useful tool for adding the power of Spread to webpages using JavaScript. Being able to easily display data in a spreadsheet without having to create html tables by hand is useful for web developers who simply want to convey information. SpreadJS has the concept of Sparklines, which are small graphs contained within cells. While this is useful, it might also be desirable to create large graphs that don’t depend on being inside of a cell. To do this, we can use a Custom Floating Object to wrap a third-party chart into SpreadJS. In this blog, I will show you how to insert a D3-based chart inside of SpreadJS.

Spread 8 COM and Microsoft Visual Studio 2015

You can use the Spread 8 COM control in Microsoft Visual Studio 2015 with Microsoft Windows 10. Spread Windows Forms is a .NET control and is a better option; however, you may have older code or projects where you need to use Spread 8 COM.