Page History

...

사용가능한 함수목록은 "지원함수" 페이지를 참고하세요.

Image Removed

설명

참고

작성 방법
- 셀에 '=' 문자 입력시 셀 좌표 노출되며 함수 입력 모드로 변경됩니다.
- '=' 문자 제거시 셀 좌표 제거 되면서 일반 텍스트 입력상태로 변경됩니다.

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

Image Removed

작성 완료 방법
- Enter 키 동작시 입력된 함수 계산되어 그 결과가 표시되며, 셀 셀렉션으로 변경됩니다.

Image Removed

- 함수로 판단되는 셀에서 캐럿 빠져나가면 수식 계산되어 그 결과가 표시됩니다.

작성된 엑셀함수 수정 방법
- 수식 계산된 셀로 캐럿 이동하면, 입력된 함수(또는 계산식)이 표시됩니다.
- 이 때 캐럿은 항상 셀의 제일 앞으로 이동합니다.

Image Removed

탭(Tab), 언탭(Shift + Tab) 이동시 함수가 입력된 셀의 경우 합수입력모드로 변경되고 다른 셀로 하면 다시 계산결과가 표시됩니다.

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

Image Added

계산되지 않는 조건
- 함수(또는 계산식)을 제외한 다른 객체(표, 가로줄, 이미지, 비디오 등)가 셀에 포함된다면 계산식이 처리되지 않습니다.

Image Removed

- 일반 텍스트를 제외한 속성(탭, 줄나눔, 하이퍼링크)이 포함된다면 계산식이 처리되지 않습니다.

Image Removed

- 글머리기호, 인용기호 포함되면 계산식이 처리되지 않습니다.

Image Removed

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

Image Removed

...

Image Added

HTML

<!-- external jQuerymodules -->
<script srctype="text/javascript" src='https://codewww.jquerysynapeditor.com/jquery-3.3.1.js"/se/resource/synapeditor/externals/formulaParser/formula-parser.min.js'></script>

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

<!-- Synap Editor -->
<script<script type="text/javascript" src='httphttps://www.synapeditor.com/se/resource/synapeditor.config/externals/SEShapeManager/SEShapeManager.min.js'></script>
<script type="text/javascript" src='httphttps://www.synapeditor.com/se/resource/synapeditor/externals/codeMirror/synapeditorcodemirror.min.js'></script>
<link href='http
<script type="text/javascript" src="https://www.synapeditor.com/se/resource/synapeditor/synapeditorexternals/codeMirror/xml.min.css'js"></script>
<link rel='stylesheet' typehref='text/https://www.synapeditor.com/se/resource/synapeditor/externals/codeMirror/codemirror.min.css'>

<div style="background-color: #ffffff; width:99%; height:500px;">
        <div id="synapEditor"><!-- Synap Editor -->
<script src='https://www.synapeditor.com/se/resource/synapeditor/synapeditor.config.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 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>
             <table data-template-id="1" style="width: 540px; height: 270.406px;> </td>
              <colgroup>  <td style="text-align: left; padding: 5px; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1px; word-break:  <col style="width: 135px;">break-word;" data-formula-text="product(B3,C3)">
                    <col<p style="width: 135pxtext-align: right; margin: 0px; display: block; overflow-wrap: break-word;">
                <col  style="width: 135px;">     <span>900</span></p>
           <col style="width: 135px;">     </td>
            </colgroup>tr>
            <tbody><tr>
                <tr<td style="height: 135.203pxtext-align: center; 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; 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:       </p>
   block; overflow-wrap: break-word;"><span>5</span></p>
                </td>
   
                <td style="text-align: right; padding: 5px; border-widthcolor: 1pxrgb(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>
                </td>
                <td style="text-align: left; padding: 5px; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1px;  <span>2</span>
word-break: break-word;" data-formula-text="product(B4,C4)">
                    <p style="text-align:  </p>
    right; margin: 0px; display: block; overflow-wrap: break-word;">
               </td>         <span>250</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>3</span>                  <p style="margin: 0px; display: block;   <overflow-wrap: break-word;"><span>note</span></p>
 
                  </td>
   
                <td data-formula-text="sum(a1:c1)" style="padding: 5px; border-widthtext-align: 1pxright; border-stylepadding: solid5px; 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>15</span></p>
                </td>
            <span>6</span>    <td style="text-align: right; padding: 5px; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1px; word-break: break-word;">
      </p>              <p style="margin: 0px; display: block;   </td>overflow-wrap: break-word;"><span>200</span></p>
                </tr>td>
                <tr<td style="heighttext-align: 135.203pxleft;"> padding: 5px; border-color: rgb(0,                 <td style="padding: 5px0, 0); border-style: solid; border-width: 1px; borderword-stylebreak: solidbreak-word;" border-color: rgb(0, 0, 0);data-formula-text="product(B5,C5)">
                    <p style="text-align: right;  <p style="margin: 0pxmargin: 0px; display: block; overflow-wrap: break-word;">
                            <span>1</span>
       <span>3000</span></p>
                </p>td>
            </tr>
        </td>    <tr>
                <td style="text-align: center; padding: 5px; border-widthcolor: 1pxrgb(0, 0, 0); border-style: solid; border-width: 1px; borderword-colorbreak: rgb(0, 0, 0)break-word;">
   
                    <p style="margin: 0px;"> display: block; overflow-wrap:                      break-word;"><span style="font-weight: bold;">total</span></p>
   <span>2</span>             </td>
           </p>     <td style="text-align: right; padding: 5px; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1px;    </td>word-break: break-word;">
                     <td<p style="paddingtext-align: 5pxcenter; border-widthmargin: 1px0px; border-styledisplay: solidblock; borderoverflow-colorwrap: rgb(0, 0, 0)break-word;">
 
                      <p style="margin: 0px;">      <span>-</span></p>
                </td>
     <span>3</span>           <td style="text-align: right; padding: 5px; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1px;  </p>word-break: 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>
		window.editorconst config = new SynapEditor("synapEditor"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>

...

Space shortcuts

Page tree

Versions Compared

Old Version 14

New Version Current

Key