Sets the formatting options when displaying a Numeric column in the grid
Syntax
Public Sub SetColFormat (ByRef vKey As Variant, _
Optional ByVal sNumDecSep As String = "", _
Optional ByVal sNumValSep As String = "", _
Optional ByVal iNumFixInt As Integer = -1, _
Optional ByVal iNumFixDec As Integer = -1, _
Optional ByVal bNumSign As Boolean = False, _
Optional ByVal bNumAutoDecSep As Boolean = True, _
Optional ByVal bNumAutoValSep As Boolean = False)
Parameters
| Parameter |
Description |
| ByRef vKey As Variant |
The column key or index |
| Optional ByVal sNumDecSep As String = "" |
The decimal separator to use, leave blank to use the one used by the system |
| Optional ByVal sNumValSep As String = "" |
The valute separator, leave blank to use the one used by the system |
| Optional ByVal iNumFixInt As Integer = -1 |
Number of fixed digit to use for the integer part of the number, pass -1 to not use |
| Optional ByVal iNumFixDec As Integer = -1 |
Number of fixed digit to use for the decimal part of the number, pass -1 to not use |
| Optional ByVal bNumSign As Boolean = False |
True for using sign, False otherwise |
| Optional ByVal bNumAutoDecSep As Boolean = True |
True for using automatic decimal separator |
| Optional ByVal bNumAutoValSep As Boolean = False |
True for using automatic valute separator |
|