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

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sun Mar 24 14:26:35 UTC 2019


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

Oliver Brinzing <oliver.brinzing at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |oliver.brinzing at gmx.de

--- Comment #2 from Oliver Brinzing <oliver.brinzing at gmx.de> ---
Created attachment 150256
  --> https://bugs.documentfoundation.org/attachment.cgi?id=150256&action=edit
simple testcase

the behaviour is reproducible, 
but i tend to say it is invalid cause the global named range 

"PHPP_Daten_Ausrichtung_Bauteil" points to cell range
"Sheet1.$A$1:Sheet1.$A$4" 

instead of "$Sheet1.$A$1:$Sheet1.$A$4" or "$Sheet1.$A$1:$A$4"

if you enter values in Sheet2.A1 - Sheet2.A4 they will appear 
in data validity cell Sheet2.B5

-- 
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/23bd4856/attachment-0001.html>


More information about the Libreoffice-bugs mailing list