SPSubburaj Pandian Veluchamy Syncfusion Team August 5, 2019 06:25 AM
We have analyzed the reported query “How to restrict the string values while editing the cell value”. By default, we have converted the edited cell value into ‘Double’ type. If you have edited the cell value by using numeric string, the cell value automatically convert into zero using pivot editing manager). Suppose if you want to customize the entered string value, you should do the following changes in your application (applicable for defining the custom editing manager).
Please refer the following code sample,
PublicSubNew(ByVal pg As PivotGridControlBase)
ProtectedOverridesSub ChangeValue(ByVal oldValue AsObject, ByVal newValue AsObject, ByVal row1 AsInteger, ByVal col1 AsInteger, ByVal pi As PivotCellInfo)
IfNot System.Text.RegularExpressions.Regex.IsMatch(newValue, "^\d+$") Then
If the above solution does not resolve your actual requirement could you please share the detailed description about your requirement along with screenshots, so that it could be helpful to provide the solution at the earliest.