Spreadsheet

Spreadsheets are sophisticated components for entering tabular data. Input values can be obtained in object form in actions.

Tips

Properties

UI Dialog

Item	Input value	Option	Default value
ID	string		automatic
Width	number		850
Height	number		350
X	number
Y	number
Value	-
Visibility	boolean	- on - off	on

Action

Item	Properties	Data Type	Default value
id	string		automatic
width	number		850
height	number		350
x	number
y	number
value	object
visibility	boolean	- true - false	true

[Details 1] Example of value

{
    "sheets": [
        {
            "name": "sheet1",
            "data": [
                {
                    "cell": "A1",
                    "css": "dhx_generated_class_u1684485452487"
                },
                {
                    "cell": "B1",
                    "css": "dhx_generated_class_u1684485452487",
                    "format": "common",
                    "value": "A Course"
                },
                {
                    "cell": "C1",
                    "css": "dhx_generated_class_u1684485452487",
                    "format": "common",
                    "value": "B Course "
                },
                {
                    "cell": "D1",
                    "css": "dhx_generated_class_u1684485452487",
                    "format": "common",
                    "value": "C Course "
                },
                {
                    "cell": "A2",
                    "format": "common",
                    "value": "Monthly amount"
                },
                {
                    "cell": "B2",
                    "format": "common",
                    "value": 1000
                },
                {
                    "cell": "C2",
                    "format": "common",
                    "value": 1200
                },
                {
                    "cell": "D2",
                    "format": "common",
                    "value": 1500
                },
                {
                    "cell": "A3",
                    "format": "common",
                    "value": "Yearly amount"
                },
                {
                    "cell": "B3",
                    "format": "common",
                    "value": 10000
                },
                {
                    "cell": "C3",
                    "format": "common",
                    "value": 120000
                },
                {
                    "cell": "D3",
                    "format": "common",
                    "value": 15000
                }
            ],
            "cols": [
                {
                    "width": 120
                },
                {
                    "width": 120
                },
                {
                    "width": 120
                },
                {
                    "width": 120
                }
            ],
            "rows": [
                {
                    "height": 32
                },
                {
                    "height": 32
                },
                {
                    "height": 32
                }
            ]
        }
    ],
    "styles": {
        "dhx_generated_class_u1684485452487": {
            "background": "#D4DAE4"
        }
    },
    "formats": [
        {
            "name": "Common",
            "id": "common",
            "mask": "",
            "example": "1500.31"
        },
        {
            "name": "Number",
            "id": "number",
            "mask": "#,##0.00",
            "example": "1500.31"
        },
        {
            "name": "Percent",
            "id": "percent",
            "mask": "#,##0.00%",
            "example": "15.0031"
        },
        {
            "name": "Currency",
            "id": "currency",
            "mask": "$#,##0.00",
            "example": "1500.31"
        },
        {
            "name": "Date",
            "id": "date",
            "mask": "mm-dd-yy",
            "example": "44490",
            "dateFormat": "%d/%m/%Y"
        },
        {
            "name": "Time",
            "id": "time",
            "mask": "h:mm:ss am/pm",
            "example": "0.5625",
            "timeFormat": 12
        },
        {
            "name": "Text",
            "id": "text",
            "mask": "@",
            "example": "some text"
        }
    ]
}

Event

None