https://bugs.documentfoundation.org/show_bug.cgi?id=160072
Bug ID: 160072
Summary: Inconsistent handling of objects on Calc sheets
Product: LibreOffice
Version: 7.5.5.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: minor
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: jollyt...@freemail.hu
It is not clear how and when objects (like charts, formula objects) are linked
to the actual sheet they appear on.
One would expect that either an object is "part" of the sheet, or it should be
totally independent. In the current implementation it is mixed.
When on a sheet everything is selected (e.g. clicking on the rectangle next to
A1, or Ctrl-A) then objects are included in the selection. So, when the
selection is pasted on another sheet, the objects go with it.
Similarly, when the full selection is cut into the clipboard (Ctrl-X) then all
cells AND the objects are removed.
However, when all is selected and deleted (either with Del, or with right-mouse
Delete...) then the objects remain on the - otherwise empty - sheet.
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.
So, when e.g. a sheet with fresh data or changed formulas are copied again and
again onto the same other sheet, on top of each others many copies of the
object might appear.
It seems that Ctrl-A, right-mouse Clear Contents... might have a solution to
the problem, because there objects can be checked or unchecked for deletion.
I would recommend to always do the same for copy, cut, delete and
overwrite-with-paste. Either the objects need to be copied/deleted separately
(manually), or they are always moved with the sheet and no multiple copies can
appear.
--
You are receiving this mail because:
You are the assignee for the bug.
