@ added to forecast formulae

[ABSYKS]

Description When setting a 'FORECAST' formula, '@' is inserted in between the '=' and the rest of the formula.

Steps to reproduce the issue:

file := excelize.NewFile()
file.NewSheet("Sheet 1")
file.SetCellFormula("Sheet 1", "A1", "FORECAST.LINEAR(2021,B3:D3,B1:D1)")
file.SaveAs("file.xlsx")

Describe the results you received: When opening the spreadsheet, the cell formula is set as "[email protected](2021,B3:D3,B1:D1)"

Output of go version:

go version go1.14.2 darwin/amd64

Excelize version or commit ID:

Excelize v2.1.0

[xuri]

Thanks for your feedback. Which version of the spreadsheet application are you using? I have tested on Excel for mac 16.35, Excel 16.0.12624.20422 on Windows and it works well.

[ABSYKS]

Thanks for the quick response! I am using Excel for mac 16.36.

[Toshik1978]

The same issue with XLOOKUP. It’s new Dynamic Arrays feauture. And excelize has no ways to deal with it

Here some info