[Libreoffice-bugs] [Bug 137896] New: Local names in Calc

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 137896
           Summary: Local names in Calc
           Product: LibreOffice
           Version: 6.4.7.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: yestok at yestok.pl

Is this an extra property or a bug?
In Calc is possibility defining a names with local scope, only for one sheet.
The name may be use only in this sheet (?).
But is possibility use this name in any sheets when the name will be preceeded
by by sheet's name. 
For example if name ABC is defined in AAA sheet as local, may be used in
another sheet by write AAA.ABC e.g =124+AAA.ABC or INDEX(AAA.ABC;1;1). 
If write the local name with name of sheet, then name of sheet is automatically
removed when this name was placed to  her own scope.
It is good news.
But this name not could be use in INDIRECT function. INDIRECT("AAA.ABC")
generate #REF! error and e.g formula INDEX(INDIRECT("AAA.ABC");1;1) is not
calculate.
 Also is not possibility inserting the name by "Insert -> Named Range or
Expression" in another sheet then this who have definition local name.
If first part of my post is true (is the extra property), then would be good 
should remove the imperfections described in the second part.

-- 
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/20201031/45151047/attachment.htm>