jSpreadsheet Plugin : Copy Paste Advanced

The Copypaste_advanced plugin improves the copy paste functionality of jSpreadsheet. It works even if access to the clipboard is denied or in error.

This plugin is Free

Features

• Add items cut, copy, paste on default toolbar
• Add item paste on default context menu when it is not present
• Upgrade copy/paste of jSpreadsheet when clipboard access is denied
• Override copy methods of jSpreadsheet
• Can copy scale like Excel
• Work on Mobile
• Paste data from Excel (with or without style)
• Add items on topmenu bar (plugin) where you want with position property
• NEW : Multiple select cells with Ctrl pressed, copy this multiple cells and paste

What is jSpreadsheet ?

jSpreadsheet, a lightweight Vanilla JavaScript plugin, can help you create exceptional web-based interactive tables and spreadsheets. Compatible with most widely-used spreadsheet software, such as Excel or Google Spreadsheet, it offers users an unrivalled Excel-like user experience. It also works well with prominent modern frameworks and flexibly utilizes a large collection of events, extensions and configurations to meet different application requirements. Impress your clients with a better user experience and a great dynamic interactive data management tool.

• Download jSpreadsheet Pro

Documentation

Dependencies

• jSpreadsheet Pro v8 or
• jSpreadsheet Pro v9
• or
• jSpreadsheet Pro v10

Options of plugin

For translation

you can use jSuites dictionary for translate this plugin

Methods of plugin

Get started

Header on page

<script src="https://cdn.jsdelivr.net/npm/jspreadsheet/dist/index.min.js"></script>
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/jspreadsheet/dist/jspreadsheet.min.css" type="text/css" />
<script src="https://cdn.jsdelivr.net/npm/jsuites/dist/jsuites.min.js"></script>
<link rel="stylesheet" href="https://cdn.jsdelivr.net/npm/jsuites/dist/jsuites.min.css" type="text/css" />

<script src="/path/to/copypaste_advanced.min.js"></script>

Initialize plugin on jSpreadsheet

jspreadsheet(document.getElementById('spreadsheet'), {
	...
	plugins: [
      ...
      { name:'copypaste_adv', plugin:jss_copypaste_advanced},
      ...  
    ],
    ...
});

Example of code for custom toolbar

jspreadsheet(document.getElementById('spreadsheet'), {
	...
	toolbar: [
      ...
        {
	        content: 'content_cut',
	        onclick: function() {
	            if (jspreadsheet.current.selectedCell) {
	                jspreadsheet.current.copy(true);
	            }
	        }
	    },
	    {
	        content: 'content_copy',
	        onclick: function() {
	            if (jspreadsheet.current.selectedCell) {
	                jspreadsheet.current.copy();
	            }
	        }
	    },
	    {
	        content: 'content_paste',
	        onclick: function() {
	            if (jspreadsheet.current.selectedCell) {
	                jspreadsheet.current.parent.plugins.copypaste_adv.paste();
	            }
	        }
	    },
      ...  
    ],
    ...
});

CDN

You can use this CDN link

<script src="https://cdn.jsdelivr.net/gh/GBonnaire/jspreadsheet-plugins-and-editors@latest/plugins/JSSV8/dist/copypaste_advanced.min.js"></script>

NPM

npm install @jspreadsheet/copypaste_advanced

import jss_copypaste_advanced from  '@jspreadsheet/copypaste_advanced';

Copyright and license

Copyright GBonnaire.fr and Code released under the MIT License