https://bugs.documentfoundation.org/show_bug.cgi?id=151111
Bug ID: 151111
Summary: Paste special mechanism significantly deficient in
options
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: eyalr...@gmx.com
When Pasting tabular content in Calc, we now get the following options:
Unformatted Text;
Text / Number / Formula;
Transpose
Paste as HTML/Unformatted Text/Text Import Dialog
There's redundancy here; plus, it's not immediately clear how the text import
dialog is not what you get when you paste as unformatted text. But - that's not
why I'm filing this bug...
In actuality, most of these are _orthogonal_ options. A more complete set of
options would be:
* Transpose the pasted range(s)? Y/N
* Interpretations, if a source document is defined:
* Does keeping cell style means using the same-name style in the target
document, or "pasting" an additional cell style into the target document?
* Will reference be interpreted as referring to the source document, or as
though the same reference definition has been made in the target document?
* Pre-transformations:
* Realize pasted range(s)' cell styles into Direct Formatting (DF)? Y/N
* Replace formulae with their computed values (incl. references)? Y/N
* Kinds of content:
* Clear out formulas? Y/N
* Clear out numbers? Y/N
* Clear out non-number strings? Y/N
* Clear out anchored objects? Y/N
* Direct Formatting (DF) of the cell:
* Apply existing DF to the pasted content? Y/N
* Apply the input range(s)' DF TO the pasted content? Y/N
* Which DF takes precedence? Pasted or Existing?
* Cell style:
* Which cell style to have after paste? Existing/Pasted/None
* (If multiple cell styles are implemented - see bug 149271 - we would also
have the option of keeping both styles)
I'd say _any_ combination of answers to these questions should be supported
(almost; e.g. if formulae are cleared, it doesn't matter how they're
interpreted). That's nearly 2^12 * 3 ~= 6000 combinations, not 4. Plus the
possible interpretation as other formats besides tabular ranges.
--
You are receiving this mail because:
You are the assignee for the bug.
