Page History

...

For the list of available functions, please refer to "Supported Functions" page.

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.

Image Removed

Description	Example	Image Removed
When Enter key is pressed, the entered function is calculated and the corresponding result is displayed in the cell, while the cell is selected.	Image Removed
When the caret leaves a cell deemed as a function, the formula is calculated and the corresponding result is displayed in the cell.	Image Removed
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.	Image Removed
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.	Image Removed
If any object (table, horizontal line, image, video, etc.) other than function (or formula) is included in the cell, the formula is not processed.	Image Removed
If the cell includes any properties other than plain text (tab, line break and hyperlink), the formula is not processed.	Image Removed
If the cell contains bulleted list, numbered list, multilevel list or quotation, the formula is not processed.	Image Removed
Objects (image, video, table, etc.) cannot move into cells processed as functions (or formulas).	작성 방법 셀에 '=' 문자 입력시 셀 좌표 노출되며 함수 입력 모드로 변경됩니다. '=' 문자 제거시 셀 좌표 제거 되면서 일반 텍스트 입력상태로 변경됩니다. 작성 완료 방법 Enter 키 동작시 입력된 함수 계산되어 그 결과가 표시되며, 셀 셀렉션으로 변경됩니다. 함수로 판단되는 셀에서 캐럿 빠져나가면 수식 계산되어 그 결과가 표시됩니다. 작성된 엑셀함수 수정 방법 수식 계산된 셀로 캐럿 이동하면, 입력된 함수(또는 계산식)이 표시됩니다. 이 때 캐럿은 항상 셀의 제일 앞으로 이동합니다. 주의) 문자열에 포함된 = 문자가 맨 앞으로 온다고해서 함수 입력 모드로 바뀌지는 않습니다. 예를 들어 123=456 에서 123 을 제거한다고해도 함수 입력 모드로 되지 않습니다.	Image Added
계산되지 않는 조건 함수(또는 계산식)을 제외한 다른 객체(표, 가로줄, 이미지, 비디오 등)가 셀에 포함된다면 계산식이 처리되지 않습니다. 일반 텍스트를 제외한 속성(탭, 줄나눔, 하이퍼링크)이 포함된다면 계산식이 처리되지 않습니다. 글머리기호, 인용기호 포함되면 계산식이 처리되지 않습니다. 함수(또는 계산식)로 처리된 셀로는 객체(이미지, 비디오, 표 등)를 이동 할 수 없습니다.	Image Added

Experiencing

HTML

<!-- external modules -->
<script type="text/javascript" src='https://www.synapeditor.com/se/resource/synapeditor/externals/formulaParser/formula-parser.min.js'></script>
<script type="text/javascript" src='https://www.synapeditor.com/se/resource/synapeditor/externals/SEDocModelParser/SEDocModelParser.min.js'></script>
<script type="text/javascript" src='https://www.synapeditor.com/se/resource/synapeditor/externals/SEShapeManager/SEShapeManager.min.js'></script>
<script type="text/javascript" src='https://www.synapeditor.com/se/resource/synapeditor/externals/codeMirror/codemirror.min.js'></script>
<script type="text/javascript" src="https://www.synapeditor.com/se/resource/synapeditor/externals/codeMirror/xml.min.js"></script>
<link rel='stylesheet' href='https://www.synapeditor.com/se/resource/synapeditor/externals/codeMirror/codemirror.min.css'>

<!-- Synap Editor -->
<script src='https://www.synapeditor.com/se/resource/synapeditor/synapeditor.config_en.js'></script>
<script src='https://www.synapeditor.com/se/resource/synapeditor/synapeditor.min.js'></script>
<link href='https://www.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>

...

Page tree

Versions Compared

Old Version 4

New Version 5

Key

Experiencing