Possible bug in OFFSET function

tcnz · November 25, 2007, 10:59pm

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.

Laurence · November 25, 2007, 11:34pm

Please try the version attached at <A href=" .

tcnz · November 25, 2007, 11:43pm

Hi Laurence,

Yes! That fixed it.

Cheers

tcnz · November 26, 2007, 2:15pm

Hi Laurence,

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

Thanks