Calc/Features/Multi-range copy and paste
From Apache OpenOffice Wiki
Contents
Multi-range copy and paste
Abstract
This feature extends Calc's current copy and paste functionality, to allow copying of a set of multiple non-contiguous ranges. When pasted, all copied data get consolidated into a single range either horizontally or vertically.