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

Free Support Forum - aspose.com

Offset function not being calculated correctly

Hi, i’m reporting an issue with the Offset function not being calculated correctly when I called CalculateFormula().


Sum(A1: Offset( A5,1, 0, 0, -(5-TestNameRange)))
TestNameRange = 5

Thank you!


I think it looks a #REF! error when implementing the formula in MS Excel manually. Could you post your sample template file here, we will check it soon.

Thank you.

Hi, sorry for the faulty example. it’s actually:

data: A1 : A5 = {1,2,3,4,5}

Sum(A1: Offset( A5,0, -(5-TestNameRange)))
TestNameRange = 5
TestNameRange is a variable.
if TestNameRange = 5, result = 15
if TestNameRange = 4, result = 10
if TestNameRange = 3, result = 6
if TestNameRange = 2, result = 3

if TestNameRange = 1, result = 1


Thanks for providing us complete details now.

Yes, we found the issue as you have mentioned, we will figure it out soon.

Thank you.

Please try the attached version, we have fixed the formula calculation issue.
Thank you.

The issues you have found earlier (filed as 10293) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by aspose.notifier.