Analysis Toolpak Functions (eg MROUND)

Aspose.Cells Product Family
1

We’re using the MROUND function from the Analysis Toolpak, and the latest build of Aspose.Cells for Java.

The function isn’t working. It doesn’t throw an error, but doesn’t calculate correctly.

Is MROUND a supported function (and are some/all of the Analysis Toolpak functions supported)?

If MROUND is supported, I’ll submit a test case that exposes the issue.

Thanks.

2

Hi,

Well, currently, I 'm afraid the MROUND function is not supported for Aspose.Cells for Java formula calculation engine, we can support it soon for your need.

Check the complete supported formulas list:

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/supported-formulas-functions.html

Thank you.

3

Thank you for the response and the link. We worked around the limitation.

4

Hi,

Please try this attached version for supporting the formula MROUND.