Re: Open Office 3.3

Am 05.03.2011 01:23, [email protected] wrote:
> I loaded the subject yesterday and now substantial portions of my
> soreadsheets are not functioning. As far as I can tell at this point, one  problem
> revolves upon VLOOKUP and HLOOKUP functions are bringing numeric values  as
> text, in that arithmetic functions on them yield "#VALUE". When I manually
> re-enter the value the arithmetic is carried out OK. The VLOOKUP   and
> HLOOKUP are functioning correctly insofar as bringing in correct values. I  have
> attempted a Paste Special of the values, de-selecting Text and selecting
> Numbers to no avail. If I can't find a remedy, I will have to revert to Excel.
> I  also have found OO3.2 and Excel to be incompatable maminly, I think, due
> to one  using semicolon (";") delimiters and the other using colons (",").
>
> Yout thoughts on this will be appreciated. jreyr--
> -----------------------------------------------------------------
> To unsubscribe send email to [email protected]
> For additional commands send email to [email protected]
> with Subject: help
>

Why such a long but vague description? Can't you simply paste your 
formulas, what they return and what you expect them return?
Recent versions fixed a severe bug where ambiguous numeric strings 
evaluated to numbers. Most likely your formulas exploited that bug.
Older versions of OOo (and Excel still) return different results for a 
text like "1,234" or "1.234". Depending on the locale context it 
evaluates to one-thousand-two-hundred-thirty-four or one point 234/1000. 
Same problem with string "1/2/1999" which evaluates to 2 different dates 
on either side of the Atlantic.
Only numbers are unambiguous.
Only numbers can work with numeric functions. Even when your text values 
work with A1+B1 they will certainly fail in SUM(A1:B1).
Only numbers do compare correctly to other numbers.
Numeric strings are deprecated unless used as identifiers, zip codes, 
part "numbers" where the numeric value is not relevant. But then you 
have to compare or lookup text values. Character "1" will never be equal 
to number 1.

--
-----------------------------------------------------------------
To unsubscribe send email to [email protected]
For additional commands send email to [email protected]
with Subject: help