Difference between revisions of "Calc/Features/Multi-range copy and paste"

From Apache OpenOffice Wiki
< Calc‎ | Features
Jump to: navigation, search
(Abstract)
(Detailed Specification: added description.)
Line 5: Line 5:
  
 
== Detailed Specification ==
 
== Detailed Specification ==
 +
 +
=== When copying ===
 +
When copying a set of non-contiguous ranges, the ranges must either
 +
 +
* have the same row range i.e. identical begin/end row pair, or
 +
* have the same column range i.e. identical begin/end column pair.
 +
 +
If neither of these conditions is met, an error message will appear, and nothing gets copied to the clipboard.
 +
 +
=== When pasting ===
 +
When pasting, the non-contiguous ranges copied to the clipboard get consolidated into a single range and that single range gets pasted to the destination.  How the ranges get consolidated depends on whether the ranges have identical column range (row-wise separation), or they have identical row range (column-wise separation).  For row-wise separation, ranges join by removing empty rows between the copied ranges, while for column-wise separation, ranges join by removing empty columns in-between them.
  
 
== Migration ==
 
== Migration ==

Revision as of 19:47, 5 August 2009

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. There are some restrictions when ranges are being copied, in order to ensure that the pasted range become a rectangular range.

Detailed Specification

When copying

When copying a set of non-contiguous ranges, the ranges must either

  • have the same row range i.e. identical begin/end row pair, or
  • have the same column range i.e. identical begin/end column pair.

If neither of these conditions is met, an error message will appear, and nothing gets copied to the clipboard.

When pasting

When pasting, the non-contiguous ranges copied to the clipboard get consolidated into a single range and that single range gets pasted to the destination. How the ranges get consolidated depends on whether the ranges have identical column range (row-wise separation), or they have identical row range (column-wise separation). For row-wise separation, ranges join by removing empty rows between the copied ranges, while for column-wise separation, ranges join by removing empty columns in-between them.

Migration

N/A

Configuration

N/A

File Format

N/A

Open Issues

Personal tools