myliang/x-spreadsheet

How will give date and time for some coloumns in the angular

yesusagayarajs opened this issue · 0 comments

testSheetData = {
"name": "Page1",
"freeze": "A1",
"styles": [
{
"font": {
"bold": true,
"size": 12
},
"textwrap": true,
"bgcolor": "#fff2cd"
},
{
"format": "data"
},
{
"format": "number",
"align": "right"
},
{
"format": "percent"
},
{
"format": "percent",
"align": "right"
},
{
"align": "right"
},
{
"font": {
"bold": true,
"size": 12
},
"textwrap": true,
"bgcolor": "#fff2cd",
"align": "right"
},
{
"font": {
"bold": true,
"size": 12
},
"textwrap": true,
"bgcolor": "#fff2cd",
"align": "right",
"format": "number"
},
{
"font": {
"bold": true,
"size": 12
},
"textwrap": true,
"bgcolor": "#fff2cd",
"align": "right",
"format": "normal"
},
{
"font": {
"bold": true,
"size": 12
},
"textwrap": true,
"bgcolor": "#fff2cd",
"align": "right",
"format": "percent"
},
{
"font": {
"bold": true,
"size": 12
},
"textwrap": true,
"bgcolor": "#fff2cd",
"align": "center"
},
{
"font": {
"bold": true,
"size": 12
},
"textwrap": true,
"bgcolor": "#fff2cd",
"format": "number"
},
{
"font": {
"bold": true,
"size": 12
},
"textwrap": true,
"bgcolor": "#fff2cd",
"format": "normal"
},
{
"font": {
"bold": true,
"size": 12
},
"textwrap": true,
"bgcolor": "#fff2cd",
"align": "center",
"format": "normal"
},
{
"font": {
"bold": true,
"size": 12
},
"textwrap": true,
"bgcolor": "#fff2cd",
"format": "percent"
},
{
"font": {
"bold": true,
"size": 12
},
"textwrap": true,
"bgcolor": "#fff2cd",
"align": "center",
"format": "number"
},
{
"align": "center"
},
{
"font": {
"bold": true,
"size": 12
},
"textwrap": true,
"bgcolor": "#fff2cd",
"align": "left"
},
{
"align": "left"
},
{
"format": "normal",
"align": "right"
},
{
"format": "normal",
"align": "center"
},
{
"font": {
"bold": true,
"size": 12
},
"textwrap": true,
"bgcolor": "#fff2cd",
"align": "center",
"format": "percent"
}
],
"merges": [],
"rows": {
"0": {
"cells": {
"0": {
"text": "Organization",
"value": "Organization",
"style": 10,// style range 0-xx, causes changes to element alignment and format
"editable": false
},
"1": {
"text": "Date",
"value": "Date",
"style": 10,
"editable": false
},
"2": {
"text": "Week",
"value": "Week",
"style": 17,
"editable": false
},
"3": {
"text": "Start time",
"value": "Start time",
"style": 17,
"editable": false
},
"4": {
"text": "End time",
"value": "End time",
"style": 17,
"editable": false
},
"5": {
"text": "Responsable",
"value": "Responsable",
"style": 17,
"editable": false
},
"6": {
"text": "Assigned To",
"value": "Assigned To",
"style": 17,
"editable": false
},
"7": {
"text": "Product Name",
"value": "Product Name",
"style": 17,
"editable": false
},
"8": {
"text": "Product Code",
"value": "Product Code",
"style": 17,
"editable": false
},
"9": {
"text": "Amount",
"value": "Amount",
"style": 17,
"editable": false
},
"10": {
"text": "Amount Units",
"value": "Amount Units",
"style": 17,
"editable": false
},
"height": 97
}
},
},
"cols": {
"len": 15
},
"validations": [
{
"refs": [
"I3:I1000"
],
"mode": "cell",
"type": "list",
"required": true,
"operator": "be",
"value": "AED,USD,EURO"
},
{
"refs": [
"M3:M1000"
],
"mode": "cell",
"type": "list",
"required": true,
"operator": "be",
"value": "Y,N"
},
{
"refs": [
"P3:P1000"
],
"mode": "cell",
"type": "list",
"required": true,
"operator": "be",
"value": "Y,N"
},
{
"refs": [
"R3:R1000"
],
"mode": "cell",
"type": "list",
"required": true,
"operator": "be",
"value": "Y,N"
},
{
"refs": [
"N3:N1000"
],
"mode": "cell",
"type": "list",
"required": true,
"operator": "be",
"value": "1,2,3,4,5"
},
{
"refs": [
"S3:S1000"
],
"mode": "cell",
"type": "list",
"required": true,
"operator": "be",
"value": "1,5,10,15,20"
}
],
"autofilter": {}
}

I need date picker for some columns any idea?