Example of #CALC! Error

Hello
The case I came across is that the description of the support.microsoft mentions that, for example, the formula =OFFSET (A1,0,0, {2,3}) gives a #CALC! error, but in practice gives a #VALUE! error. Please help in this regard.