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?
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 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.
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.
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 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 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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.