[Bug 160072] Inconsistent handling of objects on Calc sheets with select all (Delete, clear contents, copy-paste)

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Thu Mar 7 05:10:27 UTC 2024


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

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

           What    |Removed                     |Added
----------------------------------------------------------------------------
         Resolution|---                         |NOTABUG
           See Also|                            |https://bugs.documentfounda
                   |                            |tion.org/show_bug.cgi?id=15
                   |                            |9800
                 CC|                            |libreoffice-ux-advise at lists
                   |                            |.freedesktop.org,
                   |                            |stephane.guillou at libreoffic
                   |                            |e.org
             Status|UNCONFIRMED                 |RESOLVED
           Keywords|                            |needsUXEval
            Summary|Inconsistent handling of    |Inconsistent handling of
                   |objects on Calc sheets      |objects on Calc sheets with
                   |                            |select all (Delete, clear
                   |                            |contents, copy-paste)

--- Comment #1 from Stéphane Guillou (stragu) <stephane.guillou at libreoffice.org> ---
Thanks for splitting this from bug 159800, jollytall.

My first reaction was:

Ctrl + A -> Delete is different to Ctrl + A -> Ctrl + X. This feels
inconsistent (also with the Writer behaviour), but I some users' workflows
might rely on a way to modify all cells without affecting objects...

However, as you noticed, we've got two ways to remove things in Calc (whereas
Writer does not seem to make the distinction):
- Delete: directly removes cell contents
- Backspace (same as "Clear Contents" in context menu): offers a dialog. The
default removes text, date & time, comments, numbers, formulas - which matches
what Delete does. But one can pick and choose what gets deleted, and can delete
absolutely everything with one tick of a box. Options are remembered, so it's
then easy to Backspace + Enter.

(In reply to jollytall from comment #0)
> It has a strange side-effect, that if a sheet is Ctrl-A, Ctrl-C and another
> sheet is also Ctrl-A, Ctrl-V then the objects on the target sheet remain
> there.
It think this has to be the case, as the objects are two separate elements,
with different names assigned to them, as can be seen in the navigator. One
can't expect LO to replace an object just because it is of same type and is
anchored to the same cell. And a single cell can have as many objects anchored
to it as we desire.
Paste Special gives a large number of options to decide exactly what is pasted.
It's different for cell contents, as it is straight-forward to understand the
model of pasting cell contents over others at the same coordinates.

So leaning towards "resolved - not a bug", but set back to "unconfirmed" if you
still think something needs changing. Copying the UX/Design team in just in
case.

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


More information about the Libreoffice-ux-advise mailing list