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]
