[Libreoffice-bugs] [Bug 124307] FORMATTING: Data validity produces empty drop list for a named cell range

[bugzilla-daemon at bugs.documentfoundation.org]

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

Eike Rathke <erack at redhat.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |NOTABUG

--- Comment #6 from Eike Rathke <erack at redhat.com> ---
(In reply to Oliver Brinzing from comment #3)
> if you open the "Manage Names" dialog (Ctrl+F3) on "Sheet1" the named range
> will point to "Sheet1.$A$1:Sheet1.$A$4", if you do same on "Sheet2" it will
> point to "Sheet2.$A$1:Sheet2.$A$4".
Normal behaviour because the sheet references are relative (not absolute
without a leading $)

(In reply to Oliver Brinzing from comment #4)
> LO will import a *.xlxs spreadsheet with global named range:
> =Tabelle1!$A$1:$A$3 to $Tabelle1.$A$1:$A$3.
> 
> and will export "global" named range "Sheet2.$A$1:Sheet2.$A$4"
> (defined on Sheet1) to "Sheet1!$A$1:$A$3"
Both is expected, because Excel does not know relative sheet references.
Nothing we can do about.

Not a bug.

-- 
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/20190325/a30c0c8d/attachment.html>