...

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

...