← Back to all blogs

Recent Posts

Formatting Date Column based on day of week with ComponentOne Wijmo GridView

ComponentOne's Wijmo GridView is an advanced GridView control which works perfectly in bound mode. There are times when you may want to bind your Wijmo GridView to a data source which has Date columns as well. In this blog, we are going to learn how we can format this date column based on the day of the week.

Best way to manage state when Spread has large data- Part II

Continuing my previous blog here we would discuss other two approaches of managing state with ComponentOne Spread for ASP.Net i.e.

ComponentOne Spread with jQuery Calendar

ComponentOne Spread for ASP.Net provides several ways to show data for Date format. You may either use the built in DateTimeCellType which allows editing the date or you may use the Ajax Calendar Control inside ComponentOne Spread's cell. Recently a customer came up with an interesting question about using a jQuery control inside a cell replacing the Ajax calendar control. In this blog I am going to talk about replacing the Ajax calendar control with the jQuery date picker step by step:

Best Way to Manage State When Spread has Large Data - Part I

State management has been a very important aspect of ASP.NET application development. Being an ASP.NET control ComponentOne Spread for ASP.NET also supports different processes of managing state. With Spread, we can primarily manage state with the following processes:

Data Visualization with Spread

Seeing the current trends and user demands, ComponentOne has recently added a Chart control in Spread for Silverlight and WPF. This feature was in great demand because the Spread control has always been a replica of Microsoft Excel and Microsoft Excel has always had charts.

Grouping and UnGrouping Spread at Runtime

When we talk about Grids in general there are few common features that come to mind, like Filtering , Sorting, Grouping, etc.

Binding Silverlight Chart to XML data source

There are scenarios where one would need to bind the component to an XML data source. Specially presenting the XML data in human readable form is a very common requirement. This blog talks about how you can bind ComponentOne Chart for Silverlight to an XML data source.

How To: Create VSFlexGrid on the fly

Creating ComponentOne VSFlexGrid on the fly and adding it to Form is an easy task. In this blog we will explain how you can fill VSFlexGrid with data once it is added to Form at runtime. This blog is targeting the developers who are in love with VSFlexGrid and still work in ActiveX environment.

HowTo: Copy & Paste Multiline text within C1FlexGrid

Here in this blog, let's discuss how to copy and paste  multiline text within C1FlexGrid. In order to enable copying text with new line character and pasting it as it is in another cell you would need to handle the clipboard functionality manually.

Using CheckBox in ComponentOne TreeView Control

ComponentOne Studio for Silverlight includes a very useful control, C1TreeView, which can be used to create a hierarchical structure for data in nodes format.

Charts for Spread Silverlight

Charts have always been an important component which gives the flexibility to analyze and visualize data. On great demand of Spread customers, we have introduced Charts in Spread for Silverlight and WPF.

Excel Like formula with Spread for Silverlight

Spread for Silverlight has introduced an exciting new feature. Spread now provides a Formula TextBox which gets enabled when you enter a formula in a cell at run time. It now allows entering formulas in cells just like you do it in Microsoft Excel. Something like the image below:

HowTo: Customize FilterEditor of C1FlexGrid

ComponentOne FlexGrid allows end users to filter columns based on their values by using C1FlexGridFilterService. This service needs FlexGridFilter dll to be present in the project.

New CellType for Spread for WinForms – II

In the last blog we discussed about one of the new celltypes introduced in Spread for WinForms.

New CellType for Spread for WinForms - I

Spread 7 for WinForms has introduced two new CellTypes to provide more convenience to it's users

How to: AutoSize Spread for WinForms

The AutoSize feature of Spread COM removes the blank area around the grid cells such that Spread always takes the size of Rows and Column count. Unfortunately, this feature is not available  as a built-in feature with Spread for WinForms.

HowTo: Change Mouse Cursor for C1RichTextBox Table Element

In this blog lets discuss how we can change the mouse pointer over a table in a ComponentOne RichTextBox document. For example if we have a document in ComponentOne RichTextBox which contains a paragraph and a table and we want that the table should behave differently from the whole paragraph. If we hover the mouse over paragraph and in between there is a table in it the mouse cursor remains the same. Here we would want that the mouse pointer should remain same for the paragraph but different for the table. This is to discriminate between a Table and a paragraph. Have a look at the image below.

Custom ComboBoxCell in Spread for WinForms

Spread for WinForms supports multiple celltypes like CheckBoxCellType, NumberCellType, CurrencyCellType, ButtonCellType, DateTimeCellType ,ComboBoxCellType etc. All of these celltypes are customizable. In this post I am going to tell you how you can create a custom ComboBox CellType. We will create a custom combobox cell which will have the following features:

Paste from Excel in Spread for COM

One of the most common user scenario faced by the developers is to support/provide copy/paste feature from the clipboard. With the Spread for COM product, it is with ease to copy paste data from Excel file. However, user cannot copy paste more than 500 rows of data to Spread for COM in a single paste transaction.

SparkLines in Spread for Silverlight/WPF

We all want to have some graphical representation of our data in SpreadSheet. We usually do it using Charts in our Sheets. Unfortunately Charts are currently not available with Spread for Silverlight/WPF. However Spread provides an alternative for this; we can use SparkLines. You can show Sparkline within a cell which makes this feature more interesting.There are three types of Sparklines you can show in a cell.