Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread.CellType Namespace / GeneralCellType Class / NegativeRed Property

In This Topic
    NegativeRed Property (GeneralCellType)
    In This Topic
    Gets or sets whether negative values are displayed in red.
    Public Property NegativeRed As Boolean
    Dim instance As GeneralCellType
    Dim value As Boolean
    instance.NegativeRed = value
    value = instance.NegativeRed
    public bool NegativeRed {get; set;}

    Property Value

    Boolean: true to display negative values in red; false otherwise
    This example specifies a NumberFormatInfo which is used to format a currency value.
    FarPoint.Win.Spread.CellType.GeneralCellType genlcell = new FarPoint.Win.Spread.CellType.GeneralCellType();
    System.Globalization.NumberFormatInfo numform = (System.Globalization.NumberFormatInfo)System.Globalization.NumberFormatInfo.CurrentInfo.Clone();
    numform.CurrencySymbol = "\xA3";   
    Decimal myCurrency = new Decimal( 123456 );
    genlcell.NumberFormat = numform;
    genlcell.NegativeRed = true;
    fpSpread1.ActiveSheet.Cells[0, 0].CellType = genlcell;
    fpSpread1.ActiveSheet.Cells[0, 0].Value = myCurrency.ToString( "C", numform );
    Dim genlcell As New FarPoint.Win.Spread.CellType.GeneralCellType()
    Dim numform As System.Globalization.NumberFormatInfo = CType(System.Globalization.NumberFormatInfo.CurrentInfo.Clone(), System.Globalization.NumberFormatInfo)
    numform.CurrencySymbol = Chr(163)
    Dim myCurrency As New (Decimal)(123456)
    genlcell.NumberFormat = numform
    genlcell.NegativeRed = True
    FpSpread1.ActiveSheet.Cells(0, 0).CellType = g
    FpSpread1.ActiveSheet.Cells(0, 0).Value = myCurrency.ToString("C", numform)
    See Also