2.7.7 DisplayFormat


Contents

Description

An integer value indicate current display format of the column

Syntax

VB: Property Get/Let DisplayFormat As Integer

C++: int DisplayFormat

C#: int DisplayFormat

Remark

0 to display as "Decimal:1000";
1 to display as "Scientific:1E3";
2 to display as "Engineering:1K";
3 to display as "Decimal:1,000";

Examples

VB

    Sub DisplayFormat()
        Dim app As Origin.IOApplication
        Dim wks As Origin.Worksheet
        'you may set the column display format(in Column Properties dialog) to a different type before running this code
        'e.g set data format as Date and Display yyMMdd HH:mm, the DisplayFormat will be 12 which is this format's position in the list( 0 offset )
        app = New Origin.ApplicationSI
        wks = app.FindWorksheet("") 'get active worksheet
        If wks Is Nothing Then
            MsgBox("Can not get active worksheet")
            Exit Sub
        End If

        Dim fmt As Integer
        fmt = wks.Columns(0).DisplayFormat
        MsgBox(fmt)
    End Sub

Version Information

8.0SR2

See Also