Any function against a cell in Aspose cells cannot take more than 30 arugments. i.e if I place a formula in a cell as SUM(arg1, arg2,…… argN). If N>30, then evaluation will fail. For us, we have complex calculation which calls for support for a higher number of parameters. We typically need something like 200.
We thought of a with a solution of breaking this like this. Arg1, arg2, arg3, arg4……..arg85 can be broken as SUM(SUM(arg1-arg30), SUM(arg31-arg60), SUM(arg61-arg85)). Unfortunately this approach will not work correctly for AVERAGE.
Hence we request for the following enhancement as a solution to the problem:
Preference 1: Aspose Cells to remove this restriction and allow any number of parameters
Preference 2: Aspose can make this configurable. Whoever wants can increase it. If not configured this can be kept at 30.
Preference 3: Aspose can make it to a bigger number like 300
Kindly let us know the feasibility of this. Would appreciate if Aspose can make this fix as this is a show-stopper issue for us.
Thanks and Regards,