From 0406078b52bc6b5e6eed97ca7e42e559f786289b Mon Sep 17 00:00:00 2001
From: licp <lichunping@guanfang.com.cn>
Date: 星期二, 22 十月 2024 15:56:51 +0800
Subject: [PATCH] 报告编制预览功能修改
---
src/util/excelFountion.js | 13 +++++++------
1 files changed, 7 insertions(+), 6 deletions(-)
diff --git a/src/util/excelFountion.js b/src/util/excelFountion.js
index f237bc3..05a3e7c 100644
--- a/src/util/excelFountion.js
+++ b/src/util/excelFountion.js
@@ -51,7 +51,7 @@
let min = null;
if(val&&val.length>0){
val = val.filter(item=>item!=null&&item!=='')
- console.log(val)
+ // console.log(val)
if(val.length>0){
min = Math.min(...val)
}
@@ -271,10 +271,11 @@
'AVERAGE',
'ABS',
]
- f = f.replace(regex, ',')
+ f = f.replace(regex, ',').replace(new RegExp('"&', 'g'),'').replace(new RegExp('&"', 'g'),'')
fouList.forEach(item=>{
- f = f.replaceAll(item,',')
+ f = f.replace(new RegExp(item, 'g'),'')
})
+ // console.log('f',f)
let arr = f.split(',').filter(item=>{
return item&& /[a-zA-Z]/.test(item)&&item!='undefined'&&item!='null'
});
@@ -353,14 +354,14 @@
obj[item] = item
}
})
- str = str.replaceAll(':', '-')
+ str = str.replace(new RegExp(':', 'g'),'')
// 鏇挎崲鍙傛暟
for (var a in obj) {
- str = str.replaceAll(a, obj[a])
+ str = str.replace(new RegExp(a, 'g'),obj[a])
}
// 璁＄畻
for (var a in arr) {
- str = str.replaceAll(a, arr[a])
+ str = str.replace(new RegExp(a, 'g'),arr[a])
}
return eval(str)
} catch (error) {
--
Gitblit v1.9.3