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
Created attachment 162614 [details] file with 2 sheets
This bug is severe; it gives wrong results without any warning.
I think you need to define the label ranges, so first they are searched in the same sheet. https://help.libreoffice.org/6.4/en-US/text/scalc/01/04070400.html?&DbPAR=CALC&System=WIN
Created attachment 162760 [details] screenshot of DefineLabelRange, Sheet2
[Automated Action] NeedInfo-To-Unconfirmed
I was doing some testing and I figured that labels aren't optimal. Instead of using 'aa', I think one good way is to refer to the cells not by labels, but by the order of the spaces (for instance, B1+B2). That way it could work.
We need to explain exactly how and why ='aa'+'bb' sums B1 and B2. Those are not defined ranges, but cell contents, unlike cc, which is global name. Screenshot attachment 162760 [details] does not correspond to attachment 162614 [details]. Those are Names by Addressing: https://help.libreoffice.org/7.1/en-US/text/scalc/guide/address_auto.html?&DbPAR=WRITER&System=WIN Also at https://help.libreoffice.org/7.1/en-US/text/shared/optionen/01060500.html?System=WIN&DbPAR=CALC&HID=modules/scalc/ui/optcalculatepage/OptCalculatePage#bm_id3149095 Now we have 2 possibilities: 1. call this a bug, expect LO to keep separate Names per sheet, which complicated this a little, also what if same names are repeated on a sheet; 2. accept that this is helpful but of limited use (Lo is guessing cells) and take case of proper naming with single name for formula use, avoid copying and just update Documentation. I'll confirm so far as Documentation. In any case, it should be updated so this is clarified. Further discussion is welcome.