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.
