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.
pgpCtZCRGsZ7Q.pgp
Description: PGP signature
