Inline Table Editing macro
About
Inline Table Editing is a versatile tool that immensely optimizes the work with Confluence tables due to its intuitive handling, enormous time saving and lots of functions.
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.
How to start using "Inline Table Editing" macro
Features
Autosave: Changes will be saved automatically after 60 seconds
Sorting option
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:
=
,>
,>=
,<
,<=
,<>
;
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