ckeditor4-plugin-spreadsheet

Spreadsheet Plugin for CKEditor 4

The Spreadsheet plugin offers Excel-like functionality right inside CKEditor 4. It allows for creating complex data sheets that integrate smoothly with the existing CKEditor 4 WYSIWYG editor functionality and content, providing data types, formatting and styling, formulas, conditional formatting and more.

Refer to the Creating Data Grids with Spreadsheet Plugin article to learn more about the available features.

This feature is provided as a commercial product and provides integration with our partner solution, Handsontable. A license can be purchased here.

The Spreadsheet plugin is compatible with CKEditor 4 starting from version 4.13. It is not included in the CKEditor presets available from the Download site. Follow the instructions below to enable it.

Getting Started

Installation

There are a few methods that you can use in order to add the Spreadsheet plugin to your CKEditor 4 installation:

• Installation with npm
• Custom build with online builder
• Download manually from the Add-ons Repository

Refer to the Spreadsheets Integration - Quick Start section for installation steps.

Enable the Spreadsheet Plugin

The setup is straightforward — you just need to enable the plugin and add the license key in your CKEditor 4 configuration:

CKEDITOR.replace( 'editor', {
    extraPlugins: 'spreadsheet',
    spreadsheet_licenseKey: 'yourLicenseKey'
} );

The value of spreadsheet_licenseKey is unique for each website and can be found in the CKEditor Ecosystem customer dashboard. Go to Websites management and press the CKEditor configuration button to obtain it.

This is all. If you are having trouble with setting up the Spreadsheet plugin, please contact us.

Features

• Inserting spreadsheets with and without a header row or column and with any number of rows and columns.
• Inserting spreadsheets using predefined templates.
• Converting existing tables to spreadsheet instances and vice versa.
• Spreadsheet structure manipulation (adding or removing rows and columns).
• Resizing rows and columns.
• Single and multi-column sorting.
• Basic data styling like bold, italic, underline and so on.
• Selecting cell type and formatting with data validation support.
• Using formulas.
• Auto filling rows and columns.
• Applying various conditional formatting rules to single and multiple cells, entire columns or spreadsheets.
• Advanced copying and pasting.

Refer to the Creating Data Grids with Spreadsheet Plugin article for an overview of all available features of the Spreadsheet plugin.

Browser Support

The spreadsheet plugin is fully supported in the latest Chrome, Firefox and Safari browsers.

Support for Internet Explorer 11 is limited: the plugin is usable but there are known, visible issues. Edge browser is not supported at the moment, however, we are looking into providing support for it, too.

If your application requires wider support for Internet Explorer 11 or Edge browsers or you have encountered any issues using these browsers, please contact us.

Demo

See the working "Creating Data Grids with Spreadsheet Plugin" sample that showcases the most important features like data styling, sorting, conditional formatting, formulas and more.

License

CKEditor 4 Spreadsheet plugin (https://ckeditor.com/ckeditor-4/spreadsheets/)
Copyright (c) 2003-2019, CKSource Frederico Knabben. All rights reserved.

CKEditor 4 Spreadsheet plugin is licensed under a commercial license and is protected by copyright law. For more details about available licensing options please contact us at [e-mail].