[Libreoffice-bugs] [Bug 134485] New: formula copied from another sheet does not work

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 134485
           Summary: formula copied from another sheet does not work
           Product: LibreOffice
           Version: 6.4.4.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: TorrAB at Yahoo.com

Description:
Open absp.ods, select cells A1…B5, copy&paste (^c, ^v) them to Sheet2.
        On Sheet2, change the value of bb (cell B2); the values of s and p are
not updated! Recalculating (f9, ^F9) does not help.
        Return to Sheet1, change the value of bb; the values of s and p are
updated on both sheets! Not expected, since aa and bb are local (sheet-level)
variables, as indicated by the quotation marks, eg, in cell B5: ='aa'+'bb'. On
the other hand, cell B7 uses variable cc unquoted: =2*cc.
        The user should be able to modify, use (and trust! No 6+5=8) Sheet2
without remembering that it was copied from another sheet.


Steps to Reproduce:
1.Open absp.ods, select cells A1…B5, copy&paste (^c, ^v) them to Sheet2.

2.On Sheet2, change the value of bb (cell B2)
3.

Actual Results:
the values of s (=aa+bb) and p (aa*bb) are not updated.

Expected Results:
all calculations using bb should be updated


Reproducible: Always


User Profile Reset: No



Additional Info:
none

-- 
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/20200703/36bdc569/attachment.htm>