https://bugs.documentfoundation.org/show_bug.cgi?id=150320
Bug ID: 150320
Summary: Calc: Link converted to text on copy of cell
Product: LibreOffice
Version: 7.3.5.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: bugs_documentfoundation_org.5.k...@xoxy.net
Description:
When a cell with a link (eg. "=A1") is copied to another cell, the link is
replaced with the content of the cell.
Steps to Reproduce:
1. Create a link in one cell (eg. "=A1" in B1)
2. Copy the link to a new cell with Ctrl+C -> Ctrl+V
Actual Results:
The cell content is switched from a link to text
Expected Results:
Do not change the cell content.
If the content needs to be changed ask me OR If the content is changed by LO
tell me so.
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 7.3.5.2 / LibreOffice Community
Build ID: 184fe81b8c8c30d8b5082578aee2fed2ea847c01
CPU threads: 16; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: de-AT (de_AT.UTF-8); UI: de-DE
Flatpak
Calc: threaded
--------------------------------------------------------------------------------
This behaviour changed some time ago (first observed in mid to late July).
Before the change it was like I was used to and I will ever consider as sane
behaviour: When you copy and paste a cell with Ctrl+C -> Ctrl+V the cell is
copied 1:1 and the content is neither changed nor transformed.
Since it's consistent and you can do Ctrl+C -> Ctrl+C -> Ctrl+V to get a 1:1
copy, I don't think this change was done by accident.
Yet I simply have to see it as bug based on the fact of what I'm doing and how
this change manifests itself. I have a table in calc where I calculate some
values. The values are not written in but linked from another cell so that the
same value that is used multiple times on purpose can be changed very quickly.
What this "feature" does is that it destroys exactly this mechanism without
telling me so. Since it worked the opposite way for the last decade or so I
most likely will forget to check the link at some point and I will be stuck
with a 'hard' (not linked) value in one or more cells if I don't double check
every single cell (for 2022 I currently have ~1500 entries to check).
If the change was done on purpose, this behaviour should never be the default
in any case.
Since I only copied the cells with Ctrl+C -> Ctrl+V and never changed any
settings I don't think I caused this behaviour.
--
You are receiving this mail because:
You are the assignee for the bug.
