I've been working on a particular spreadsheet and I've just noticed that
double clicking the format painter will still only format one cell. It won't
retain the format to be put into the next selected cell which it should when
its double clicked. The same goes for copy and paste. Normally once you've
copied something you can paste it into a number of cells individually, one
after the other, but after the first paste selection, the paste option is no
longer available.

I can't see any settings under options to fix this. What has happened, and
how do I fix it?