FLOOR.MATH function not recognised

Aspose.Cells Product Family
1

Hi,
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.

2

@ServerSide527,
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

3

@ServerSide527,

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.

4

@ServerSide527,
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)

5

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