https://bugs.documentfoundation.org/show_bug.cgi?id=153790
Stéphane Guillou (stragu) <stephane.guil...@libreoffice.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Blocks| |108253, 108844
CC| |stephane.guillou@libreoffic
| |e.org
Whiteboard| QA:needsComment |
Version|7.5.0.3 release |6.0.0.3 release
Summary|Range in cell formula |Sheet references are
|referring to another sheet |duplicated after a cut and
|gets expanded using sheet |paste action
|name twice |
Status|UNCONFIRMED |NEW
Keywords| |bibisectRequest, regression
Ever confirmed|0 |1
--- Comment #1 from Stéphane Guillou (stragu)
<stephane.guil...@libreoffice.org> ---
I could reproduce by using the following steps:
1. Open Calc
2. In cell A1, enter the formula: =SUM($Sheet1.B1:C1)
3. Optional check: Copy the A1 cell, paste in A2: formulas stay the same
4. Cut the A1 cell, paste in A3
Result:
Both A2 and A3 are updated to repeat the sheet reference:
=SUM($Sheet1.B:$Sheet1.B)
Tested in:
Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community
Build ID: 002ae41bb6088002ba3ed0188ac822fb823a23f9
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded
Already in 6.0.0.3, but it's a regression as OOo 3.3 did not have that issue.
Note that, if using relative references (no dollar sign in step 2), the
formulas are all _simplified_ to remove the superfluous sheet reference.
Referenced Bugs:
https://bugs.documentfoundation.org/show_bug.cgi?id=108253
[Bug 108253] [META] Calc cell formula bugs and enhancements
https://bugs.documentfoundation.org/show_bug.cgi?id=108844
[Bug 108844] [META] Cut/copy bugs and enhancements
--
You are receiving this mail because:
You are the assignee for the bug.
