Open Office 3.3
| Newsgroups | gmane.comp.openoffice.general |
|---|---|
| Message-ID | <[email protected]> |
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