formula-editor-vue3

Formula Editor for Vue3 Built with vue-codemirror + codemirror6

Install

1npm install formula-editor-vue3 --save

Usage

main.ts

1import { createApp } from 'vue'
2
3import App from './App.vue'
4
5import FormulaEditor from 'formula-editor-vue3'
6import 'formula-editor-vue3/dist/style.css'
7
8const app = createApp(App)
9
10app.use(FormulaEditor)
11
12app.mount('#app')

tsconfig.json

1{
2  "compilerOptions": {
3    "types": ["formula-editor-vue3/type"]
4  }
5}

*.vue

1<template>
2  <div style="margin: 10px">
3    <input type="text" readonly v-model="result" />
4    <button @click="getResult">获取结果</button>
5  </div>
6  <formula-editor v-model="code" :variables="variables" />
7</template>
8
9<script setup lang="ts">
10  import { onMounted, ref } from 'vue'
11
12  import { evalFormula, type VariableItem } from 'formula-editor-vue3'
13
14  const variables = ref<VariableItem[]>([])
15
16  const code = ref('${d2345678} + 2 + SUM(${d2345678}, 2)')
17
18  const result = ref('')
19
20  const getResult = () => {
21    const data = {
22      d2345678: 1
23    }
24    try {
25      // 使用eval来进行计算获取结果，通过处理变量来获取再data中的值，然后进行计算
26      result.value = evalFormula(
27        code.value,
28        variable => {
29          return `['${variable}']`
30        },
31        data
32      )
33    } catch (error) {
34      console.error('formula error >>>', error)
35    }
36  }
37
38  onMounted(() => {
39    variables.value = [
40      {
41        label: '单行文本',
42        value: 'd2345678',
43        desc: '字符串'
44      }
45    ]
46  })
47</script>

*.vue use slot

1<template>
2  <div style="margin: 10px">
3    <input
4      type="text"
5      readonly
6      v-model="customResult"
7      placeholder="输出结果"
8      class="result-input"
9    />
10    <button @click="getCustomResult" style="margin-left: 10px" class="result-btn">
11      获取自定义结果
12    </button>
13  </div>
14  <formula-editor
15    v-model="customCode"
16    :title="'自定义计算MATHS'"
17    :variables="customVariables"
18    :math-list="customMathList"
19  >
20    <template #variable="{ insert }">
21      <ul class="custom-variables-list">
22        <li v-for="item in customVariables" :key="item.value" @click="insert(item.value)">
23          {{ item.label }}
24        </li>
25      </ul>
26    </template>
27    <template #math="{ insert }">
28      <ul class="custom-maths-list">
29        <li v-for="item in customMathList" :key="item.name" @click="insert(item.name)">
30          {{ item.name }}
31        </li>
32      </ul>
33    </template>
34  </formula-editor>
35</template>
36<script setup lang="ts">
37  const customVariables = ref<VariableItem[]>([
38    {
39      label: '当前日期',
40      value: 'd1345678'
41    }
42  ])
43  const customCode = ref('GET_DATE(${d1345678})')
44  const customResult = ref('')
45  const customMathList = ref<MathItem[]>([
46    {
47      name: 'GET_DATE',
48      handler: date => {
49        return date.getFullYear() + '-' + (date.getMonth() + 1) + '-' + date.getDate()
50      }
51    }
52  ])
53
54  const getCustomResult = () => {
55    const data = {
56      d1345678: new Date('2024-12-01')
57    }
58    try {
59      customResult.value = evalFormula(
60        customCode.value,
61        text => {
62          return `['${text}']`
63        },
64        data,
65        customMathList.value
66      )
67    } catch (error) {
68      console.error('formula error >>>', error)
69    }
70  }
71</script>

Props

Prop	Type	Default	Description	Required
title	string	''	title	false
isDark	boolean	false	one dark theme	false
disabled	boolean	false	disabled	false
height	number	200	editor height	false
placeholder	string	''	editor placeholder	false
variables	VariableItem	[]	variables for formula	false
mathList	MathItem	FORMULA_MATHS	math list for formula	false

Slots

Slot Name	props	type	Description
math	insert	(mathName:string)=> void	insert math formula
variable	insert	(varName:string)=> void	insert variable formula