Skip to content
Merged
Show file tree
Hide file tree
Changes from all commits
Commits
File filter

Filter by extension

Filter by extension

Conversations
Failed to load comments.
Loading
Jump to
Jump to file
Failed to load files.
Loading
Diff view
Diff view
30 changes: 15 additions & 15 deletions WindowsForms/GridGrouping/Exporting.md

Large diffs are not rendered by default.

10 changes: 5 additions & 5 deletions WindowsForms/GridGrouping/Expression-Fields.md
Original file line number Diff line number Diff line change
Expand Up @@ -10,7 +10,7 @@ documentation: ug
# Expression Fields in Windows Forms GridGrouping control
The GridGroupingControl lets column to display the calculation results based on other fields in the same record. The calculation result can be displayed in a separate column i.e. unbound column. These expression columns can be visible or invisible, used in grouping and sorting, and may be employed as summary fields for summary rows.

The [ExpressionFields](https://help.syncfusion.com/cr/windowsforms/Syncfusion.Windows.Forms.Grid.Grouping.GridTableDescriptor.html) are maintained in the [ExpressionFieldsDescriptorCollection](http://help.syncfusion.com/cr/windowsforms/Syncfusion.Grouping.ExpressionFieldDescriptorCollection.html) in which each entry termed as [ExpressionFieldDescriptor](http://help.syncfusion.com/cr/windowsforms/Syncfusion.Grouping.ExpressionFieldDescriptor.html) defines one expression field.
The [ExpressionFields](https://help.syncfusion.com/cr/windowsforms/Syncfusion.Windows.Forms.Grid.Grouping.GridTableDescriptor.html) are maintained in the [ExpressionFieldsDescriptorCollection](https://help.syncfusion.com/cr/windowsforms/Syncfusion.Grouping.ExpressionFieldDescriptorCollection.html) in which each entry termed as [ExpressionFieldDescriptor](https://help.syncfusion.com/cr/windowsforms/Syncfusion.Grouping.ExpressionFieldDescriptor.html) defines one expression field.

The below example shows the behavior of the ExpressionFields in the GridGroupingControl,

Expand All @@ -22,7 +22,7 @@ The ExpressionFields can be added to GridGroupingControl at design time by using

![Expression-Fields_img3](Expression-Fields_images/Expression-Fields_img3.png)

The [ExpressionFieldDescriptor](http://help.syncfusion.com/cr/windowsforms/Syncfusion.Grouping.ExpressionFieldDescriptor.html) class has the following properties.
The [ExpressionFieldDescriptor](https://help.syncfusion.com/cr/windowsforms/Syncfusion.Grouping.ExpressionFieldDescriptor.html) class has the following properties.

* [Name](https://help.syncfusion.com/cr/windowsforms/Syncfusion.Grouping.FieldDescriptor.html#Syncfusion_Grouping_FieldDescriptor_Name) – Specifies the name of the Expression field.
* [Expression](https://help.syncfusion.com/cr/windowsforms/Syncfusion.Grouping.ExpressionFieldDescriptor.html#Syncfusion_Grouping_ExpressionFieldDescriptor_Expression) – Specifies the formula expression.
Expand Down Expand Up @@ -384,7 +384,7 @@ Me.gridGroupingControl1.TableDescriptor.Columns("Losing %
![Expression-Fields_img5](Expression-Fields_images/Expression-Fields_img5.png)

## Adding Custom Function
The custom functions which can be any mathematical formulas or calculation method can be used in the ExpressionFields. The can be done by using the [ExpressionFieldEvaluator](http://help.syncfusion.com/cr/windowsforms/Syncfusion.Grouping.ExpressionFieldDescriptor.html) class.
The custom functions which can be any mathematical formulas or calculation method can be used in the ExpressionFields. The can be done by using the [ExpressionFieldEvaluator](https://help.syncfusion.com/cr/windowsforms/Syncfusion.Grouping.ExpressionFieldDescriptor.html) class.

The following steps are used to add the custom function in ExpressionFields,

Expand Down Expand Up @@ -492,9 +492,9 @@ Me.gridGroupingControl1.TableDescriptor.ExpressionFields.AddRange(New Expression
![Expression-Fields_img6](Expression-Fields_images/Expression-Fields_img6.png)

## Adding Calculate Engine Formulas
The [Essential Calculate formula](http://help.syncfusion.com/windowsforms/calculate/calculate-functions) functions can also be used as custom function for the calculation of Expression Fields. The **Syncfusion.Calculate.Base.dll**provides the accessible to use the calculate engine.
The [Essential Calculate formula](https://help.syncfusion.com/windowsforms/calculation-engine/supported-formulas/supported-formulas) functions can also be used as custom function for the calculation of Expression Fields. The **Syncfusion.Calculate.Base.dll**provides the accessible to use the calculate engine.

Please refer the below dashboard sample to create the [CalcEngine](http://help.syncfusion.com/cr/windowsforms/Syncfusion.Calculate.CalcEngine.html) with the [ICalcData](http://help.syncfusion.com/cr/windowsforms/Syncfusion.Calculate.ICalcData.html),
Please refer the below dashboard sample to create the [CalcEngine](https://help.syncfusion.com/windowsforms/calculation-engine/supported-formulas/supported-formulas) with the [ICalcData](https://help.syncfusion.com/cr/windowsforms/Syncfusion.Calculate.ICalcData.html),

**<Installation Location>\Syncfusion\EssentialStudio\<Product Version>\Windows\Calculate.Windows\Samples\Array ICalcData Demo**

Expand Down
10 changes: 5 additions & 5 deletions WindowsForms/GridGrouping/FindAndReplace.md
Original file line number Diff line number Diff line change
Expand Up @@ -10,8 +10,8 @@ documentation: ug
# Find and Replace in Windows Forms GridGrouping control
The searching and replacing of text and numbers can be done as like the Find and Replace functionality in the Excel. This can be done by using dialog or programmatically. This feature can be added to the GridGroupingControl by including the `Syncfusion.GridHelperClasses.Windows.dll` to the assembly reference. The following classes are used to implement the Find and Replace technique in GridGroupingControl.

* [GridFindReplaceDialogSink](http://help.syncfusion.com/cr/windowsforms/Syncfusion.Windows.Forms.Grid.GridFindReplaceDialogSink.html#)
* [GridFindReplaceDialog](http://help.syncfusion.com/cr/windowsforms/Syncfusion.Windows.Forms.Grid.GridFindReplaceDialog.html#)
* [GridFindReplaceDialogSink](https://help.syncfusion.com/cr/windowsforms/Syncfusion.Windows.Forms.Grid.GridFindReplaceDialogSink.html)
* [GridFindReplaceDialog](https://help.syncfusion.com/cr/windowsforms/Syncfusion.Windows.Forms.Grid.GridFindReplaceDialog.html)

The `GridFindReplaceDialogSink` class is used to perform the Find and Replace of text in GridGroupingControl. The `GridFindReplaceDialog` is the built-in dialog which shows the options for finding and replacing of the text. If this dialog is used for finding and replacing, there is no need to implement the methods for finding and replacing the text programmatically.

Expand Down Expand Up @@ -44,7 +44,7 @@ findReplaceDialog.ShowDialog()
![FindAndReplace_img1](FindAndReplace_images/FindAndReplace_img1.png)

## Finding options
The finding options are used to set certain conditions for search the text and number using the [GridFindTextOptions](http://help.syncfusion.com/cr/windowsforms/Syncfusion.Windows.Forms.Grid.GridFindTextOptions.html#) enumeration property. It has the following finding options,
The finding options are used to set certain conditions for search the text and number using the [GridFindTextOptions](https://help.syncfusion.com/cr/windowsforms/Syncfusion.Windows.Forms.Grid.GridFindTextOptions.html) enumeration property. It has the following finding options,

**MatchCase** -Matches case while performing search.
**MatchWholeCell** -Matches the search text with the entire text in a grid cell.
Expand Down Expand Up @@ -118,7 +118,7 @@ Private Sub gridGroupingControl1_ TableControlCurrentCellKeyDown
![FindAndReplace_img1](FindAndReplace_images/FindAndReplace_img1.png)

## Programmatic searching
The Find and Replace of the text in GridGroupingControl can be customized or can be used other than the `GridFindReplaceDialog`. The [GridFindReplaceEventArgs](http://help.syncfusion.com/cr/windowsforms/Syncfusion.Windows.Forms.Grid.GridFindReplaceEventArgs.html#) class provides the options to the `GridFindReplaceDialogSink` to perform the Find and Replace programmatically without having dialog.
The Find and Replace of the text in GridGroupingControl can be customized or can be used other than the `GridFindReplaceDialog`. The [GridFindReplaceEventArgs](https://help.syncfusion.com/cr/windowsforms/Syncfusion.Windows.Forms.Grid.GridFindReplaceEventArgs.html) class provides the options to the `GridFindReplaceDialogSink` to perform the Find and Replace programmatically without having dialog.

### Find and find all
To find first possible match at the earliest based on the search options, use the [Find](https://help.syncfusion.com/cr/windowsforms/Syncfusion.Windows.Forms.Grid.Grouping.GridGroupTypedListRecordsCollection.html) method. The below code is used to find the text in GridGroupingControl
Expand Down Expand Up @@ -235,7 +235,7 @@ The following sample shows how to include the find and replace functionality in
<Installation_Location>\Syncfusion\EssentialStudio\<version>\Windows\Grid.Grouping.Windows\Samples\Layout Customization\Find-Replace Demo

## Highlight the search text
The search text can be highlighted by using the [GridHighlightSearchText](http://help.syncfusion.com/cr/windowsforms/Syncfusion.GridHelperClasses.GridHighlightSearchText.html#) class. It will highlight the search text with the default color (yellow). The highlighting color can be changed by using[HighlightColor](https://help.syncfusion.com/cr/windowsforms/Syncfusion.GridHelperClasses.GridHighlightSearchText.html#Syncfusion_GridHelperClasses_GridHighlightSearchText_HighlightColor) property.
The search text can be highlighted by using the [GridHighlightSearchText](https://help.syncfusion.com/cr/windowsforms/Syncfusion.GridHelperClasses.GridHighlightSearchText.html) class. It will highlight the search text with the default color (yellow). The highlighting color can be changed by using[HighlightColor](https://help.syncfusion.com/cr/windowsforms/Syncfusion.GridHelperClasses.GridHighlightSearchText.html#Syncfusion_GridHelperClasses_GridHighlightSearchText_HighlightColor) property.
{% tabs %}
{% highlight c# %}
//Creates an instance for the class “GridHighlightSearchText”.
Expand Down
Loading