Droptables: Manage Tables

1. Manage tables from article or component

When Droptables is installed you have a component entry, menu Components > Droptables and an editor button that is displayed bellow your editor. Click on it to open the main Droptables view.

Table manager interface is opened in a lightbox from the editor:

When you want to insert a table in your editor use the top right button Insert this table to put it in your article. Then, the table will be materialized with a grey area and an Excel like icon.

2. Manage tables and categories

Tables are classified into categories. You can have as much tables as you want inside categories. In order to create a table category, click on New table category on the top center. To create a new table just click on the Create table.

The category can be managed by putting your mouse on it, you’ll be able to edit the name, copy or delete the table. 

In order to create sub-category, you should navigate your cursor to the very left category title, then you can drag'n drop your mouse to the right or left to define the level of that category.

3. Table edition

To add data in tables you have to act like you are in a spreadsheat. Double click on a cell will bring you the possibility to update content, a single click to select one/some cells (and to apply style for example).

To add line or columns, click on the + on the table border:

Or use the right click.

To copy cells you can use CTRL+C / CTRL+V or you can also put your mouse on the bottom right corner of the cell and bring it into the direction you want.

From the right click menu you can undo the latest modifications, all the latest ones since you've reloaded the page. Droptables keeps a backup of the modification you’ve done and is able to restore it.

Cells can also be merged. Select 2 cells or more then do a right click. A menu will allows you to do the merging.

4. Advanced content edition

We’ve recently added a new feature in the edition interface. You can now add HTML content with a WYSIWYG editor inside each cell. Select a cell, on the right part, go to the tab Format > HTML

Now when you edit the cell, you’ll have HTML editor inside. It also include all the editor content button, here I used the image button for example. Editor buttons available are configurable as an option.

5. Excel and spreadsheet import/export

You can import and export spreadsheets in Droptables by using our dedicated tool. It has to be activated from the configuration: Components > Droptables > Options

The tables can be imported from Excel or Open Office. The format will be detected automatically and imported. Note that only the first Excel page will be imported. The export can be done in Excel 2003 or 2007 format.

You can also import or export table data only or table data + styles. The import data only is pretty handy to preserve your layout on import.