UX to use excel functions has been partially changed since version 2.4.0. As for using excel functions in version 2.3.0, please refer to "Using Excel Function (2.3.0)" page.
For the list of available functions, please refer to "Supported Functions" page.
Description
Example
How to write
When entering the '=' character in a cell, the cell coordinates will be exposed and the status will be changed to the function input mode.
When the '=' character is removed, the cell coordinates will be removed and the status will be changed to normal text input.
How to complete
When the Enter key is operated, the entered function will be calculated and the result will be displayed, and it will be changed to a cell selection.
When the caret gets out of the cell judged to be a function, the formula will be calculated and the results will be displayed.
How to edit the written Excel functions
When the caret is moved to the cell where the formula is calculated, the entered function (or formula) will be displayed.
At this time, the caret always moves to the very front of the cell.
Note: Even if the = character included in the string comes first, the status does not change to the function input mode. For example, removing 123 from 123=456 does change the status to the function input mode.
Conditions not calculated
If a cell contains objects (tables, horizontal lines, images, videos, etc.) other than functions (or formulas), the formulas are not processed.
If properties other than normal text (tabs, line breaks, hyperlinks) are included, the formulas are not processed.
If bullets and quotation marks are included, the formulas are not processed.
Objects (images, videos, tables, etc.) cannot be moved to the cells processed with functions (or formulas).
