>
> Mr. Perry, thank you for the quick response.
>
> I appear to have been unclear.
>
> The original formula in Excel is:
>
> =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.
> (A further test in D14 ensures that if it would come up as a 0, the
> cell is set to empty; that part works just fine in Calc as near as I
> can tell.)
>
> I can make this work in Data > Validation in Excel.
>
> I cannot make its cognate work in Data > Validity in Calc, where it
> gets translated to:
>
> IF('Ship Builder'.D14="";Blank;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. Potentially this should be a request for enhancement (or bug report - depending on which way you look at it)... Below is a link which provides information on how to lodge either: http://qa.openoffice.org/issue_handling/pre_submission.html#duplicates /paul -- Processing Key for cracking HD DVD's: 09 F9 11 02 9D 74 E3 5B D8 41 56 C5 63 56 88 C0 ----- Try Torpark; a small portable, open-source, built on Firefox browser that enables anonymous browsing. Requires no installation : http://www.torrify.com/
