Page History

...

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

Description

Example

작성 방법
- 셀에 '=' 문자 입력시 셀 좌표 노출되며 함수 입력 모드로 변경됩니다.
- '=' 문자 제거시 셀 좌표 제거 되면서 일반 텍스트 입력상태로 변경됩니다.
작성 완료 방법
- Enter 키 동작시 입력된 함수 계산되어 그 결과가 표시되며, 셀 셀렉션으로 변경됩니다.
- 함수로 판단되는 셀에서 캐럿 빠져나가면 수식 계산되어 그 결과가 표시됩니다.
작성된 엑셀함수 수정 방법
- 수식 계산된 셀로 캐럿 이동하면, 입력된 함수(또는 계산식)이 표시됩니다.
- 이 때 캐럿은 항상 셀의 제일 앞으로 이동합니다.

주의)
문자열에 포함된 = 문자가 맨 앞으로 온다고해서 함수 입력 모드로 바뀌지는 않습니다.
예를 들어 123=456 에서 123 을 제거한다고해도 함수 입력 모드로 되지 않습니다.

Image Removed

계산되지 않는 조건
함수(또는 계산식)을 제외한 다른 객체(표, 가로줄, 이미지, 비디오 등)가 셀에 포함된다면 계산식이 처리되지 않습니다.
일반 텍스트를 제외한 속성(탭, 줄나눔, 하이퍼링크)이 포함된다면 계산식이 처리되지 않습니다.
글머리기호, 인용기호 포함되면 계산식이 처리되지 않습니다.

함수(또는 계산식)로 처리된 셀로는 객체(이미지, 비디오, 표 등)를 이동 할 수 없습니다

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.

Image Added

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).

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;">' type='text/css'>

<div style="background-color: #ffffff; width:99%; height:500px;">
    <div id="synapEditor">
    <table style="vertical-align: text-bottom; border-collapse: collapse; line-height: normal; width: calc(100% - 0px); word-break: break-all;" data-template-id="13">
        <colgroup>
            <col style="width: 34.770114942528735%;">
            <col style="width: 21.743295019157088%;">
            <col style="width: 21.743295019157088%;">
            <col style="width: 21.743295019157088%;">
        </colgroup>
        <tbody>
            <tr>
                <th style="background-color: rgb(169, 169, 169); text-align: center; padding: 5px; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1px; word-break: break-word;" scope="col">
                    <p style="margin: 0px; display: block; overflow-wrap: break-word;"><span>Item</span></p>
                </th>
                <th style="background-color: rgb(169, 169, 169); text-align: center; padding: 5px; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1px; word-break: break-word;" scope="col">
                    <p style="margin: 0px; display: block; overflow-wrap: break-word;"><span>Quantitiy</span></p>
                </th>
                <th style="background-color: rgb(169, 169, 169); text-align: center; padding: 5px; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1px; word-break: break-word;" scope="col">
                    <p style="margin: 0px; display: block; overflow-wrap: break-word;"><span>Price</span></p>
                </th>
                <th style="background-color: rgb(169, 169, 169); text-align: center; padding: 5px; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1px; word-break: break-word;" scope="col">
                    <p style="margin: 0px; display: block; overflow-wrap: break-word;"><span>Total</span></p>
                </th>
            </tr>
            <tr>
                <td style="text-align: center; padding: 5px; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1px; word-break: break-word;">
                    <p style="margin: 0px; display: block; overflow-wrap: break-word;"><span>pencil</span></p>
                </td>
                <td style="text-align: right; padding: 5px; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1px; word-break: break-word;">
                    <p style="margin: 0px; display: block; overflow-wrap: break-word;"><span>3</span></p>
                </td>
                <td style="text-align: right; padding: 5px; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1px; word-break: break-word;">
                    <p style="margin: 0px; display: block; overflow-wrap: break-word;"><span>100</span></p>
                </td>
                <td style="text-align: right; padding: 5px; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1px; word-break: break-word;"
                    data-formula-text="product(B2,C2)">
                    <p style="text-align: right; margin: 0px; display: block; overflow-wrap: break-word;">
                        <span>300</span></p>
                </td>
            </tr>
            <tr>
                <td style="text-align: center; padding: 5px; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1px; word-break: break-word;">
                    <p style="margin: 0px; display: block; overflow-wrap: break-word;"><span>paper</span></p>
                </td>
                <td style="text-align: right; padding: 5px; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1px; word-break: break-word;">
                    <p style="margin: 0px; display: block; overflow-wrap: break-word;"><span>5</span></p>
                </td>
                <td style="text-align: right; padding: 5px; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1px; word-break: break-word;">
                    <p style="margin: 0px; display: block; overflow-wrap: break-word;"><span>180</span></p>
                </td>
                <div<td idstyle="synapEditor">
        <table data-template-id="1" style="width: 540px; height: 270.406px;text-align: left; padding: 5px; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1px; word-break: break-word;" data-formula-text="product(B3,C3)">
            <colgroup>        <p style="text-align: right; margin: 0px; display:    <col style="width: 135pxblock; overflow-wrap: break-word;">
 
              <col style="width: 135px;">        <span>900</span></p>
        <col style="width: 135px;">      </td>
          <col style="width: 135px;"> </tr>
            </colgroup><tr>
            <tbody>    <td style="text-align: center; padding: 5px; border-color: rgb(0, 0, 0); border-style: solid; border-width:  <tr style="height: 135.203px1px; word-break: break-word;">
                    <td<p style="paddingmargin: 5px0px; border-widthdisplay: 1pxblock; borderoverflow-stylewrap: solid; border-color: rgb(0, 0, 0);">break-word;"><span>eraser</span></p>
                </td>
       <p style="margin: 0px;">       <td style="text-align: right; padding: 5px; border-color: rgb(0, 0, 0); border-style: solid; border-width:        1px; word-break: break-word;">
  <span>1</span>                  <p style="margin: 0px; display: block;   </p>
   overflow-wrap: break-word;"><span>5</span></p>
                </td>
   
                <td style="text-align: right; padding: 5px; border-width: 1pxcolor: rgb(0, 0, 0); border-style: solid; border-colorwidth: rgb(0, 0, 0)1px; word-break: break-word;">
   
                    <p style="margin: 0px;"> display: block;                    overflow-wrap: break-word;"><span>50</span></p>
      <span>2</span>          </td>
              </p>  <td style="text-align: left; padding: 5px; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1px; word-break:      </td>break-word;" data-formula-text="product(B4,C4)">
                      <td<p style="paddingtext-align: 5pxright; border-widthmargin: 1px0px; border-styledisplay: solidblock; borderoverflow-colorwrap: rgb(0, 0, 0)break-word;">
    
                   <p style="margin: 0px;">
     <span>250</span></p>
                </td>
         <span>3</span>   </tr>
            <tr>
        </p>        <td style="text-align: center; padding: 5px; border-color: rgb(0, 0, 0); border-style: solid; border-width:  </td>
