/** * Plugin CSS formula of JSpreadsheet Pro * * @version 2.0.0 * @author Guillaume Bonnaire * @website https://repo.gbonnaire.fr * @description add formula system in JSpreadsheet (bar + editor) * * * @license This plugin is distribute under commercial License */ .jss_formulabar form{white-space:nowrap;padding:0;margin:0}.jss_formulabar button.formula_ok{background-color:#e9e9e9;background-image:url(data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAABAAAAAQCAYAAAAf8/9hAAAABGdBTUEAAK/INwWK6QAAABl0RVh0U29mdHdhcmUAQWRvYmUgSW1hZ2VSZWFkeXHJZTwAAAGrSURBVDjLvZPZLkNhFIV75zjvYm7VGFNCqoZUJ+roKUUpjRuqp61Wq0NKDMelGGqOxBSUIBKXWtWGZxAvobr8lWjChRgSF//dv9be+9trCwAI/vIE/26gXmviW5bqnb8yUK028qZjPfoPWEj4Ku5HBspgAz941IXZeze8N1bottSo8BTZviVWrEh546EO03EXpuJOdG63otJbjBKHkEp/Ml6yNYYzpuezWL4s5VMtT8acCMQcb5XL3eJE8VgBlR7BeMGW9Z4yT9y1CeyucuhdTGDxfftaBO7G4L+zg91UocxVmCiy51NpiP3n2treUPujL8xhOjYOzZYsQWANyRYlU4Y9Br6oHd5bDh0bCpSOixJiWx71YY09J5pM/WEbzFcDmHvwwBu2wnikg+lEj4mwBe5bC5h1OUqcwpdC60dxegRmR06TyjCF9G9z+qM2uCJmuMJmaNZaUrCSIi6X+jJIBBYtW5Cge7cd7sgoHDfDaAvKQGAlRZYc6ltJlMxX03UzlaRlBdQrzSCwksLRbOpHUSb7pcsnxCCwngvM2Rm/ugUCi84fycr4l2t8Bb6iqTxSCgNIAAAAAElFTkSuQmCC);background-position:center;background-repeat:no-repeat;border-radius:1px;border:1px solid #ccc;margin-left:1px;margin-right:1px;height:26px;width:20px;box-sizing:border-box;-moz-box-sizing:border-box;font-size:1em;vertical-align:top}.jss_formulabar .autocomplete{position:relative;display:inline-block;width:calc(100% - 25px)}.jss_formulabar .jss_formulabar_textarea{width:100%;border-radius:1px;border:1px solid #ccc;height:26px;min-height:26px;box-sizing:border-box;-moz-box-sizing:border-box;background-color:#fff;font-size:1em;resize:vertical;overflow-y:auto;overflow-x:hidden;white-space:pre-line;word-break:break-all;font-family:Arial,monospace,sans-serif;padding-left:5px}.jss_input{font-family:Arial,monospace,sans-serif}.jss_formula_container{z-index:99;position:absolute;top:0}.jss_input{display:table-cell;vertical-align:middle;padding-right:2px}.jss_formulabar .jss_formulabar_textarea span[data-type=text],.jss_input span[data-type=text]{color:green}.jss_formulabar .jss_formulabar_textarea.nohighlight span,.jss_input.nohighlight span{color:inherit}.jss_formulabar .jss_formulabar_textarea:focus,.jss_formulabar button:focus{outline:0}.jss_formula_container .autocomplete-items,.jss_formulabar .autocomplete-items{margin:0 0;padding:0;z-index:99;overflow:visible;position:absolute;white-space:nowrap;font-size:12px;font-weight:400;line-height:22px;border:1px solid rgba(0,0,0,.2);background:#fff;box-shadow:0 2px 4px rgb(0 0 0 / 20%);font-family:Arial,monospace,sans-serif;max-height:200px;overflow-y:auto}.jss_formula_container .autocomplete-items div,.jss_formulabar .autocomplete-items div{margin:0;cursor:pointer;padding:2px 10px;color:#666;text-align:left}.jss_formula_container .autocomplete-items div div.infoformula,.jss_formulabar .autocomplete-items div div.infoformula{opacity:0;line-height:0;margin:0}.jss_formula_container .autocomplete-items div:hover,.jss_formulabar .autocomplete-items div:hover{background-color:#f6f6f6}.jss_formula_container .autocomplete-active,.jss_formulabar .autocomplete-active{background:#e9e9e9!important;color:#000;border-top:1px solid #ebebeb;border-bottom:1px solid #ebebeb;padding:1px 10px}.jss_formula_container .autocomplete-items div:hover div.infoformula,.jss_formulabar .autocomplete-items div:hover div.infoformula,.jss_formulabar div.autocomplete-active div.infoformula,.jss_input.autocomplete-active div.infoformula{opacity:1;line-height:12px}.jss_formula_container .helper,.jss_formulabar .helper{margin:0 0;padding:0;z-index:99;overflow:visible;position:absolute;white-space:break-spaces;font-size:12px;font-weight:400;line-height:22px;border:1px solid rgba(0,0,0,.2);background:#fff;box-shadow:0 2px 4px rgb(0 0 0 / 20%);font-family:Roboto,RobotoDraft,Arial,monospace,sans-serif;min-width:400px;max-width:70%;text-align:left}.jss_formula_container .helper button.Btclose,.jss_formula_container .helper button.Bthide,.jss_formula_container .helper button.Btshow,.jss_formulabar .helper button.Btclose,.jss_formulabar .helper button.Bthide,.jss_formulabar .helper button.Btshow{position:absolute;padding:0;border:none;background:0 0;opacity:.3}.jss_formula_container .helper button.Btclose,.jss_formulabar .helper button.Btclose{right:12px;top:4px}.jss_formula_container .helper button.Bthide,.jss_formula_container .helper button.Btshow,.jss_formulabar .helper button.Bthide,.jss_formulabar .helper button.Btshow{right:32px;top:4px}.jss_formula_container .helper button.Btclose::before,.jss_formulabar .helper button.Btclose::before{content:'\00d7';font-weight:600;font-family:Arial,sans-serif;font-size:20px}.jss_formula_container .helper button.Bthide::before,.jss_formulabar .helper button.Bthide::before{content:'\2212';font-weight:600;font-family:Arial,sans-serif;font-size:20px}.jss_formula_container .helper button.Btshow::before,.jss_formulabar .helper button.Btshow::before{content:'\002B';font-weight:600;font-family:Arial,sans-serif;font-size:20px}.jss_formula_container .helper button.Btclose:hover,.jss_formula_container .helper button.Bthide:hover,.jss_formula_container .helper button.Btshow:hover,.jss_formulabar .helper button.Btclose:hover,.jss_formulabar .helper button.Bthide:hover,.jss_formulabar .helper button.Btshow:hover{opacity:1}.jss_formulabar .helper * .jss_formula_container .helper *{box-sizing:initial}.jss_formula_container .helper,.jss_formulabar .helper{background-color:#f9f9f9}.jss_formula_container .helper div .formula_example,.jss_formulabar .helper div .formula_example{color:#483d8b;font-weight:700;font-family:Courier,sans-serif}.jss_formula_container .helper div code.syntax,.jss_formulabar .helper div code.syntax{font-size:inherit;display:block;width:calc(100% - 24px);color:#000;background-color:#e9e9e9;padding:4px 12px;box-sizing:initial}.jss_formula_container .helper div div.infoformula,.jss_formulabar .helper div div.infoformula{color:#000;margin:12px;border:none;font-size:12px}.jss_formula_container .helper div span.formula_param_type,.jss_formulabar .helper div span.formula_param_type{font-style:italic;color:#333}.jss_formula_container .helper div h3,.jss_formulabar .helper div h3{color:#7d7d7d;text-transform:uppercase;margin-top:8px;margin-bottom:3px;font-size:12px;font-weight:700}.jss_formula_container .helper div ol,.jss_formulabar .helper div ol{margin:0;padding-left:20px}.jss_formula_container .autocomplete-items div a.formula_button_read_more,.jss_formula_container .helper div a.formula_link,.jss_formulabar .autocomplete-items div a.formula_button_read_more,.jss_formulabar .helper div a.formula_link{padding:5px;color:#333;display:inline-block}.jss_formula_container .helper div a.formula_button_read_more:hover,.jss_formula_container .helper div a.formula_link:hover,.jss_formulabar .helper div a.formula_button_read_more:hover,.jss_formulabar .helper div a.formula_link:hover{background-color:#fff}.jss tbody tr td.cellEdited_by_formulabar{background-color:rgba(127,127,127,.1);border:dashed 1px #000!important}