Free Support Forum - aspose.com

Possible bug in OFFSET function

Hello,

When I call CalculateFormula, my spreadsheet crashes if an OFFSET function contains a cell reference instead of values.

For example, the following works:

OFFSET(A1,0,0)

But the following crashes:

OFFSET(A1, B1, C1) [where B1 = 0 and C1 = 0]

Evaluating version 4.4.0.5 of the .NET version.

Can you please advise if this is a bug or a problem in my spreadsheet?

Many thanks.

Please try the version attached at http://www.aspose.com/Community/Forums/thread/103868.aspx .

Hi Laurence,

Yes! That fixed it.

Cheers

Hi Laurence,

The updated version appears to have introduced a bug in relation to combo boxes - I will post under a new topic.

Thanks