Summary: | Formula with Names as Addressing copied from another sheet calculates per original sheet | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | TorrAB |
Component: | Documentation | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | enhancement | CC: | miguelangelrv, olivier.hallot |
Priority: | medium | ||
Version: | 6.4.4.2 release | ||
Hardware: | All | ||
OS: | All | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Attachments: |
file with 2 sheets
screenshot of DefineLabelRange, Sheet2 |
Description
TorrAB
2020-07-03 15:08:42 UTC
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. |