Expected behaviour
I have used the fill function (see cell d10), to populate cells a3-b12 with the formula given in a2 and b2 (B1*$B$1). The function refers to $B$1, hence if I change B1 from 2 to 3 I would expect that B2=9; B3=27 and so on
Similar if I change B1 from 3 to 2 I would expect B2=4; B3=8 … B9=512 …
Actual result
When I change B1 from 3 to 2 the cells B1 to B8 are calculated as expected, however B9=3888 instead of the expected 512
I am currently tethering with a mobile phone, perhaps the bad internet connection affects the values displayed.
The check in cells c1:c10 checks whether a1=b1 etc. and even though B9 shows a value that is unequal to A9, the C9 show True so perhaps there is problem with displaying the correct values (I use chrome on MacOS Sierra)