| Code Block |
|---|
|
{{type:'date',dateFormat:'MM/DD/YYYY',correctFormat:true,defaultDate:'01/01/1900',datePickerConfig:{firstDay:0,showWeekNumber:true,numberOfMonths:3,disableDayFn:function(date){return date.getDay()===0 || date.getDay()===6;}}}} |
| Code Block |
|---|
|
{{type:'date',dateFormat:'MM/DD/YYYY',correctFormat:true,defaultDate:'01/01/1900',datePickerConfig:{firstDay:0,showWeekNumber:true,numberOfMonths:3}}} |
| Code Block |
|---|
|
{{type:'date',dateFormat:'MM/DD/YYYY',correctFormat:true,defaultDate:'#date.dd/MM/yyyy#',datePickerConfig:{firstDay:0,showWeekNumber:false,numberOfMonths:3,minDate:new Date()}}} |
| Code Block |
|---|
|
{{type: 'handsontable', handsontable: { colHeaders: ['Marque', 'Country', 'Parent company'], autoColumnSize: true, data: [{name: 'BMW', country: 'Germany', owner: 'Bayerische Motoren Werke AG'}, {name: 'Chrysler', country: 'USA', owner: 'Chrysler Group LLC'}, {name: 'Nissan', country: 'Japan', owner: 'Nissan Motor Company Ltd'}, {name: 'Suzuki', country: 'Japan', owner: 'Suzuki Motor Corporation'}, {name: 'Toyota', country: 'Japan', owner: 'Toyota Motor Corporation'}, {name: 'Volvo', country: 'Sweden', owner: 'Zhejiang Geely Holding Group'}], getValue: function() {var selection = this.getSelected(); return this.getSourceDataAtRow(selection[0]).name; }}}}
|
| Code Block |
|---|
|
{{renderer:function(instance, td, row, col, prop, value, cellProperties){Handsontable.renderers.TextRenderer.apply(this, arguments);td.style.backgroundColor = 'green';}}} |
Custom Renderer to Change Text Style to Bold
| Code Block |
|---|
|
{{renderer:function(instance, td, row, col, prop, value, cellProperties){console.log(value);td.innerHTML='<b>'+value+'</b>';}}} |
When integer value less than 60, set background color to green, otherwise, red.
| Thai |
|---|
เมื่อค่าจำนวนเต็มน้อยกว่า 60 ให้ตั้งค่าสีพื้นหลังเป็นสีเขียวมิฉะนั้นจะเป็นสีแดง |
| Code Block |
|---|
|
{{renderer:function(instance, td, row, col, prop, value, cellProperties){console.log(value);if(parseInt(value)<60){td.innerHTML="<span style='color: white; background-color: green;'>"+value+"</span>";}else{td.innerHTML="<span style='color: white; background-color: red;'>"+value+"</span>";}}}} |
| Code Block |
|---|
|
{{type:'date',dateFormat:'MM/DD/YYYY',correctFormat:true,defaultDate:'01/01/1900',datePickerConfig:{firstDay:0,showWeekNumber:true,numberOfMonths:3,disableDayFn:function(date){return date.getDay()===0 || date.getDay()===6;}},renderer:function(instance, td, row, col, prop, value, cellProperties){Handsontable.renderers.TextRenderer.apply(this, arguments);td.style.backgroundColor = 'green';}}} |
Display Format: DD-MM-YYYY
| Thai |
|---|
รูปแบบการแสดงผล: DD-MM-YYYY |
Data Format: YYYY-MM-DD
| Thai |
|---|
รูปแบบข้อมูล: YYYY-MM-DD |
| Code Block |
|---|
|
{{type:'date',dateFormat:'YYYY-MM-DD',renderer:function(instance, td, row, col, prop, value, cellProperties){if(value!=""){const parts = value.split('-');const day = parseInt(parts[2], 10);const month = parseInt(parts[1] - 1, 10) + 1;const year = parseInt(parts[0], 10);const formattedDate = day + "-" + month + "-" + year;td.innerHTML=formattedDate;}}}} |
