Creating data grids in WYSIWYG editor - CKEditor 4 Spreadsheets released
We are happy to announce the release of CKEditor 4 Spreadsheets that offer Excel-like functionality right inside the WYSIWYG editor. The new Spreadsheet plugin allows you to create intelligent, data-driven documents directly in CKEditor 4. This makes it a perfect solution for financial, auditing, engineering, technical and science industries.
# Spreadsheets vs tables
CKEditor 4 has long been a tool of choice for creating data-driven rich-text documents thanks to features such as best-in-class table support or advanced Paste from Excel. Knowing the limitations of classic HTML tables and web browsers, over the years we introduced features such as column resize with your mouse or custom table selection that allows you to select an arbitrary table fragment.
However, even with all the improvements, HTML tables fall short when it comes to working with dynamic data and smart documents. Sorting and filtering data, setting fixed data types with validation, using formulas and conditional formatting are all handy features that are well-known from Microsoft Excel or Google Sheets but have not been available in WYSIWYG editors. Until now!
# Spreadsheets for smart documents
With Spreadsheets, we can finally capture data and rich-text content in one living document. This is a breakthrough moment that can drive innovation in various business fields such as corporate budgeting, strategic planning, and financial reporting. It literally changes the way people think about their documents.Chris Spilka, CEO, Handsontable
Thanks to the integration that combines the data and rich-text content in one place you can maximize the effectiveness of your team and improve your corporate document workflow. What’s more, the cool thing about the integration is that with one click you can switch between a native HTML table and a spreadsheet widget, preserving all data.
# Your data stays with you
While spreadsheet solutions are sometimes available in the cloud, in some scenarios it is not possible to use them due to privacy and data security concerns as well as regulatory limitations. CKEditor 4 Spreadsheets allows you to easily integrate the Spreadsheet plugin with your CKEditor 4.13+ instance, install it on your own server and have full control over the data. It’s like having your private Word and Excel or Google Docs and Sheets combined, inside your own application, on your own terms!
# Spreadsheets features
Here is an overview of the features that are provided by CKEditor 4 Spreadsheets to make working with data-rich documents easy for you:
- 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.
Check the Creating Data Grids with Spreadsheet Plugin article for an overview of all available features of the Spreadsheet plugin.
# Try out Spreadsheets!
See for yourself — try out the possibilities of the new Spreadsheet plugin on the demo page.
If you would like to have a deeper look and integrate Spreadsheets with your application that uses CKEditor 4, you can sign up for a 30-days commitment-free trial.
# Installing Spreadsheets
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.
- Manual download from the Add-ons Repository.
See the Spreadsheets Integration guide for detailed installation steps.
CKEditor 4 Spreadsheets is a commercial solution. We will be happy to discuss your use case and propose a tailor-made offer. Contact us for more details!
# Feedback needed!
We are very excited about the possibilities that the new Spreadsheets integration can bring to CKEditor 4. We will be thankful for any suggestions, ideas, and comments that you can send us. Use the official CKEditor 4 GitHub repository to request features and report issues.