You can buy this plugin on Repo plugin formula Demo is available on demo formula

You can buy this plugin on Repo plugin formula Demo is available on demo formula

• Add formulabar for write formula (highlighted)
• Tape F2 after selection cell, and your focus is on formula bar for edit.
• When cell is readonly, formulabar show on readonly value of cell.
• Input formula bar is in multiline, tape ALT+ENTER and new line is created on formula bar.
• If cell type is not recognize for formula, first char "=" is denied.
• Range of cells present on formula is colored on focus in formula bar
• Support custom formula + documentation
• Support multi formula autocomplete + Documentation (helper)
• Change editor of cell with formula (highlighted) + Documentation
• Create an alias of formulas

• for v1.x JSpreadsheet Pro v7
• for v2.x JSpreadsheet Pro v8 of JSpreadsheet Pro v9 and Formula-Pro

For JSS v8 you can use dictionary with jSuites

jSuites.setDictionary({
    "Example": "Exemple",
    "Results": "Resultats",
    "Parameters": "Paramètres",
    "Learn more": "En savoir plus",
    "Read more": "Lire plus",
});

You can write your documentation of formulas, by default, this documentation is the same of Google Sheet formula. For write your documentation, add new item on the var jspreadsheet.formulasDoc

1 item of jspreadsheet.formulasDoc is construct like :

jspreadsheet.formulasDoc['MYFUNCTION()'] = {
       syntax:"MYFUNCTION(value, value)",
       about:"My custom function description ",
       examples:"MYFUNCTION(2008, 7) equals 25",
       params:[
           {type:"Float", comment:"First value"},
           {type:"Float", comment:"Second value"}
        ],
       link:"https://mydocs.domain.ext/doc/123456"
};

Important on jspreadsheet.formulasDoc object, define key property formula with () to end else it considers it as a variable.

{
  url: "UrlOfPage",
  text: "Label of Button",
  callback: function(documentation) {/* your action on click */}
}

function(buttonElement, documentation) {
   // Exemple
   buttonElement.href = "yourUrl";
   buttonElement.addEventListener("click", (e) => {});
   // ....
}

Header on page for v7

<script src="https://jspreadsheet.com/v7/jspreadsheet.js"></script>
<script src="https://jspreadsheet.com/v7/jsuites.js"></script>
<link rel="stylesheet" href="https://jspreadsheet.com/v7/jsuites.css" type="text/css" />
<link rel="stylesheet" href="https://jspreadsheet.com/v7/jspreadsheet.css" type="text/css" />

<script src="/path/to/jss.formula.js"></script>
<link rel="stylesheet" href="/path/to/jss.formula.css" type="text/css" />

Header on page for v8

<script src="https://jsuites.net/v4/jsuites.js"></script>
<link rel="stylesheet" href="https://jsuites.net/v4/jsuites.css" type="text/css" />

<script src="https://jspreadsheet.com/v8/jspreadsheet.js"></script>
<link rel="stylesheet" href="https://jspreadsheet.com/v8/jspreadsheet.css" type="text/css" />

<script src="http://www.jspreadsheet.com/v8/plugins/formula.js"></script>

<script src="/path/to/jss.formula.js"></script>
<link rel="stylesheet" href="/path/to/jss.formula.css" type="text/css" />

Initialize plugin on JSpreadsheet

jspreadsheet(document.getElementById('spreadsheet'), {
	...
	plugins: [
      ...
      { 
         name:'formula',
         plugin:jss_formula,
         options:{
            allowFormulaOnTypes: "myCustomEditor",
            allowAutocomplete: false,
            allowHelper: false,
         }
      },
      ...  
    ],
    ...
});

Add on header of page after loading plugin

<script>
   var MY_CUSTOM_FORMULA = function(a,b) {return a+b;};
   jspreadsheet.formulasDoc["MY_CUSTOM_FORMULA()"] = {syntax:"MY_CUSTOM_FORMULA(number,number)",about:"One custom formula for test"};
</script>

Initialize plugin on JSpreadsheet

jspreadsheet(document.getElementById('spreadsheet'), {
	...
	plugins: [
      ...
   	{ name:'formula', plugin:jss_formula },
      ...  
    ],
    ...
});

Copyright GBonnaire.fr and Code released under the commercial License. This plugin required license of Repo.gbonnaire.fr