← Back to all blogs

Recent Posts

Trim Cell Text with Ellipsis in SpreadJS

If your text overflows the cell bounds then an ellipsis should be appended to the text and the rest is cut off. With this the user would be well aware of the fact that there is some amount of text that they can not see. Wouldn’t this be a nice feature for the SpreadJS cells as well?

Rotated Text in SpreadJS Cells

A frequently-asked question is how to rotate cell contents to vertical (or some other angle) in a SpreadSheet. The short answer is that you can't. However, SpreadJS provides simple workaround using CustomCellType in which we can rotate the text.

Adding Cell ToolTips in SpreadJS

Adding Tooltips to Spreadsheets is a common usage where you want to show additional information about cells. SpreadJS allows you to display the tooltip only for the HyperlinkCellType. However, you may want to show cell tooltips for any type of cell, say for instance to display the current cell location in a tooltip.

Hide Column From C1FlexGridGroupPanel While Dragging

Grouping in ComponentOne FlexGrid for WPF is implemented with the help of C1FlexGridGroupPanel. When grouping is applied on C1FlexGrid then a new grouping area is exposed in the header with a watermark informing you to drag and drop a column there to group by that column. It is possible to group by multiple columns simply by dragging a second ColumnHeader onto the grouping area.

Display Row Index in C1FlexGrid for LightSwitch

With this blog, we will be discussing on how to display the Row Index in C1FlexGrid for LightSwitch while maintaining the delete icon and new row icon in row header of C1FlexGrid.

Spread Silverlight can be customized to show various formats of data. In this blog we will discuss an approach to show Hyperlink Cells in Spread Silverlight.

Resizing Column In Spread WPF

Spread Winforms provides a very useful feature of resizing a Cell to Fit the Data using GetPreferredColumnWidth method wherein you can resize the cell based on the length of the data in the cell. The size of the cell with the largest data is called the preferred size. The SheetView GetPreferredCellSize method retrieves the preferred size of the specified cell.

ComponentOne Chart Highlight Rectangle

ComponentOne Chart for WPF/ Silverlight provides selection support wherein we can select the datapoints and highlight them by changing the color of the selected points. But sometimes we want to drag the mouse through a selected area and highlight all the datapoints which lies inside the selected area.

HowTo: Single Click Row Selection in C1DataGrid

ComponentOne DataGrid for Silverlight offers great deal of flexibility in the way its rows/ cells are selected. Please refer to the documentation for a list of the SelectionModes offered by C1DataGrid.

Drag and Drop Between C1DataGrids

ComponentOne Studio for WPF provides a very useful class C1DragDropManager which makes the drag/ drop operations very easy to handle. We can easily configure the class C1DragDropManager and instantly add the drag/drop feature to our application.

Show Progress Dialog While Loading Data

When you're designing your application you need to consider how you handle data loading in order to ensure the application always remains responsive to the user. Generally this is done by carrying out any data loading on a background thread, allowing the user to continue to interact with the application while the data is being loaded. However, this often leads the user to query whether anything is happening; which leads to the use of a progress bar to indicate that some activity is being executed in the background. Once the data has been loaded the progress bar should be hidden and the relevant controls to display the data should be shown.

How To: Export Multiple C1TrueDbGrids to Excel Sheets

There are many scenarios where we would want to export data into Excel format. The data could be from multiple ComponentOne TrueDbGrid for WinForms controls or from any other data bound control. However, using a C1TrueDbGrid control's ExportToExcel method we can't export multiple C1TrueDbGrids to a single Excel file.

How To: Export Multiple C1TrueDbGrids to a Single PDF

Exporting data to a PDF file is one of the most commonly preferred features in the .NET world. The essential ComponentOne TrueDbGrid for WinForms control has in-built support for PDF export. ExportToPDF method provides support for exporting data from a C1TrueDbGrid control to a PDF file. However, using ExportToPDF() method we can't export multiple C1TrueDbGrids to a single PDF file.

HowTo: Rotate Text in Merged Cells in C1FlexGrid

When using any Grid control, we generally have a requirement to display rotated text in some column or cell. With C1FlexGrid control, customization is always easy because of its ability to integrate with default .Net classes.

Handling Function Keys in Spread

When F2 and F3 keys are being captured by the SpreadView for processing, they do not get sent to the KeyEvents for the Spread. This happens because Keystrokes processed by the Spread control are divided into one of two groups.

C1Chart for WPF : Get Points in View on End User Interaction

ComponentOne Chart for WPF allows us to perform End User Interaction wherein we can zoom/ scale/ translate chart for a better view.

Recently a customer enquired about an implementation in Spread for Winforms control wherein he wanted to set custom formula for Column Footer Aggregation.

C1Knob with Frequency/Interval Step

Recently a customer enquired about an implementation in C1Knob control, part of Gauges for WPF wherein he wanted to change the value with a particular frequency/ interval just like a simple slider control behaves with interval property.

HowTo: Custom Sparkline in Spread for WinForms

Spread for Winforms provides a feature of creating sparklines wherein we can create a small graph in a cell that uses data from a range of cells. The data for the sparkline is limited to one column or row of values within the same SpreadSheet. We can set the SparklineType to column, line, or winloss etc.

HowTo: Manipulate Text Wrap in C1FlexGrid

C1FlexGrid enables cell text wrapping through cell styles. However, there is no direct way to perform customized text wrapping. For instance, suppose we want to perform wrapping after every 10 characters. In this scenario, we need to implement our own wrapping functionality.