[Libreoffice-bugs] [Bug 128914] Drag-copy of formulas referencing labels gives wrong result in rows (copying vertically); works in columns (copying horizontally)

[bugzilla-daemon at bugs.documentfoundation.org]

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

Oliver Brinzing <oliver.brinzing at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
     Ever confirmed|0                           |1

--- Comment #1 from Oliver Brinzing <oliver.brinzing at gmx.de> ---
(In reply to Mike Kaganski from comment #0)
> the result is correct 6. But drag-copying the formula down into D3:D6
> produces the column of 6s, while values must be different for each row (6,
> 24, 60, 120, 210). Hard recalc doesn't help, but minimal editing of the
> formula makes it work OK; also if you try to drag the wrong value 6 from,
> e.g., D3 into D4, the value in D4 would be 60; dragging the 6 from D3 into
> D4:D5 gives two 24s.

reproducible with:

Version: 6.5.0.0.alpha0+ (x64)
Build ID: d04eef858250f97690f32dba17f42d157a8767fc
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: default; VCL: win; 
Locale: de-DE (de_DE); UI-Language: en-US
Calc: threaded

btw: a save & reload will fix it too, even with [Never Calculate] on load
enabled

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20191120/7cab4cd2/attachment.html>