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

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Wed Nov 11 21:52:28 UTC 2020


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

--- Comment #5 from Jax <HeartwoodJack at gmail.com> ---
Thanks all,

Attached is an image of the sheet and also a sample file.

Instructions to replicate:

1. Create new sheet with a horizontal series of cell entries (see attached)
    e.g. C3=Hourly  D3=Daily  E3=Weekly
2. Enter Form Design Mode
3. Insert > Form COntrol > List Box  Then draw the box on the sheet
4. Right Click on the List Box and select Control Properties
5. Choose Data tab
6. Enter a cell address in 'Linked Cell'
    e.g. G13
7. In Source Cell Range, enter the horizontal range
    e.g. C3:E3
8. Leave Form Design Mode
9. Select the List Box and I only see Hourly as an option

-- 
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/20201111/cbb8358a/attachment.htm>


More information about the Libreoffice-bugs mailing list