title: $ in formula doesn't stay fixed when pasting
body: <p><a href="https://i.stack.imgur.com/YZScq.png" rel="nofollow noreferrer">enter image description here</a></p>
  <p>When I try to drag out the formula in the D column it copies the formula except it doesn't keep the d8 fixed in the other cells. Instead it uses d9 d10 d11 etc</p>