The formula is not evaluated correctly when the fill right function is used.

To reproduce:

1. Enter the word "A1" in cell A1 and "B1" in cell B1.
2. Enter the formula "=A1&B1" in cell C1. C1 now correctly shows "A1B1"
3. Select C1 to H1 and run the Fill Right command.

Observe that D1, E1, and F1 show the correct result, but G1 and H1 show "0".

Workaround:

Save and reopen the document.