[Libreoffice-bugs] [Bug 138106] New: Forms: List Box: Source Cell Range - Doesn't allow horizontal range e.g. C14:F14

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 138106
           Summary: Forms: List Box: Source Cell Range - Doesn't allow
                    horizontal range  e.g. C14:F14
           Product: LibreOffice
           Version: 6.4.6.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: HeartwoodJack at gmail.com

I wish to refer to a horizontal range and use as the 'Source Cell Range' for a
'List Box' when making a form.

The list box only shows the first item in the array.

Is there a rationale or is this a bug?

I've tried a workaround using Transpose but have hit a wall of awkward...

-- 
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/20201109/38fd245e/attachment.htm>