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.

 

droptables-editor

 

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

 

droptables-lightbox-open

 

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.

 

table-in-editor

 

If you click on the area then on the Droptables button again the table previously added will be loaded.

 

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.

 

table-categories

 

Note: a default category and table is already created during component install. You can move tables and tables categories using drag'n drop.

 

table-move

 

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

 

table-name

 

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.

 

category-move

 

Note: the maximum level of sub-categories is four.

 

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).

 

edit-cell

 

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

 

add-line-table

 

Or use the right click.

 

right-clic-add

 

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.

 

copy-cell

 

Note: all modifications are instant saved automatically with a message on the top right. You have an option to disable this feature from the Droptables > Options

 

save-table

 

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.

 

undo-action

 

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

 

html-cell

 

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.

 

editor-button

 

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

 

excel-import

 

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.

 

Excel--sheet-import-export

 

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.