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
