Dear Team,
I hope this message finds you well.
We are currently working on a project involving data modeling in Excel. The Excel file we are using contains thousands of formulas, and after modifying certain values, we are recalculating the workbook programmatically using C#.
While most formulas are calculating as expected, we are encountering an issue specifically with the Forecast.ETS function, which returns “#NAME?” in the corresponding cell.
To investigate further, we utilized the AbstractCalculationMonitor class, which highlighted the issue at the Forecast.ETS function. We have explored several properties and methods to resolve this, but the issue persists.
As this functionality is a core component of our project, we are considering purchasing an Aspose.Cells license. Could you kindly confirm if the Forecast.ETS function is supported, and provide guidance on how we may resolve this issue?
For reference, we are using:
- .NET version 6
- Aspose.Cells version 25.1.2
I have attached the sample input and output Excel files, with the formula located in cell “J4”. Additionally, I’ve included a sample of the relevant C# code.
using (var workbook = new Workbook(“C:\AB\ProjectFiles\Input.xlsx”))
{
workbook.CalculateFormula(false);
workbook.Save($“C:\AB\ProjectFiles\Output.xlsx”);
}
SampleExcels.zip (14.8 KB)
Thank you for your assistance. We look forward to your guidance on this matter.
Best regards,
Sharad
@sharadaspose
Dear Sharad,
Thank you for reaching out regarding the support for the Forecast.ETS function in Aspose.Cells.
Currently, Aspose.Cells does not support the calculation of the Forecast.ETS function. As a result, when you attempt to use this function, it returns the error “#NAME?” in the corresponding cell, even after calling workbook.CalculateFormula(). This limitation is due to the complexity of the function, and while there are plans to investigate support for it in future versions, it may take some time before it becomes available.
As a workaround, you might consider re-saving your Excel file using a version of Excel that supports the Forecast.ETS function, such as Excel 365. Once you have re-saved the file, you can then use it with Aspose.Cells to perform your calculations without encountering the “#NAME?” error.
If you have any further questions or need additional assistance, feel free to ask.
Best regards,
[Your Name]
Sources:
[1]: Help! .NET Save to CSV doesn’t save formula results–outputs “#NAME?” instead
@sharadaspose,
We are sorry but Aspose.Cells does not support to calculate Forecast.ETS function/formula. We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.
Issue ID(s): CELLSNET-57729
You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.