[Libreoffice-bugs] [Bug 153790] Sheet references are duplicated after a cut and paste action
https://bugs.documentfoundation.org/show_bug.cgi?id=153790 raal changed: What|Removed |Added Regression By||Eike Rathke Keywords|bibisectRequest |bibisected, bisected CC||er...@redhat.com, ||r...@post.cz --- Comment #3 from raal --- This seems to have begun at the below commit in bibisect repository/OS /bibisect-win32-5.4. Adding Cc: to Eike Rathke ; Could you possibly take a look at this one? Thanks c262f9a0e3afb9b14acf53338f82089386bd4b84 is the first bad commit commit c262f9a0e3afb9b14acf53338f82089386bd4b84 Author: Norbert Thiebaud Date: Sun Feb 12 16:18:16 2017 -0800 source sha:aeb465a458fc7ba02e3b1ca6b4193488defef511 https://git.libreoffice.org/core/+/aeb465a458fc7ba02e3b1ca6b4193488defef511 yet more 3D flag to preserve cases, tdf#103890 follow-up -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153790] Sheet references are duplicated after a cut and paste action
https://bugs.documentfoundation.org/show_bug.cgi?id=153790 ady changed: What|Removed |Added Version|5.4.0.3 release |5.4.7.2 release -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153790] Sheet references are duplicated after a cut and paste action
https://bugs.documentfoundation.org/show_bug.cgi?id=153790 ady changed: What|Removed |Added Version|6.0.0.3 release |5.4.0.3 release OS|Linux (All) |All --- Comment #2 from ady --- FWIW, also in 5.4, but not in 5.2. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 153790] Sheet references are duplicated after a cut and paste action
https://bugs.documentfoundation.org/show_bug.cgi?id=153790 Stéphane Guillou (stragu) 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) --- 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.