Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Reverted from v. 19

Status
colourYellow
title릴리즈 2.3.0 이상


엑셀과 같은 방식으로 셀 안쪽 내용의 표시형식을 지정 할 수 있습니다.

툴바에 "numberFormat" 을 추가해 드롭다운으로도 사용할 수 있습니다.

Code Block
languagejs
themeEmacs
"editor.toolbar": ["table", "numberFormat"]


체험하기

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

<!-- code mirror -->
<script type="text/javascript" src='httphttps://www.synapeditor.com/se/resource/synapeditor/externals/codemirrorSEDocModelParser/codemirrorSEDocModelParser.min.js'></script>
<script type="text/javascript" src="http'https://www.synapeditor.com/se/resource/synapeditor/externals/codemirrorSEShapeManager/xmlSEShapeManager.min.js"'></script>
<link<script rel='stylesheet' href='httptype="text/javascript" src='https://www.synapeditor.com/se/resource/synapeditor/externals/codemirrorcodeMirror/codemirror.min.css'>

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

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


<!-- tui Image Editor -->
<script type="text/javascript" src='http://www.synapeditor.com/resource/synapeditor/plugins/tuiImageEditor/tuiImageEditor.min.js'></script>
<link rel='stylesheet' href='http://www.synapeditor.com/resource/synapeditor/plugins/tuiImageEditor/tuiImageEditor.min.css'>


<!-- formula-parser -->
<script type="text/javascript" src='http://www.synapeditor.com/resource/synapeditor/2.3.0/formula-parser.min.js'></script>

<div style="background-color: #ffffff; width:99%; height:500px;"><div style="background-color: #ffffff; width:99%; height:500px;">
    <div id="synapEditor">
    <table style="border-collapse: collapse; vertical-align: text-bottom; line-height: normal; width: calc(100% - 0px); word-break: break-all;"
        data-template-id="13">
        <colgroup>
  <div id="synapEditor">
			<table data-drawing-object-id="se_28d15618-5be8-4779-b5ab-d199bf82e64c" data-template-id="1" data-paragraph-id="se_5263e375-dbd8-4f08-a72f-a6a5c4332ea9" style="border-collapse: collapse; word-break: break-all; line-height: normal; width: 540px; height: 270.406px; vertical-align: text-bottom;" class="">
		<colgroup>
			          <col style="width: 34.77009999999999%;">
            <col style="width: 21.743299999999998%;">
            <col style="width: 135px21.743299999999998%;">
			<col style="width: 135px;">
			
            <col style="width: 135px21.743299999999998%;">
			<col style="width: 135px;">
		
        </colgroup>
 		<tbody> 			<tr style="height: 135.203px;"> 				<td data-table-row-index="0" data-table-col-index="0" data-index-label="A1" style="padding: 5px; word-break: break-word; border-width: 1px; border-style: solid; border   <tbody>
            <tr>
                <th style="background-color: rgb(0169, 0169, 0169);">
					<p style="overflow-wrap: break-word; margin: 0px;">
						<span>1200</span>
					</p>
				</td>
				<td data-table-row-index="0" data-table-col-index="1" data-index-label="B1" style="padding: 5px; word-break: break-word; border-width: 1px; border-style: solid; border-color: rgb(0, 0, 0);">
					<p style="overflow-wrap: break-word; margin: 0px;">
						<span>2500</span>
					</p>
				</td>
				<td data-table-row-index="0" data-table-col-index="2" data-index-label="C1" style="padding: 5px 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>1000</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>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>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>1800</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>9000</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>500</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>2500</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>2000</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>30000</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; border-width: 1px; border-style: solid; border-color: rgb(0, 0, 0);">
					<p style="">
                    <p style="margin: 0px; display: block; overflow-wrap: break-word; margin"><span style="font-weight: 0pxbold;">
						<span>3200</span>
					</p>
				</td>
				<td data-table-row-index="0" data-table-col-index="3" data-formula-text="sum(a1:c1)" data-index-label="D1" style="padding: 5px; word-break>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; border-width: 1px; border-style: solid; border-color: rgb(0, 0, 0);">
					<p style="overflow-wrap: break-word; margin: 0px;">
						<span>640</span>
					</p>
				</td>
			</tr>
			<tr style="height: 135.203px;">
				<td data-table-row-index="1" data-table-col-index="0" data-index-label="A2" style="padding: 5px; word-break: break-word; border-width: 1px; border-style: solid">
                        <span>-</span></p>
                </td>
                <td style="text-align: right; padding: 5px; border-color: rgb(0, 0, 0);">
					<p style="overflow-wrap: break-word; margin: 0px;">
						<span>124200</span>
					</p>
				</td>
				<td data-table-row-index="1" data-table-col-index="1" data-index-label="B2" style="padding: 5px; word-break: break-word; border-width: 1px; border-style: solid; border-color: rgb(0, 0, 0);">
					<p style="overflow-wrap: break-word; margin: 0px;">
						<span>23120</span>
					</p>
				</td>
				<td data-table-row-index="1" data-table-col-index="2" data-index-label="C2" style="padding: 5px; word-break: break-word; border-width: 1px; border-style: solid; 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);">
					<p style="overflow-wrap: break-word; margin: 0px;">
						<span>3900</span>
					</p>
				</td>
				<td data-table-row-index="1" data-table-col-index="3" border-style: solid; border-width: 1px; word-break: break-word;" data-formula-text="maxSUM(a2:c2)" data-index-label="D2" style="padding: 5px; word-break: break-word; border-width: 1px; border-style: solid; border-color: rgb(0, 0, 0);">
					<p style="overflow-wrap: break-word; margin: 0px;">
						<span>38214</span>
					</p>
				</td>
			</tr>
		</tbody>
	</table>
		D2:D5)">
                    <p style="text-align: right; margin: 0px; display: block; overflow-wrap: break-word;">
                        <span>44500</span></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", "numberFormat"],
			"editor.menu.list": ["table"],
			"editor.menu.show": true,
			"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>

...