Issue 74569 - validate with indirect with named range list
Summary: validate with indirect with named range list
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.1
Hardware: All Windows XP
: P3 Trivial with 1 vote (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2007-02-15 11:28 UTC by harry_tempelaar
Modified: 2013-08-07 15:12 UTC (History)
3 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

Sample file indirect (14.50 KB, application/
2007-02-15 11:29 UTC, harry_tempelaar
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description harry_tempelaar 2007-02-15 11:28:02 UTC
To simplify choosing from a list, i use validate to select for example office.
To make a second selection i use a the validate option with an indirect
reference to the first field. In excel this is like "=Indirect(f11)". A choice
can be made which depends on the first choice. When the xls is imported in OO
2.1 th "=" is missing and the function does not work any more.
A sample test Xls is added to show the problem
Comment 1 harry_tempelaar 2007-02-15 11:29:26 UTC
Created attachment 43031 [details]
Sample file indirect
Comment 2 dalo 2007-02-16 18:46:07 UTC
I confirm this behaviour on OOo 2.1 XP.
The second validation field is blocked because the =indirect(F11) function is
not recognised at all with or without the =.
Comment 3 kpalagin 2007-02-17 06:00:01 UTC
Confirming with 2.1 and 2.2m5 - list-box in I11 does not work. The one in G11 
does work.
Comment 4 frank 2007-02-19 13:41:07 UTC

not a bug but an enhancement request. Re-flagged and re-assigned to requirements.