| | |
| | | "author": "LL", |
| | | "private": true, |
| | | "scripts": { |
| | | "dev": "webpack-dev-server --inline --progress --config build/webpack.dev.conf.js", |
| | | "dev": "webpack-dev-server --inline --host 0.0.0.0 --progress --config build/webpack.dev.conf.js", |
| | | "start": "npm run dev", |
| | | "build": "node build/build.js" |
| | | }, |
| | |
| | | }, |
| | | getValue(v){ |
| | | let str = v.v?v.v:(v.ct&&v.ct.s?v.ct.s.length>0&&v.ct.s[0].v.replace(new RegExp('\n', 'g'), '<br/>').replace(new RegExp('@', 'g'), '<br/>'):'') |
| | | // str.replace(new RegExp(search, 'g'), replace) |
| | | return str |
| | | }, |
| | | getInspectionValueType(id) { |
| | |
| | | 'AVERAGE', |
| | | 'ABS', |
| | | ] |
| | | f = f.replace(regex, ',').replaceAll('"&','').replaceAll('&"','') |
| | | 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' |
| | | }); |
| | |
| | | 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) { |
| | |
| | | } |
| | | let isToExponential = '' |
| | | let list2 = [] |
| | | |
| | | excelMethodList.forEach(item => { |
| | | if (item.valueList&&item.valueList.length>0&&item.valueList.find(m => m.r == r && m.c == c)) { |
| | | var comValue = {} |
| | |
| | | self.postMessage(JSON.stringify(result)) |
| | | } |
| | | } catch (error) { |
| | | |
| | | console.log('error---', error) |
| | | } |
| | | |
| | | } else { |
| | |
| | | try{ |
| | | let val = parseFloat(comResult.toFixed(3)) |
| | | a[b].v.v = isNaN(val) ? '' : val |
| | | }catch(e){ |
| | | }catch(error){ |
| | | a[b].v.v = comResult |
| | | console.log('error---', error) |
| | | } |
| | | break |
| | | } |
| | |
| | | } |
| | | self.postMessage(JSON.stringify(result)) |
| | | } catch (error) { |
| | | |
| | | console.log('error---', error) |
| | | } |
| | | } |
| | | |
| | |
| | | } |
| | | return num; |
| | | } catch (error) { |
| | | |
| | | console.log('error---', error) |
| | | } |
| | | } |
| | | /** |
| | |
| | | } |
| | | return max; |
| | | } catch (error) { |
| | | |
| | | console.log('error---', error) |
| | | } |
| | | } |
| | | /** |
| | |
| | | } |
| | | return min; |
| | | } catch (error) { |
| | | |
| | | console.log('error---', error) |
| | | } |
| | | } |
| | | /** |
| | |
| | | return null; |
| | | } |
| | | } catch (error) { |
| | | |
| | | console.log('error---', error) |
| | | } |
| | | } |
| | | /** |
| | |
| | | try { |
| | | return Math.abs(val); |
| | | } catch (error) { |
| | | |
| | | console.log('error---', error) |
| | | } |
| | | } |
| | | /** |
| | |
| | | return null; |
| | | } |
| | | } catch (error) { |
| | | |
| | | console.log('error---', error) |
| | | } |
| | | } |
| | | |
| | |
| | | } |
| | | } |
| | | } catch (error) { |
| | | |
| | | console.log('error---', error) |
| | | } |
| | | } |
| | | |
| | |
| | | letter += String.fromCharCode(65 + (i % 26)); |
| | | return letter + (parseInt(cellId[1]) + 1); |
| | | }catch(e){ |
| | | console.log('error',cellId) |
| | | console.log('error',e) |
| | | } |
| | | } |
| | | /** |
| | |
| | | } |
| | | return id; |
| | | }catch(e){ |
| | | console.log('error',id) |
| | | console.log('error',e) |
| | | } |
| | | } |
| | | |
| | |
| | | }) |
| | | return arr2; |
| | | } catch (error) { |
| | | |
| | | console.log('error',error) |
| | | } |
| | | } |
| | | /** |
| | |
| | | 'AVERAGE', |
| | | 'ABS', |
| | | ] |
| | | f = f.replace(regex, ',').replaceAll('"&','').replaceAll('&"','') |
| | | 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'),',') |
| | | }) |
| | | let arr = f.split(',').filter(item=>{ |
| | | return item&& /[a-zA-Z]/.test(item)&&item!='undefined'&&item!='null' |
| | | }); |
| | | return arr; |
| | | } catch (error) { |
| | | |
| | | console.log('error',error) |
| | | } |
| | | } |
| | | /** |
| | |
| | | }) |
| | | return arr0; |
| | | } catch (error) { |
| | | |
| | | console.log('error',error) |
| | | } |
| | | } |
| | | |
| | |
| | | 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]) |
| | | } |
| | | if(str.includes(',,')){ |
| | | str = str.replaceAll(',,', '') |
| | | str = str.replace(new RegExp(',,', 'g'),'') |
| | | } |
| | | if(str.includes('&"/"&')){ |
| | | return str.replaceAll('&"/"&', '/').replaceAll('//','') |
| | | return str.replace(new RegExp('&"/"&', 'g'),'/').replace(new RegExp('//', 'g'),'') |
| | | }else { |
| | | return eval(str) |
| | | } |
| | | } catch (error) { |
| | | |
| | | console.log('error',error) |
| | | } |
| | | } |
| | | |