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.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)