Free Support Forum - aspose.com

Apsose Cells 4.3.0.15 and 4.4.0.0 w/ formulas

Aspose.Cells Product Family
#1

Hi, we recently downloaded the 4.3.0.15 hotfix for some pivot table enhancements. Those work nicely. However, we encounter runtime errors when calculating formulas using a colon ":" as the parameters delimeter. This is legal in Excel I think.

I downloaded 4.4.0.0 and the runtime error goes away. I also noticed in the cell.formula documentation that it says the following:

"A formula string always begins with an equal sign (=). And please always use comma(,) as parameters delimeter, such as "=SUM(A1, E1, H2)".

Question, I don't want to have to recode a bunch of existing reports, is this a feature that you removed from 4.3.0.15 when going to 4.4.0.0? Moving forward will we need to use only a comma as the parameters delimeter?

Thanks,

Chris

#2

Hi,

Could you post your template file with the formula (involving colon) to show the issue.

Thank you.

#3

Attached is the spreadsheet. This was generated w/ 4.4.0.0 however 4.3.0.15 threw a runtime error with the formula in cell B13

Chris

#4

Hi Chris,

I think you misunderstood colon usage in Excel formulas. It isn't a parameter delimeter but represents a range. So we always support such formulas as "=SUM(A1:B2, E1)".

In v4.4, we don't remove features in v4.3.0.15. Instead, we fixed this runtime error in pivot table for v4.3.0.15.