Thank you, Eike. The formulation I gave would work in 2.2.3? On 7/30/07, Eike Rathke <[EMAIL PROTECTED]> wrote: > Hi Paul, > > On Monday, 2007-07-30 08:41:22 +1200, Paul wrote: > > > > =IF(D14="",Blank,Action_Points) > > > > > > Which means that if cell D14 is empty, use the named range Blank to > > > populate this drop down list, else use the named range Action_Points. > > > [...] > > > > > > Have you managed to get a similar formulation to work in OpenOffice, > > > in the dialog box for Data > Validity? > > > > I've tried in both calc and Excel. It does work in Excel, but it doesn't in > > calc. There are however some differences with what is offered in each - > > which could be the problem. > > That sounds pretty much like what got implemented for the upcoming > OOo2.3 release: > http://sc.openoffice.org/servlets/ReadMsg?list=features&msgNo=231 > > Eike > > -- > OOo/SO Calc core developer. Number formatter stricken i18n transpositionizer. > SunSign 0x87F8D412 : 2F58 5236 DB02 F335 8304 7D6C 65C9 F9B5 87F8 D412 > OpenOffice.org Engineering at Sun: http://blogs.sun.com/GullFOSS > Please don't send personal mail to this [EMAIL PROTECTED] account, which I > use for > mailing lists only and don't read from outside Sun. Use [EMAIL PROTECTED] > Thanks. > >
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
