I don't know whether this will work in Open Office.
Select all the cells in Column D with the old rate and Copy. Then Edit/Paste Special and tick Values. This will convert all the =$B$4 to the actual values. Then you can change the rate without changing the already entered values.