Degrade in 4.0 RC [range].calculate AVERAGE(empty) results in #NUM!

Nov 13, 2014 at 4:02 PM
A1=empty
A2= AVERAGE(A1)

Beta2 : cells("A2").calculate resulted in "#DIV/0!" ( It is OK).
RC : cells("A2").calculate resulted in "#NUM!" (It is problem), when open the file by Excel.exe .
After editmode A2 cell and move next cell, then display string changed to "#DIV/0!".
Developer
Nov 13, 2014 at 8:17 PM
Hi, thanks for reporting. I have fixed this in the latest source code and we will soon publish a new RC.