Offset function not being calculated correctly

Aspose.Cells Product Family
1

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


example:

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


Thank you!
2

Hi,

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.

3

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

4

Hi,

Thanks for providing us complete details now.

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

Thank you.

5

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

6

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.