New bug in version 18.5 (works on 18.3)

Aspose.Cells Product Family
1

This C# code failed on version 18.5 but works in version 18.4 and before.

var workbook = new Workbook();
workbook.FileFormat = FileFormatType.Xlsx;
var selectedSheet = workbook.Worksheets[0];
 selectedSheet.Cells["A1"].R1C1Formula = @"=SUMIFS($AM$6:$AM$7,$AP$6:$AP$7,RC[16],$BE$6:$BE$7,""Y"")" ;

A lot of report is done using it, could you please fix it?
Thanks

3

@Chabie

Thanks for using Aspose APIs.

We have looked into this issue further and found that the formula

=SUMIFS($AM$6:$AM$7,$AP$6:$AP$7,RC[16],$BE$6:$BE$7,"Y")

is not a valid R1C1 formula. User should not mix RC references with A1 references in the expression and in MS Excel you cannot set such kind of formula either. In old versions, we do not validate the references, but it is illegal operation in MS Excel. From 18.5 we use more strict constraints for parsing formulas and such kind of illegal formulas are not allowed to be set.