1px; word-break: break-word;">
                   <td data-formula-text="sum(a1:c1)" <p style="paddingmargin: 5px0px; border-widthdisplay: 1pxblock; borderoverflow-stylewrap: solid; border-color: rgb(0, 0, 0);">
 break-word;"><span>note</span></p>
                </td>
     <p style="margin: 0px;">         <td style="text-align: right; padding: 5px; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1px;    word-break: break-word;">
   <span>6</span>                 <p style="margin: 0px; display: block;    </p>
   overflow-wrap: break-word;"><span>15</span></p>
                </td>
                </tr>
                <tr style="height: 135.203px<td style="text-align: right; padding: 5px; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1px; word-break: break-word;">
                    <td<p style="paddingmargin: 5px0px; border-widthdisplay: 1pxblock; border-style: solid; border-color: rgb(0, 0, 0);">overflow-wrap: break-word;"><span>200</span></p>
                </td>
       <p style="margin: 0px;">       <td style="text-align: left; padding: 5px; border-color: rgb(0, 0, 0); border-style:        solid; border-width: 1px; word-break: break-word;" data-formula-text="product(B5,C5)">
    <span>1</span>                <p style="text-align: right; margin: 0px; display: block;   </p>overflow-wrap: break-word;">
                    </td>    <span>3000</span></p>
                <td style="padding: 5px; border-width: 1px; border-style: solid; border-color: rgb(0, 0, 0);">
  </td>
            </tr>
            <tr>
        <p style="margin: 0px;">      <td style="text-align: center; padding: 5px; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1px; word-break: break-word;">
        <span>2</span>            <p style="margin: 0px; display:          </p>
   block; overflow-wrap: break-word;"><span style="font-weight: bold;">total</span></p>
                </td>
   
                <td style="text-align: right; padding: 5px; border-width: 1pxcolor: rgb(0, 0, 0); border-style: solid; border-colorwidth: rgb(0, 0, 0)1px; word-break: break-word;">
   
                    <p style="text-align: center; margin: 0px; display: block; overflow-wrap: break-word;">
                        <span>-</span></p>
                <span>3</span></td>
                <td style="text-align: right; padding: 5px; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1px; word-break:  </p>break-word;">
                     </td>
        <p style="text-align: center; margin: 0px; display: block; overflow-wrap: break-word;">
           <td data-formula-text="max(a2:c2)" style="padding: 5px; border-width: 1px; border-style: solid; border-color: rgb(0, 0, 0);">  <span>-</span></p>
                </td>
     <p style="margin: 0px;">         <td style="text-align: left; padding: 5px; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1px; word-break: break-word;">
     <span>3</span>               <p style="text-align: right; margin: 0px; display: block;    </p>
   overflow-wrap: break-word;"><br></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 5

New Version Current

Key

Experiencing