| Status | ||||||
|---|---|---|---|---|---|---|
|
엑셀함수 사용을 위한 UX가 2.4.0 버전부터 일부 변경되었습니다. 2.3.0 버전의 엑셀함수 사용은 "엑셀함수사용(2.3.0)"페이지를 참고해주세요.엑셀함수를 사용하여 간단한 계산을 적용할 수 있습니다.
사용가능한 함수목록은 "지원함수" 페이지를 참고하세요.
| 설명 | 참고 |
|---|---|
주의) |
|
|
|
- 셀에 '=' 문자 입력시 셀 좌표 노출되며 함수 입력 모드로 변경됩니다.
- '=' 문자 제거시 셀 좌표 제거 되면서 일반 텍스트 입력상태로 변경됩니다.
주의)
문자열에 포함된 = 문자가 맨 앞으로 온다고해서 함수 입력 모드로 바뀌지는 않습니다.
예를 들어 123=456 에서 123 을 제거한다고해도 함수 입력 모드로 되지 않습니다.
- Enter 키 동작시 입력된 함수 계산되어 그 결과가 표시되며, 셀 셀렉션으로 변경됩니다.
- 함수로 판단되는 셀에서 캐럿 빠져나가면 수식 계산되어 그 결과가 표시됩니다.
- 수식 계산된 셀로 캐럿 이동하면, 입력된 함수(또는 계산식)이 표시됩니다.
- 이 때 캐럿은 항상 셀의 제일 앞으로 이동합니다.
- 탭(Tab), 언탭(Shift + Tab) 이동시 함수가 입력된 셀의 경우 합수입력모드로 변경되고 다른 셀로 하면 다시 계산결과가 표시됩니다.
- 함수(또는 계산식)을 제외한 다른 객체(표, 가로줄, 이미지, 비디오 등)가 셀에 포함된다면 계산식이 처리되지 않습니다.
- 일반 텍스트를 제외한 속성(탭, 줄나눔, 하이퍼링크)이 포함된다면 계산식이 처리되지 않습니다.
- 글머리기호, 인용기호 포함되면 계산식이 처리되지 않습니다.
- 함수(또는 계산식)로 처리된 셀로는 객체(이미지, 비디오, 표 등)를 이동 할 수 없습니다.
...
| 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.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>
</td>
<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(B3,C3)">
<p style="text-align: right; margin: 0px; display: block; overflow-wrap: break-word;">
<span>900</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>eraser</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>50</span></p>
</td>
<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(B4,C4)">
<p style="text-align: right; margin: 0px; display: block; overflow-wrap: break-word;">
<span>250</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>note</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>15</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>200</span></p>
</td>
<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)">
<p style="text-align: right; margin: 0px; display: block; overflow-wrap: break-word;">
<span>3000</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 style="font-weight: bold;">total</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="text-align: center; margin: 0px; display: block; overflow-wrap: break-word;">
<span>-</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="text-align: center; margin: 0px; display: block; overflow-wrap: break-word;">
<span>-</span></p>
</td>
<td style="text-align: left; padding: 5px; border-color: rgb(0, 0, 0); border-style: solid; border-width: 1px; word-break: break-word;">
<p style="text-align: right; margin: 0px; display: block; 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> |
...