From 996e3e343760bcfa23b55138f85abd62d6ebfb22 Mon Sep 17 00:00:00 2001 From: licp <lichunping@guanfang.com.cn> Date: 星期三, 25 十二月 2024 09:02:07 +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