Page History

...

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

When the caret moves into a calculated cell is In that case start the contents in

Image RemovedIf any object (table, horizontal line, image, video function formula is included in the cell formula is

Image Removed the cell includes any plain tab break and hyperlink) formula is

Image Removed the cell contains bulleted list, numbered list, multilevel list or quotation, the formula is

Image Removedimage video table move into as

Image Removed

Description	Example
When character How to write When entering the '=' is entered character in a cell, the cell coordinates are shown will be exposed and the Editor enters status will be changed to the function entering input mode. When the entered character '=' character is removed, the cell coordinates are will be 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
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
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:
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
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).	Image Added

...

Experiencing

HTML

<!-- external jQuerymodules -->
<script type="text/javascript" src="'https://codewww.jquerysynapeditor.com/jquery-3.3.1.js"></script>

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

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

<div style="background-color: #ffffff; width:99%; height:500px;">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 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 2

New Version Current

Key

Experiencing