An extended version of copy&paste is now available. There are two possibilities: In the first one, the source range can consist of several blocks, the destination shape is a single cell --> the source is copied such that its upper left corner is at the destination cell. In the second one, the source range must be a single block, the destination can be several blocks --> the source is tiled into the destination blocks.
How (in spready) a formula can be pasted from one cell to another cells, for example to all cells of a column?
Select the source cell, press CTRL+C. Select the range of destination cells: click at first cell, SHIFT-click at last cell (or drag, you can also CTRL-click for non-contiguous cells) (sorry, you cannot click at the column header to select all cells in the column, yet), press CTRL+V.
Another limitation: Since fpspreadsheet supports only within-sheet references it is not possible to copy a formula to another sheet such that the references point to the source sheet, the pasted formula will always refer to cells in the destination sheet. If you're only interested in values and formats, no problem to copy to another sheet, even to another application.
A comment on spready: It's nowhere documented as such, but I consider spready as deprecated and will remove it soon. Most of its functionality has been moved to "examples\visual\fpsctrl\demo_ctrls" to show the new visual controls in action (it will maybe renamed back to "spready"...).