Hi , How do we apply “=SEQUENCE()” Formula ? When i try to apply and calulateFormula . It appends “@” within formula like this “=@SEQUENCE()”. I and using below snipet.
Workbook workbook = new Workbook();
WorksheetCollection worksheets = workbook.Worksheets;
Worksheet worksheet = worksheets.Add(“Daily”);
worksheet.Cells[0, 0].Formula = @"=SEQUENCE(1,23,4,0)";
workbook.RefreshDynamicArrayFormulas(false);
workbook.CalculateFormula();
workbook.Save(“c:\Mohit\newWorksheet1.xlsx”);
Please notice, I am able to reproduce the issue as you mentioned. I found “=SEQUENCE()” formula appends “@” within the formula, i.e., “=@SEQUENCE()”. I used Excel 365 to confirm the issue by opening the output file into it. I have logged a ticket with an id “CELLSNET-50986” for your issue. We will look into it soon.
Once we have an update on it, we will let you know.
We evaluated your issue in details.
For performance considerations, Cell.Formula/SetFormula(…) does not check and apply dynamic array formulas automatically. To set dynamic array formulas, please use Cell.SetDynamicArrayFormula(…) instead, it should work fine.
Let us know if you still have any issue.