← Back to all blogs
Profile photo of Eric Peng
About the Author

Eric Peng

A global product manager at GrapeCity, Eric Peng likes the challenge of component development and helping developers make applications easier with GrapeCity's products. Before joining the company more than twenty years ago, he graduated from Southeast University with a bachelor's degree. In his free time, Eric enjoys reading, listening to music, and playing badminton.

Recent Posts

Build Recap: Opportunities and a Bright Future

MS Build 2017 marked the first year Microsoft held the Build conference in Seattle. I arrived in Seattle on Tuesday afternoon, and it was the first time I visited this beautiful city. It was also the first time I used Uber. I booked an UberX through the App, and after several minutes a Toyota Prius arrived in the parking lot designated for Uber service in the airport, so it was pretty easy.

Spread Studio 8 Released!

I am very happy to announce the release of Spread Studio 8!  We've added a lot of new features and made an array of enhancements. With this release Spread for ASP.NET now fully supports Chrome, and Firefox, and also it also runs on iPad. Spread for WinForms provides a Table feature which includes built-in styles and also supports structured reference. Our MultiRow for WinForms control received some nice enhancements as well. Spread XAML (WPF/Silverlight/WinRT), now offers printing (Spread WPF provides print preview), and structured references. Moreover, for all platforms the Spread controls have nice new appearances.

Space Char in Spread for ASP.NET

The space char is reserved in HTML, if page content has more than two space chars between two words, HTML only shows one space. It is same in the cell of Spread for ASP.NET in default, because Spread for ASP.NET uses HTML to render in client side browser.

Use custom function to implement INDIRECT in Spread

INDIRECT is an useful function, it returns the reference specified by a text string, and the references are immediately evaluated to display their contents. Currently Spread doesn't support INDIRECT yet, but Spread provides powerful customization ability, you may use custom function to implement a simple INDIRECT function. Here is a sample shows how to do it.

Spread Studio for .NET 7 v3 Released!

I am very happy to announce the release of Spread Studio for .NET 7 v3! This is the first release of 2014 and features new operating systems support, including Microsoft Windows® 8.1 and Microsoft Windows® Server 2012 R2, for all products, including Spread for WinForms, Spread for ASP.NET, Spread WPF-Silverlight, and Spread WinRT. We've also added design-time support for these products in Visual Studio 2013 and, in this release, Spread for ASP.NET now features support for Internet Explorer 11. Get it today, right here:

Integrate Spreadsheet into CaplinTrader by Using SpreadJS

CaplinTrader by Caplin, is a pure HTML5 technology product that provides sophisticated ready-to-run trading front ends for a range of asset classes. CaplinTrader comes complete with tools that make it easy to style, brand, modify and extend these.

Add Context Menu for SpreadJS

Do you want to add a context menu in SpreadJS? It is very simple. No mouse down event, no left or right mouse button checking, just popup the menu in contextmenu event of the SpreadJS place-holder element.

Spreadsheet Viewer App

A new version of the ComponentOne Spreadsheet Viewer app has arrived! This app was originally named ComponentOne Excel Viewer, and we’ve changed the name to ComponentOne Spreadsheet Viewer.

Announcing Spread WPF-Silverlight 7 v2!

ComponentOne is proud to announce the release of the new Spread WPF-Silverlight 7 v2. There are major upgrades to this version compared to the last release one year ago. There are many new features in this release including: the introduction of Excel 2013 like UI appearance and gesture touch support, Improvements for Excel file import/export and formula calculation performance, 10 categories 40+ chart types totally compatible with Excel, the ability to embed pictures into documents, a formula textbox control, and more...

Announcing Spread WinRT 7 v2!

ComponentOne is proud to announce the release of the new Spread WinRT 7 v2. There are major upgrades to this version compared to the last release 9 months ago. There are many new features in this release including: the introduction of Excel 2013 like UI and gesture touch support, Improvements for Excel file import/export and formula calculation performance, 10 categories 30+ chart types totally compatible with Excel, the ability to embed pictures into documents, a formula textbox control, and more...

How To Validate Data Entry in SpreadJS

Here are some common scenarios that may sound familiar to you:

Understand Cell Style Composite in SpreadJS

SpreadJS not only provides style for the cell, but also for the row, the column, and the sheet, so that you can quickly customize the appearance of a cell or a range of cells (or rows or columns) or default style for all cells in the sheet.

How to Set Cell Styles in SpreadJS

A Cell Style is a great way to make important data stand out on a sheet, SpreadJS provides styles to customize your text to give it the exact look you want. You can add a variety of styles and colors to your text, as well as borders or gridlines of cells.

How To Merge Cells in SpreadJS

Merging is when you combine a range of cells to create a new, larger cell. This is a great way to create a label that spans several columns or several rows. You can easily create a cell span in the view port, row header, or column header area by using the addSpan method of Sheet object, and remove the span from a merged cell by using the removeSpan method.

How To Set Cell Value in SpreadJS

SpreadJS provides many ways to assign values to cells, you can choose any one of the options

Quick Start Guide to Using SpreadJS

SpreadJS is JavaScript spreadsheet widget which is based on HTML5 and jQuery technology. It is very easy to use in a web page, and in this post I’ll show you how to initialize a SpreadJS widget in a web page in four simple steps.

Spread WinRT 1.0.6.0 Released!

I am happy to announce the release of Spread WinRT 1.0.6.0!