[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

--- Comment #4 from Oliver Brinzing <oliver.brinzing at gmx.de> ---
Created attachment 150259
  --> https://bugs.documentfoundation.org/attachment.cgi?id=150259&action=edit
simple test case created with excel 2016

created a simple test case with ms excel 2016:

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"

steps to reproduce:
- open *.ods attachment "simple testcase"
  https://bugs.documentfoundation.org/attachment.cgi?id=150256
- save as *.xlsx
- open with excel
- Sheet2.B5 dropdown list now displays values from cell range: Sheet1!$A$1:$A$3

-- 
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/20190324/79bacbcb/attachment-0001.html>