|
Lines 606-611
function _dt_buttons(params){
Link Here
|
| 606 |
exportColumns = settings["exportColumns"]; |
606 |
exportColumns = settings["exportColumns"]; |
| 607 |
} |
607 |
} |
| 608 |
|
608 |
|
|
|
609 |
const export_format_spreadsheet = { |
| 610 |
body: function ( data, row, column, node ) { |
| 611 |
var newnode = $(node); |
| 612 |
|
| 613 |
if ( newnode.find(".noExport").length > 0 ) { |
| 614 |
newnode = newnode.clone(); |
| 615 |
newnode.find(".noExport").remove(); |
| 616 |
} |
| 617 |
let trimmed_str = newnode.text().replace( /\n/g, ' ' ).trim(); |
| 618 |
const unsafeCharacters = /^[=+\-@\t\r]/; |
| 619 |
if ( unsafeCharacters.test(trimmed_str) ){ |
| 620 |
trimmed_str = "'" + trimmed_str; |
| 621 |
} |
| 622 |
return trimmed_str; |
| 623 |
} |
| 624 |
} |
| 625 |
|
| 609 |
var export_format = { |
626 |
var export_format = { |
| 610 |
body: function ( data, row, column, node ) { |
627 |
body: function ( data, row, column, node ) { |
| 611 |
var newnode = $(node); |
628 |
var newnode = $(node); |
|
Lines 624-637
function _dt_buttons(params){
Link Here
|
| 624 |
extend: 'excelHtml5', |
641 |
extend: 'excelHtml5', |
| 625 |
exportOptions: { |
642 |
exportOptions: { |
| 626 |
columns: exportColumns, |
643 |
columns: exportColumns, |
| 627 |
format: export_format |
644 |
format: export_format_spreadsheet |
| 628 |
}, |
645 |
}, |
| 629 |
}, |
646 |
}, |
| 630 |
{ |
647 |
{ |
| 631 |
extend: 'csvHtml5', |
648 |
extend: 'csvHtml5', |
| 632 |
exportOptions: { |
649 |
exportOptions: { |
| 633 |
columns: exportColumns, |
650 |
columns: exportColumns, |
| 634 |
format: export_format |
651 |
format: export_format_spreadsheet |
| 635 |
}, |
652 |
}, |
| 636 |
}, |
653 |
}, |
| 637 |
{ |
654 |
{ |
| 638 |
- |
|
|