univer-bot[bot]
commented
1 week ago Bot detected the issue body's language is not English, translate it automatically. 👯👭🏻🧑🤝🧑👫🧑🏿🤝🧑🏻👩🏾🤝👨🏿👬🏿
Origin Title: [Bug] Formula SUMIFS calc fail when params values contains string and number
Title: [Bug] Formula SUMIFS calc fail when params values contain string and number
Before you submit this issue, have you checked the following
- [X] Is this really a problem?
- [X] I have searched the Github Issues for similar issues, but did not find anything.
Affected packages and versions
latest
Reproduction link
https://stackblitz.com/~/github.com/zeyongTsai/sheets-vite-demo
1: switch to zeyongTsai/patch-97961 branch
2: start vite
3: there is a formula in I3 cell of Shen and Redemption TA system statistics sheet, it depends on Financial Management Sales System Transaction Data (Position) Report
4: alter G4 cell of financial sales system transaction data (position) report sheet, I3 cell value will be 0.00, it should be the altered value
Expected behavior
compare C3 cell value of TA system statistics sheet and B column cell values of financial sales system transaction data (position) report sheet should be equal
Actual behavior
C3 value is not equal B column cell value, so calc result is 0.00
System information
universal: 0.5.0 chrome: 131.0.6778.86
zeyongTsai
Before you submit this issue, have you checked the following
Affected packages and versions
latest
Reproduction link
https://stackblitz.com/~/github.com/zeyongTsai/sheets-vite-demo
1: switch to
zeyongTsai/patch-97961branch 2：start vite 3：there is a formula in I3 cell of 申赎TA系统统计 sheet, it depends on 理财销售系统交易数据(头寸)报表 4：alter G4 cell of 理财销售系统交易数据(头寸)报表 sheet, I3 cell value will be 0.00 , it should be the altered valueExpected behavior
compare C3 cell value of 申赎TA系统统计 sheet and B column cell values of 理财销售系统交易数据(头寸)报表 sheet should be equal
Actual behavior
C3 value is not equal B column cell value, so calc result is 0.00
System information
univer: 0.5.0 chrome: 131.0.6778.86