...

Inline Table Editing macro is a way to work fast with tables without switching into editing mode at all. Use autofill, inline edit your content, multiple filtering options and formulas to get the most out of your Confluence tables.

In the current release, only plain text input is supported.

How to start using "Inline Table Editing" macro

Features

• Autosave: Changes will be saved automatically after 60 seconds

• Advanced filtering options

• Sorting option

• Autofill options for cells and ranges

• Reorder rows and columns with drag and drop

• Macro supportoverview

• Choose cell colors

• Import from an existing CSV file

• Clipboard, Copy & Cut allows you to easily copy, cut and paste data from and into your table

• High-speed formula calculations. Function syntax compatible with Excel and Google Sheets

  • Basic formulas and calculations

    • Any numbers, negative and positive as float or integer;

    • Arithmetic operations such as: +, -, /, *, %, ^;

    • String operations such as: & (concatenation eq. =-(2&5) will return -25);

    • Relative and absolute cell references such as: A1, $A1, A$1, $A$1;

    • Comparison operations such as: =, >, >=, <, <=, <>;

  • Built-in Functions

    • Logical operations such as: AND(), OR(), NOT(), XOR();

    • All JavaScript Math constants such as: PI(), E(), LN10(), LN2(), LOG10E(), LOG2E(), SQRT1_2(), SQRT2();

    • Error handling: #DIV/0!, #ERROR!, #VALUE!, #REF!, #NAME?, #N/A, #NUM!;

    • Build-in variables such as: TRUE, FALSE, NULL;

...