CalcCellValue returns incorrect results in some case

[BigtigerGG]

我的Excel文件有两个工作表，分别为：

• Sheet1
• Sheet2

Sheet2中有一列的值使用VLOOKUP计算，公式内容为：VLOOKUP(C4,'Sheet1'!A$2:B$200,2,0)，目的是为了在Sheet1的 A$2:B$200范围内中查找Sheet2 C4单元格值，并返回Sheet1对应第二列的值

但是实际上CalcCellValue返回了 空字符串 且没有任何报错，想请教下这个问题该如何解决

[xuri]

Thanks for your issue. Which version of the Excelize library are you using? Could you follow the issue template and show us a complete, standalone example program or reproducible demo?

[BigtigerGG]

Thanks for your issue. Which version of the Excelize library are you using? Could you follow the issue template and show us a complete, standalone example program or reproducible demo?

感谢回复🙏！
excelize版本：v2.8.0
Description
CalcCellValue 似乎不能在跨工作表总计算公式值

Steps to reproduce the issue:

1. 示例文件：demo.xlsx
2. 使用go1.18编写如下测试代码

func getExcel() (*excelize.File, error) {
	f, err := excelize.OpenFile("demo.xlsx")
	if err != nil {
		fmt.Println(err)
		return nil, err
	}
	defer func() {
		if err := f.Close(); err != nil {
			fmt.Println(err)
		}
	}()
	return f, nil
}

func testCalc(_ context.Context) error {
	f, err := getExcel()
	if err != nil {
		return err
	}
	const (
		sheet1 = "Sheet1"
		sheet2 = "Sheet2"
	)

	// 打印公式
	formula, err1 := f.GetCellFormula(sheet2, "B1")
	fmt.Printf("公式:%s 错误:%s \n", formula, err1)

	// 计算公式
	calVal, err2 := f.CalcCellValue(sheet2, "B1")
	fmt.Printf("公式结果:%s 错误: %s \n", calVal, err2)
	return nil
}

Describe the results you received:

公式:VLOOKUP(A1,'Sheet1'!A$1:B200,2,0) 错误:nil
公式结果: 错误: nil

Describe the results you expected:
从代码返回结果来看，这个方法返回了空字符串，预期应该返回 Bar1

Output of go version:

go version go1.18.10 darwin/arm64

Excelize version or commit ID:

v2.8.0

Environment details (OS, Microsoft Excel™ version, physical, etc.):
示例文件：
demo.xlsx

[BigtigerGG]

@xuri 完整的复现路径如上所示🙏🙏

[xuri]

Thanks for your feedback. This issue has been fixed. Please upgrade to the master branch code by go get -u github.com/xuri/excelize/v2@master, and this patch will be released in the next version.

[BigtigerGG]

感谢🙏