Overview

Inline table editing is a versatile tool that significantly streamlines working with Confluence tables. It has an intuitive interface, helps to reduce time on work with tables.

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.

Explore how to add and use macro:

https://actonic.atlassian.net/wiki/spaces/ITE/pages/6137053288

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 overview

• 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;

Read next