[Libreoffice-bugs] [Bug 135514] calc: formula: 'label' references not properly adapted when moving cells | was: identical formulae give different values

[bugzilla-daemon at bugs.documentfoundation.org]

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

b. <newbie-02 at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
            Summary|identical formulae give     |calc: formula: 'label'
                   |different values            |references not properly
                   |                            |adapted when moving cells |
                   |                            |was: identical formulae
                   |                            |give different values
            Version|7.0.0.1 rc                  |3.5.1 release
                 CC|                            |newbie-02 at gmx.de
             Status|UNCONFIRMED                 |NEW
     Ever confirmed|0                           |1

--- Comment #7 from b. <newbie-02 at gmx.de> ---

hello @TorrAB at Yahoo.com, 

nice sample of 'nagging spreadsheets', ;-) 

imho initial fail B2 isn't set 'dirty' or 'changed' when you 'steal' the
content with a mousedrag, opposite to what happens when you use ctrl-x, 

(you can also move single cells with the mouse by [click - shift-click -
click-drag])

(additional fail: if you 'throw' the 'ctrl-x-ed' content of B1 somewhere else
on the sheet it's calculated in B3, in old versions only the cutted value?, in
7.1 you can even calculate with cells moved that way)

(probably it's dependent / affected by settings regarding 'automatically adapt
...' i'm not a pro in that) 

workarounds: 

- use keyboard for such operations, 

- 'non changing edit' of B3 recalculates, which F9 and ctrl-shift-F9 don't do
:-(

- give up using label references in formulae ... as ex$el did in ver. 2010, 

- wait for an interested developer, 

fail already in 3.5.1.2, assume 'inherited', 

setting 'new', 

trying to raise importance (not allowed to me, would somebody with app. karma
do?) as: 

- bug may affect plenty other operations as well, 

- bug creates confusing sheets, 

- 'trapping errors' may spread, 

- recalc doesn't work, 

- even 'forced recalc' keps wrong results,

-- 
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/20201101/1b77731b/attachment.htm>