====== EditTable Plugin ======

---- plugin ----
description: Provides a visual table editing and inserting interface
author     : Andreas Gohr
email      : dokuwiki@cosmocode.de
type       : action
lastupdate : 2023-01-14
compatible : !Frusterick Manners, !Greebo, Hogfather, Igor, Jack Jackrum, Kaos
depends    : 
conflicts  : fontsize2, typography, searchtablejs, bootswrapper
similar    : dtable
tags       : wysiwyg, tables, editing
downloadurl: https://github.com/cosmocode/edittable/archive/master.zip
bugtracker : https://github.com/cosmocode/edittable/issues
sourcerepo : https://github.com/cosmocode/edittable/
donationurl: 

screenshot_img: plugin:edittable7.png
----

[[https://travis-ci.org/cosmocode/edittable|{{ https://travis-ci.org/cosmocode/edittable.png?branch=master&nocache}}]]

This plugin adds an additional edit button to every table. Using this button the table can be edited in an Excel-like visual interface. The plugin also adds a button to the standard toolbar for inserting new tables using this editor.

This plugin was originally developed by Adrian Lang. The plugin has been mostly rewritten and is now based on the [[http://handsontable.com/|Handsontable jQuery plugin]] which is included and does not need to be downloaded separately.

===== Installation =====

[[https://www.cosmocode.de/en/open-source/dokuwiki-plugins/|{{ https://www.cosmocode.de/static/img/dokuwiki/dwplugins.png?recache|A CosmoCode Plugin}}]]

Search and install the plugin using the [[plugin:extension|Extension Manager]]. Refer to [[:Plugins]] on how to install plugins manually.

:!: When **upgrading** from a version prior to 2014 you need to uninstall and reinstall the plugin. Otherwise old files may prevent the proper working of the plugin. Make sure you do **not** have an ''action.php'' on the tableedit directory lingering on.

==== Compatiblity ====

Not compatible with IE8.

===== Usage =====

{{ :plugin:edittable1.png?nolink|Table Edit button}} After installing the plugin all tables will have their own edit button. This will open the table in the editTable plugin.

When editing a text in the normal editor, a new table can be inserted using the {{:plugin:add_table.png?nolink|Add Table}} button.

==== Editing ====

Select a cell by tab key, cursor keys or mouse click. To **overwrite** cell contents just start to type, to **change** cell contents press enter or double click a cell. To confirm an edit press enter or move to another cell.

Inside a cell, all wiki syntax allowed for tables can be used as usual. 
{{ :plugin:edittable4.png?nolink |Editing}}

==== Manipulating Cells ====

{{:plugin:edittable8.png?nolink |Context Menu}}

All cell manipulation is done via a right-click context menu. To do so select a single cell or select multiple cells by dragging. The context menu allows you to change the alignment and header state of cells, adding and removing columns and rows and gives a way to make cells span over multiple rows or columns.

Dragging the small square at the bottom right of a selected cell will fill the same content to the cells selected by dragging. Please note that auto-continuing rows (eg. counting onward) like in Excel is not supported currently.

==== Move ====

Rows and Columns can be rearranged by moving them. Contents will be moved accordingly. Please note that rows or columns can not be moved out or into column or row spans respectively.

{{:plugin:edittable2.png?nolink |Moving a row}} {{ :plugin:edittable3.png?nolink|Moving a column}}

To move a row, grab the handle at the top of its header cell, then move it to where you want it to go.

For moving columns grab the handle at the left of its header cell.

==== Resize ====

{{:plugin:edittable5.png?nolink |Resizing columns}} For editing purposes columns can be manually resized by dragging the handle on the right of their header cell. Note that this is not saved by DokuWiki (since DokuWiki has no width or other properties for tables) but might be a good help when editing big tables with many columns that might fit on a screen page with less scrolling by resizing column width.

===== Development =====

The source code of the plugin is available at github: [[https://github.com/cosmocode/edittable|cosmocode/edittable]].

==== Changes ====

{{rss>https://github.com/cosmocode/edittable/commits/master.atom date}}

**Releases:**
{{rss>https://github.com/cosmocode/edittable/releases.atom description author}}

==== Bug reports and feature requests ====

Please refer to the [[https://github.com/cosmocode/edittable/issues|issue tracker]] for reporting issues.