[Bug 161192] EDITING - allow for default change to cut/copy cell content without affecting source or target formatting

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=161192

Stéphane Guillou (stragu) <stephane.guillou at libreoffice.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |libreoffice-ux-advise at lists
                   |                            |.freedesktop.org,
                   |                            |stephane.guillou at libreoffic
                   |                            |e.org
             Status|UNCONFIRMED                 |NEEDINFO
                URL|                            |https://ask.libreoffice.org
                   |                            |/t/how-to-prevent-cell-form
                   |                            |atting-being-removed-when-v
                   |                            |alues-are-cut/53102
           Keywords|                            |needsUXEval
            Summary|EDITING - allow for default |EDITING - allow for default
                   |change to copy cell content |change to cut/copy cell
                   |without formatting          |content without affecting
                   |                            |source or target formatting
           See Also|                            |https://bz.apache.org/ooo/s
                   |                            |how_bug.cgi?id=8461,
                   |                            |https://bugs.documentfounda
                   |                            |tion.org/show_bug.cgi?id=64
                   |                            |028
     Ever confirmed|0                           |1

--- Comment #2 from Stéphane Guillou (stragu) <stephane.guillou at libreoffice.org> ---
The Paste Special dialog (Ctrl + Shift + V) remembers the latest settings, so
it is possible to set the options as needed there once ("Values only"), and
then do:
1. Select source
2. Copy
3. Delete (removes the contents but not the formatting)
4. Move to target
5. Ctrl + Shift + V, then Enter (which reuses the latest settings)

Is that not sufficient?

But Ask.LO questions show that there is significant demand for such a feature.
See for example:
-
https://ask.libreoffice.org/t/calc-how-do-i-drag-and-drop-contents-only-while-preserving-formatting-in-the-original-cell/2978
-
https://ask.libreoffice.org/t/how-to-prevent-cell-formatting-being-removed-when-values-are-cut/53102
-
https://ask.libreoffice.org/t/calc-can-i-cut-paste-the-contents-of-multiple-cells-at-once-without-affecting-references-and-formats/13971
- https://ask.libreoffice.org/t/preserve-formatting-during-drag-and-drop/44121

Very much related to bug 64028, although that one only asks about not removing
the format of cut cells, not a "formatless cut/copy/paste setting" per se.

UX/Design team, what do you think?

-- 
You are receiving this mail because:
You are on the CC list for the bug.