[Libreoffice-bugs] [Bug 134485] Formula with Names as Addressing copied from another sheet calculates per original sheet

[bugzilla-daemon at bugs.documentfoundation.org]

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

Timur <gtimur at gmail.com> 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 at libreoffice.
                   |                            |org

--- Comment #7 from Timur <gtimur at gmail.com> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200730/d3f8ec97/attachment.htm>