Issue 116645 - listbox - allow reference values for source cell range
Summary: listbox - allow reference values for source cell range
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 3.3
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2011-01-26 18:09 UTC by Oliver Brinzing
Modified: 2014-01-15 19:10 UTC (History)
4 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

Attachments
listbox_reference_values (15.04 KB, image/gif)
2011-01-26 18:09 UTC, Oliver Brinzing 		no flags Details
listbox_ref_value_demo (10.24 KB, application/vnd.oasis.opendocument.spreadsheet)
2014-01-15 18:36 UTC, Oliver Brinzing 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description Oliver Brinzing 2011-01-26 18:09:00 UTC 
it is not possible to write reference values if a source cell range is used.
only "Position of selected entry" or "The selected entry" are possible.

a values source range would be a great help.

see issue http://www.openoffice.org/issues/show_bug.cgi?id=116642
for data validation dropwdown listbox.

please have a look at the attachment
Comment 1 Oliver Brinzing 2011-01-26 18:09:31 UTC 
Created attachment 75667 [details]
listbox_reference_values
Comment 2 Edwin Sharp 2014-01-15 14:45:34 UTC 
Please attach spreadsheet.
Comment 3 Oliver Brinzing 2014-01-15 18:36:50 UTC 
Created attachment 82296 [details]
listbox_ref_value_demo

it's not possible to write reference values to a cell. this can anly be done by using a formula

btw: attached file will also show the bug:
[Bug 124008] listbox entry's are selected automatically on mouse over instead of mouse click
https://issues.apache.org/ooo/show_bug.cgi?id=124008
Comment 4 Edwin Sharp 2014-01-15 19:10:43 UTC 
Thank you.

Confirmed with
AOO410m1(Build:9750)  -  Rev. 1557669
2014-01-14_04:11:13 - Rev. 1557927
Debian