CopyData | Spread ASP.NET 18

CopyData

In This Topic

Occurs when copying data.

Syntax

[Inline HTML]

[JavaScript]

FpSpread1.addEventListener("CopyData", handler, ...)

FpSpread1.onCopyData = handler

Arguments

event.includeColHeader: Include the column header
event.spread: Spread control that raises the event

Return Type

None

Remarks

This event is triggered when data is copied. Set the argument to true to copy the column header.

Example

This example JavaScript code maps the event for the Spread on the client side.

JavaScript	Copy Code
<script lang="javascript" type="text/javascript"> window.onload = function () { var spread1 = document.getElementById("<%=FpSpread1.ClientID %>"); if (document.all) { // IE if (spread1.addEventListener) { // IE9 spread1.addEventListener("CopyData", copydata, false); } else { // Other versions of IE and IE9 quirks mode (no doctype set) spread1.onCopyData = copydata; } } else { // Firefox spread1.addEventListener("CopyData", copydata, false); } } function copydata(event) { var event = window.event event.includeColHeader = false; } </script>

JavaScript

Copy Code

<script lang="javascript" type="text/javascript">
    window.onload = function () {
      var spread1 = document.getElementById("<%=FpSpread1.ClientID %>");
      if (document.all) {
      // IE
      if (spread1.addEventListener) {
      // IE9
      spread1.addEventListener("CopyData", copydata, false);
      } else {
      // Other versions of IE and IE9 quirks mode (no doctype set)
        spread1.onCopyData = copydata;
      }
}
      else {
      // Firefox
      spread1.addEventListener("CopyData", copydata, false);
      }
    }
    
    function copydata(event) {
      var event = window.event
      event.includeColHeader = false;
    }
    
</script>