https://bugs.documentfoundation.org/show_bug.cgi?id=134485
Timur <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Summary|formula copied from another |Formula with Names as
|sheet does not work |Addressing copied from
| |another sheet calculates
| |per original sheet
Status|UNCONFIRMED |NEW
Ever confirmed|0 |1
Component|Calc |Documentation
Severity|normal |enhancement
CC| |olivier.hallot@libreoffice.
| |org
--- Comment #7 from Timur <[email protected]> ---
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 does not correspond to attachment 162614.
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.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
