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.