PasteLikeExcel

In This Topic

Pastes the Clipboard contents to the cells, starting with the active cell.

Syntax

[JavaScript]

FpSpread1.PasteLikeExcel();

Parameters

None

Return Type

None

Remarks

This method pastes the data. This method does not cause a postback to occur.

Example

This is a sample that contains the method. On the client side, the script that contains the method would look like this:

JavaScript	Copy Code
<SCRIPT language=javascript> function pasteData() { FpSpread1.PasteLikeExcel(); } </SCRIPT>

This example maps keys to the cut, copy, and paste functions:

JavaScript	Copy Code
<script type="text/javascript"> window.onload = function () { var spread = document.getElementById("FpSpread1"); spread.AddKeyMap(67, true, false, false, "CopyLikeExcel()"); // Ctrl + C spread.AddKeyMap(86, true, false, false, "PasteLikeExcel()"); // Ctrl + V spread.AddKeyMap(88, true, false, false, "CutLikeExcel()"); // Ctrl + X //or //spread.AddKeyMap(86, false, false, false, function () { var ss = spread; ss.PasteLikeExcel(); }); //v } </script>

JavaScript

Copy Code

<script type="text/javascript">
        window.onload = function () {
           var spread = document.getElementById("FpSpread1");
           spread.AddKeyMap(67, true, false, false, "CopyLikeExcel()"); // Ctrl + C
           spread.AddKeyMap(86, true, false, false, "PasteLikeExcel()"); // Ctrl + V
           spread.AddKeyMap(88, true, false, false, "CutLikeExcel()"); // Ctrl + X
//or
//spread.AddKeyMap(86, false, false, false, function () { var ss = spread; ss.PasteLikeExcel(); }); //v
        }
        </script>

Product Support Forum | Print this page