View Source

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
When character '=' is entered in a cell, the cell coordinates are shown and the Editor enters the function entering mode. When the entered character '=' is removed, the cell coordinates are removed and the Editor enters the plain text entering mode. Caution) Bringing character = included in a text string does not turn on the function entering mode. For example, even when 123 is removed from string 123=456, the Editor does not enter the function entering mode.
When Enter key is pressed, the entered function is calculated and the corresponding result is displayed in the cell, while the cell is selected.
When the caret leaves a cell deemed as a function, the formula is calculated and the corresponding result is displayed in the cell.
When the caret moves into a calculated cell, the entered function (or formula) is displayed. In that case, the caret always moves to the start of the contents in the cell.
When the caret moves by either tab (Tab) or untab (Shift + Tab), the Editor enter the function entering mode if the arriving cell contains a function and the result of the calculation is displayed again once the caret moves to another cell.
If any object (table, horizontal line, image, video, etc.) other than function (or formula) is included in the cell, the formula is not processed.
If the cell includes any properties other than plain text (tab, line break and hyperlink), the formula is not processed.
If the cell contains bulleted list, numbered list, multilevel list or quotation, the formula is not processed.
Objects (image, video, table, etc.) cannot move into cells processed as functions (or formulas).

Experience

<!-- jQuery -->
<script src="https://code.jquery.com/jquery-3.3.1.js"></script>

<!-- formular parser -->
<script type="text/javascript" src='https://synapeditor.com/se/resource/synapeditor/externals/formulaParser/formula-parser.min.js'></script>

<!-- Synap Editor -->
<script src='https://synapeditor.com/se/resource/synapeditor.config.js'></script>
<script src='https://synapeditor.com/se/resource/synapeditor/synapeditor.min.js'></script>
<link href='https://synapeditor.com/se/resource/synapeditor/synapeditor.min.css' rel='stylesheet' type='text/css'>

<div style="background-color: #ffffff; width:99%; height:500px;">
        <div id="synapEditor">
        <table data-template-id="1" style="width: 540px; height: 270.406px;>
            <colgroup>
                <col style="width: 135px;">
                <col style="width: 135px;">
                <col style="width: 135px;">
                <col style="width: 135px;">
            </colgroup>
            <tbody>
                <tr style="height: 135.203px;">
                    <td style="padding: 5px; border-width: 1px; border-style: solid; border-color: rgb(0, 0, 0);">
                        <p style="margin: 0px;">
                            <span>1</span>
                        </p>
                    </td>
                    <td style="padding: 5px; border-width: 1px; border-style: solid; border-color: rgb(0, 0, 0);">
                        <p style="margin: 0px;">
                            <span>2</span>
                        </p>
                    </td>
                    <td style="padding: 5px; border-width: 1px; border-style: solid; border-color: rgb(0, 0, 0);">
                        <p style="margin: 0px;">
                            <span>3</span>
                        </p>
                    </td>
                    <td data-formula-text="sum(a1:c1)" style="padding: 5px; border-width: 1px; border-style: solid; border-color: rgb(0, 0, 0);">
                        <p style="margin: 0px;">
                            <span>6</span>
                        </p>
                    </td>
                </tr>
                <tr style="height: 135.203px;">
                    <td style="padding: 5px; border-width: 1px; border-style: solid; border-color: rgb(0, 0, 0);">
                        <p style="margin: 0px;">
                            <span>1</span>
                        </p>
                    </td>
                    <td style="padding: 5px; border-width: 1px; border-style: solid; border-color: rgb(0, 0, 0);">
                        <p style="margin: 0px;">
                            <span>2</span>
                        </p>
                    </td>
                    <td style="padding: 5px; border-width: 1px; border-style: solid; border-color: rgb(0, 0, 0);">
                        <p style="margin: 0px;">
                            <span>3</span>
                        </p>
                    </td>
                    <td data-formula-text="max(a2:c2)" style="padding: 5px; border-width: 1px; border-style: solid; border-color: rgb(0, 0, 0);">
                        <p style="margin: 0px;">
                            <span>3</span>
                        </p>
                    </td>
                </tr>
            </tbody>
        </table>
		</div>
</div>
<script>
		const config = Object.assign(synapEditorConfig, {
			"editor.license":"/se/resource/license.json",
			"editor.toolbar": ["new","table"],
			"editor.menu.show": false,
			"editor.import.maxSize": 10485760,
		    "editor.import.api": "/se/importDoc",
		    "editor.upload.maxSize": 3145728,
		    "editor.upload.image.api": "/se/uploadFile",
		    "editor.upload.video.api": "/se/uploadFile",
		    "editor.upload.file.api": "/se/uploadFile"
			});
		window.editor = new SynapEditor("synapEditor", config, document.getElementById('synapEditor').innerHTML);
</script>