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 |
- |
|
|