We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

R1C1 formula Not coming correct in sheet

hi,

I have written the following formula in R1C1 style :

=IF(ISERROR(SUMIFS('Daily Raw Data '!C49,'Daily Raw Data '!C2,'Associate Scorecard'!R9C,'Daily Raw Data '!C6,'Associate Scorecard'!R1C24)),"-",(SUMIFS('Daily Raw Data '!C49,'Daily Raw Data '!C2,'Associate Scorecard'!R9C,'Daily Raw Data '!C6,'Associate Scorecard'!R1C24)))

But after generating the sheet, the formula got changed.

=IF(ISERROR(SUMIFS('Daily Raw Data '!C49 : C[44],'Daily Raw Data '!C2 : C[-3],'Associate Scorecard'!R9C,'Daily Raw Data '!C6 : C[1],'Associate Scorecard'!R1C24)),"-",(SUMIFS('Daily Raw Data '!C49,'Daily Raw Data '!C2,'Associate Scorecard'!R9C,'Daily Raw Data '!C6,'Associate Scorecard'!R1C24)))

I highlughted yellow, how the formula is changing.

So, please can any one suggest why this is happening and please provide the solution and sample code for this issue.

Thanks,

Hi,


Thanks for providing your some details.

Please try our latest fix/version: Aspose.Cells for .NET v7.5.0.4 if it works fine.

If you still find the issue, kindly provide us your template Excel file (input and output file etc.) and paste your sample code (runnable) or preferably create a sample console application, zip it and post it here to reproduce the issue on our end, we will check your issue soon.

Thank you.