ASPxGridViewExportRenderingEventArgs.TextValueFormatString Property

Gets or sets the pattern used to format values.

Namespace: DevExpress.Web

Assembly: DevExpress.Web.v19.2.dll

Declaration

C#

public string TextValueFormatString { get; set; }

VB.NET

Public Property TextValueFormatString As String

Property Value

Type	Description
String	The pattern used to format values.

Remarks

C#

if (Curr == "USD") {
     e.TextValueFormatString = "$#,##0.00";
}
if (Curr == "EUR") {
     e.TextValueFormatString = "€#,##0.00";
}

VB.NET

Private Sub SurroundingSub()
    If Curr = "USD" Then
        e.TextValueFormatString = "$#,##0.00"
    End If
    If Curr = "EUR" Then
        e.TextValueFormatString = "€#,##0.00"
    End If
End Sub

Note

The TextValueFormatString property is in effect only for the XLS format. To set a cell’s format in non-Excel documents, use the ASPxGridViewExportRenderingEventArgs.XlsxFormatString, Text or TextValue properties.

C#

e.Text = String.Format("{0:0.00}", e.TextValue);