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.
Continuing my previous blog here we would discuss other two approaches of managing state with ComponentOne Spread for ASP.Net i.e.
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:
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:
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.
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.
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.
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.
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 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.
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:
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.
In the last blog we discussed about one of the new celltypes introduced in 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.
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.
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:
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.
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.