Posts tagged with 'spreadsheet'
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.
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.
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.
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 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.
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.
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.
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.
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.
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.
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.
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.
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.