I am using version 2.6.1.0 and the formula below cause an error when I try to save it:
=IF(P205=0,0,TRUNC(O205/P205,4))
Thx
also, ROUNDDOWN is not supported
Aspose.Excel has already supported it. Please download the new version at www.aspose.com/downloads.
If you bought license before 2005/01/22, you have to upgrade your license file for the new version. please check
for how to upgrade it.
@azure_ss,
Aspose.Cells has replaced Aspose.Excel that is no more available now. This new product supports all the latest functions that are supported by different versions of MS Excel. You can use Aspose.Cells to use the above-mentioned formulas i.e. TRUNC and ROUNDDOWN as demonstrated in the following sample code:
Workbook workbook = new Workbook();
workbook.Worksheets[0].Cells["A1"].Formula = "=ROUNDDOWN(3.14159, 3)";
workbook.Worksheets[0].Cells["A2"].Formula = "=TRUNC(3.14159)";
workbook.Save("Output.xlsx");
For more information about the Formulas follow the link below:
Formulas
Get the free trial version here for testing the product:
Aspose.Cells for .NET (Latest Version)
A complete runnable solution can be downloaded here to test the product features with the help of hundreds of ready to run examples.