Further to my prior emails, repeated here. You are conspicuous by your
absence! Amn I the only one having problems with OO 3.3. I have found OO 3.2,
uninstalled OO3.3 and installed OO 3.2; everything is working again OK.
Should it still be of interest, I again include the attachment demonstrating
the problem.
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 in 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 (",").
Attached is an example of the problem wherin I have pasted the VLOOKUP
instruction, Paste Special Text; Paste Special Numbers yields a blank.
In downloading OO3.3, OO3.2 is gone. Can I reload that, because right now
I'm out of business!
Yout thoughts on this will be appreciated. jreyr
OO3 Arithmatic Problem.sxc
Description: Binary data
