ErickPetru

name: Calculadora de Bhaskara
description: >-
  Permite preparar a planilha na estrutura correta antes de possibilitar
  realizar o cálculo de Equação de 2º Grau com a Fórmula de Bhaskara.
host: EXCEL
api_set: {}
script:
  content: "const prepare = document.getElementById(\"prepare\") as HTMLButtonElement;\r\nprepare.addEventListener(\"click\", async () => {\r\n  await Excel.run(async (context) => {\r\n    const sheet = context.workbook.worksheets.getActiveWorksheet();\r\n    sheet.getRange().clear();\r\n    sheet.name = \"Bhaskara\";\r\n\r\n    const range = sheet.getRange(\"A1:B6\");\r\n    range.values = [[\"Equação de 2º Grau\", \"\"], [\"A\", \"\"], [\"B\", \"\"], [\"C\", \"\"], [\"X1\", \"\"], [\"X2\", \"\"]];\r\n    range.format.borders.getItem(\"InsideHorizontal\").color = \"Black\";\r\n    range.format.borders.getItem(\"InsideVertical\").color = \"Black\";\r\n    range.format.borders.getItem(\"EdgeTop\").color = \"Black\";\r\n    range.format.borders.getItem(\"EdgeLeft\").color = \"Black\";\r\n    ra

ErickPetru

name: Operações Aritméticas com Preparação
description: >-
  Permite preparar a planilha na estrutura correta antes de possibilitar
  realizar operações aritméticas básicas.
host: EXCEL
api_set: {}
script:
  content: "const prepare = document.getElementById(\"prepare\") as HTMLButtonElement;\r\nprepare.addEventListener(\"click\", async () => {\r\n  await Excel.run(async (context) => {\r\n    const sheet = context.workbook.worksheets.getActiveWorksheet();\r\n    sheet.getRange().clear();\r\n    sheet.name = \"Calculadora\";\r\n\r\n    const range = sheet.getRange(\"A1:B5\");\r\n    range.values = [[\"Calculadora\", \"\"], [\"Número 1\", \"\"], [\"Número 2\", \"\"], [\"Operação\", \"\"], [\"Resultado\", \"\"]];\r\n    range.format.borders.getItem(\"InsideHorizontal\").color = \"Black\";\r\n    range.format.borders.getItem(\"InsideVertical\").color = \"Black\";\r\n    range.format.borders.getItem(\"EdgeTop\").color = \"Black\";\r\n    range.format.borders.getItem(\"EdgeLeft\").color = \"Black\";\r\n    range.for

ErickPetru

name: Aritmética Básica
description: >-
  Calcula operações aritméticas básicas a partir dos dados extraídos da planilha
  aberta.
host: EXCEL
api_set: {}
script:
  content: |
    const calc = document.getElementById("calc");
    calc.addEventListener("click", async () => {

ErickPetru

name: Exemplo Básico
description: >-
  Faz chamadas básicas à API Excel para mudar a cor de fundo de células
  selecionadas ou limpar a formatação.
host: EXCEL
api_set: {}
script:
  content: |
    const run = document.getElementById("run");
    run.addEventListener("click", () => {

ErickPetru

name: Inspirado no Exemplo 03
description: >-
  Calcula o valor com desconto a partir do preço e do percentual de desconto,
  lidos das células A1 e B1, com o resultado sendo exibido em C1.
host: EXCEL
api_set: {}
script:
  content: "const form = document.getElementById(\"form\") as HTMLFormElement;\r\nconst result = document.getElementById(\"result\") as HTMLDivElement;\r\n\r\nform.addEventListener(\"submit\", (event) => {\r\n  event.preventDefault();\r\n\r\n  Excel.run(async (context) => {\r\n    const sheet = context.workbook.worksheets.getActiveWorksheet();\r\n    const range = sheet.getRange(\"A1:C1\");\r\n    range.load(\"values\");\r\n    await context.sync();\r\n\r\n    const price = parseFloat(range.values[0][0]);\r\n    const discount = parseFloat(range.values[0][1]);\r\n\r\n    const amountDiscounted = (price * discount) / 100;\r\n    const finalPrice = price - amountDiscounted;\r\n\r\n    result.innerHTML = `\r\n        <ul>\r\n          <li>Preço base: <b>${price}</b>.</li>\r\n          <li>Valor

ErickPetru

Setup

First of all, you need to have a gh-pages. If you don't have, create:

git branch gh-pages

This makes a branch based on the master HEAD. It would be okay but the files and the git history of master branch are not meaningful on gh-pages branch.

ErickPetru

/* Easy-To-Use Bookmarklet to Toogle CSS Layout Hints On/Off
 * Thanks to: https://dev.to/gajus/my-favorite-css-hack-32g3 and https://gist.github.com/vcastroi
 * Usage: create a new bookmarklet (inside your browser Bookmark Manager) and use the folowing code as the bookmark URL:
 */
javascript: (function () {
  const DEPTH = 10, els = document.body.getElementsByTagName('*'), items = [];
  let selector = '', style = '*{color:#000!important;outline:1px solid #f00!important;outline-offset:-2px;background-color:#fff!important;}\n';
  for (let el of els) el.innerHTML.indexOf(style) !== -1 && items.push(el);
  if (items.length > 0) items.forEach(item => item.innerHTML = '');
  else {

ErickPetru

1
00:00:00,000 --> 00:00:02,418
- Nos últimos 10 anos
as páginas Web se tornaram

2
00:00:02,418 --> 00:00:05,600
mais dinâmicas e poderosas
graças ao JavaScript.

ErickPetru

1. Clone your fork, if you didn't it yet:

git clone [email protected]:vuejs-br/br.vuejs.org.git

2. Add remote from original repository in your forked repository:

cd into/cloned/br.vuejs.org
git remote add upstream git://github.com/vuejs/vuejs.org.git
git fetch upstream

ErickPetru

var currencyValidator = {
  format: function (number) {
    return (Math.trunc(number * 1000000000000) / 1000000000000).toFixed(2)
  },
  parse: function (newString, oldNumber) {
    var CleanParse = function (value) {
      return { value: value }
    }
    var CurrencyWarning = function (warning, value) {
      return {