We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

FLOOR.MATH function not recognised

I am trying to use the function FLOOR.MATH and seems Aspose.Cells doesn’t have it implemented, could you confirm that and fix it?

When I execute the CalculateFormula function I get “#NAME?” as a result:
image.png (6.3 KB)

I know that the FLOOR function works, but that one doesn’t have the mode parameter to round towards or away from 0.

The code used is:
using (var workbook = new Workbook(m_source))
object result = workbook.Worksheets[0].CalculateFormula("=FLOOR.MATH(-555,10,1)");

And the Excel file any, for example a blank one.
Attaching the code and the file here:
FLOOR.MATH function not recognised.zip (5.5 KB)

Thank you.

We were able to observe the issue but we need to look into it more. We have logged the issue in our database for investigation and for a fix. Once, we will have some news for you, we will update you in this topic.

This issue has been logged as
CELLSNET-47130 – FLOOR.MATH(-555,5,1) support required in Aspose.Cells


This is to inform you that we have fixed your issue “CELLSNET-47130” now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

Please try our latest version/fix: Aspose.Cells for .NET v20.2.1 (attached)

Your issue should be fixed in it.

Let us know your feedback.

Aspose.Cells20.2.1 For .Net2_AuthenticodeSigned.Zip (5.2 MB)
Aspose.Cells20.2.1 For .Net4.0.Zip (5.2 MB)

The issues you have found earlier (filed as CELLSNET-47130) have been fixed in Aspose.Cells for .NET v20.3. This message was posted using Bugs notification tool by Amjad_Sahi