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?
On 7/28/07, S Perry <[EMAIL PROTECTED]> wrote:
> This must be frustrating for you.
>
> First, you should know that =IF(D15=""...) is not equal to =IF(D15=0...).
> The former may indeed evaluate to "0", but then again it may not, depending
> on whether you have formatted the cell as a number or text.
>
> You may be introducing some of these errors unknowingly with your misusing
> the term format as you applied it to the structure of a formula. Format
> refers only to attributes such as font, point size, bold, italics, color,
> etc., type (text/date/time/number/currency) and not to the structure or the
> form of your equations.
>
> What you say you use in Excel (IF('Sheet Name'.D15=0;Blank;Action_Points) is
> common, in fact I use it myself frequently. However, your second argument is
> one that I've never used, i.e. "Blank;" it may be perfectly acceptable and
> perhaps I've just never encountered it for some reason.
>
> There are many fine minds who contribute to solving the problems presented
> to the mailing list who would more than likely be able to help you. When you
> have checked what is mentioned above and ascertained the other items you
> referred to but are not ready to be discussed, please write again.
>
>
>
>
>
>
> Ken Burnside <[EMAIL PROTECTED]> wrote:
> I use data validation to make my spreadsheets more idiot proof.
>
> I've found the feature in Data > Validity that does this, and for
> simple cases, it's good.
>
> However, I'm doing something that is apparently not yet implemented.
>
> I commonly use list validations in the format of:
>
> =IF(D15="",Blank,Action_Points)
>
> in Excel.
>
> When opening the sheet in OpenOffice, this gets translated to:
>
> IF('Sheet Name'.D15=0;Blank;Action_Points)
>
> By nesting the IF statements, I can have drop down lists that
> dynamically change based on other variables selected by the user.
>
> Now, as near as I can tell, it translated the format exactly, and that
> SHOULD work, but it doesn't. It seems that the logical operators
> aren't functioning here, or are functioning very strangely.
>
> I have another issue (with conditional formatting) that's also
> cropping up, but have yet to isolate to the point where i can discuss
> it intelligently. (An Excel sheet with lots of conditional formatting
> has SOME of the CF working properly, but not all - and what's deucedly
> odd is that the places where it's not working, the conditions are
> identical to where it is.)
>
> My motivation for doing this in Calc is that some of my customers want
> design spreadsheets for my games in OpenOffice format; if I can get
> this to work, I can get some volunteers to maintain it while I work in
> Excel doing primary development.
>
> I will cheerfully send out the spreadsheets for someone with more
> experience to examine, and can offer some guidance as to what SHOULD
> be happening.
>
> Ken Burnside
> Ad Astra Games
> http://www.adastragames.com
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
>
> ---------------------------------
> Fussy? Opinionated? Impossible to please? Perfect. Join Yahoo!'s user panel
> and lay it on us.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
