myliang / x-spreadsheet

The project has been migrated to @wolf-table/table https://github.com/wolf-table/table
https://myliang.github.io/x-spreadsheet
MIT License
13.97k stars 1.67k forks source link

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

Closed yesusagayarajs closed 9 months ago

yesusagayarajs commented 11 months ago

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?